Viewing 15 posts - 1 through 15 (of 22 total)
ok so LIKE:
select * from table where description LIKE '%ear%'
would return row with "ear", "ears", "bears", "years", "earth", "my ear hurts", "my ears hurt", etc
now...
November 22, 2018 at 6:04 am
yes i've been using contains. The LIKE does return the row. Contains doesn't.
November 22, 2018 at 5:32 am
thanks if you can, please do. i have started having a play with bulk insert...
July 6, 2018 at 8:00 am
thanks, but my source is a text file supplied by a 3rd party, something they produce. so i have no control over the production of that.
i'm not bcp'ing out,...
July 6, 2018 at 6:44 am
Thanks all. So a sample from the supplier documentation re the schema of one of the flatfiles...
February 22, 2018 at 2:31 am
thanks. we have cozyroc, i'll take a look as to how much better they could be.
No, the target tables are not yet defined/created either.
February 21, 2018 at 9:01 am
There's 5, some small 2or 3 tens of GB.
July 2, 2015 at 1:08 pm
Great. Thanks. Yes thought about mirroring instead. Have to now because DB doesnt have primary key on every table anyway. Thanks again.
July 2, 2015 at 11:28 am
Thanks for your reply. That's reluctantly acceptable - what about hiding the other system DBs and user DBs? If msdb has to be visible then that's fine.
March 12, 2015 at 3:09 am
Thanks very much for the quick reply Gail.
June 20, 2014 at 2:26 am
Ok thanks for the quick reply.
What are the security concerns around either ?
June 17, 2014 at 4:48 am
great stuff. thanks a lot for the help. much appreciated.
October 30, 2012 at 6:15 am
if the above is probably the only way, then yes. how is the above achieved within RS Config Manager?
(is the above not achieved by simply creating the two folders at...
October 26, 2012 at 3:35 am
issue solved. there are msdb stored procedures used to create/add servers and groups you enter into your CMS setup in SSMS. the names escape me, but if you trace it...
October 25, 2012 at 1:43 am
Viewing 15 posts - 1 through 15 (of 22 total)