Viewing 15 posts - 46 through 60 (of 536 total)
John is correct in what he says. Your query will return Bob and Robert if you add that where clause.
What you are trying to code from what you have...
March 29, 2012 at 8:34 am
Jeff Moden (6/9/2011)
An OPENROWSET through either JET or ACE drives will handle this automatically.
Thanks Jeff. ill take a look at that also.
I think i have managed to persuade the...
June 9, 2011 at 4:45 am
GSquared (6/7/2011)
Alternately, and worth looking into, would be to import the data into a single text column, then parse it using a multi-character delimiter, then Pivot it into columns.
That is...
June 7, 2011 at 3:35 pm
Lowell (6/7/2011)
is every field dbl quote delimited, regardless of value being integer, decimal or string, or just strings?
No, only the text delimited fields can be like this and even then...
June 7, 2011 at 3:33 pm
not sure how you can just say do a full reindex without any information whatsoever.
first thing you need to do is a bit of information digging. find out what...
April 15, 2011 at 3:58 am
Ratheesh.K.Nair (4/14/2011)
Hi,How to had more tahn 100 tables to an existing replication?
Now i am using sp_addarticle for each table. Is ther any other way?
TIA
100 more tables? If your ending...
April 14, 2011 at 8:46 am
george sibbald (2/7/2011)
February 7, 2011 at 9:15 am
well spid 51 is the first available spid to a non system process so i would guess its a job/application thats connecting as soon as SQL starts up.
assuming the use...
February 7, 2011 at 8:48 am
First place to look is the windows application log, SQL log and SQL agent logs. See if you can fathom whether someone is sending a stop command.
February 7, 2011 at 7:30 am
you can remove the builtin/administrators account just like you can any other. Just make sure that you have another admin account that you know definately works. or have...
October 26, 2010 at 7:33 am
you have kind of answered your own question. the answer is in the logic of the trigger. so if there is an insert command on each trigger, say...
October 26, 2010 at 7:29 am
winash - if you can find that article id be interested in having a read. that sounds like a really nice reporting solution!
October 22, 2010 at 2:23 am
ananda.murugesan (10/21/2010)
Thanks for yours reply..Is it possible direct depoly SP3 on sqlserver workgroup edition?
rgds
ananda
yes, it includes all the updates included in SP1 and SP2
October 21, 2010 at 4:52 am
It seems this is a sql design "issue". Once a database is marked for replication ALL objects - whether or not they are replicated - call the sp_MSmerge_ddldispatcher procedure....
October 15, 2010 at 5:19 am
Viewing 15 posts - 46 through 60 (of 536 total)