Viewing 15 posts - 7,216 through 7,230 (of 13,460 total)
SSMS is not the ideal tool to display varchar(max) fields, as GSquared was implying:
one of the settings it uses for increasing perforamnce can also prevent the full text of a...
July 5, 2011 at 9:58 am
an update statement with a WHERE follows the WHERE restrictions, so if you are getting more rows affected than you expect, the best thing to do is look at...
July 5, 2011 at 9:15 am
i've used SQLBulkCopy for moving data from other sources to SQL, and i like it a lot...it is really fast.
i suspect the SELECT * stuff you are seeing is probably...
July 5, 2011 at 8:49 am
OK Babu, say you've presented a list of views in your GUI, and the end user selected one of them.
i don't think you need any other parsing DLL at...
July 5, 2011 at 6:17 am
yeah it was a little work to find;
all this work is from a Win7/64 bit OS.
my example assumes you installed SQL Server 2008; although i installed 64 bit, the specific...
July 2, 2011 at 11:32 am
if you are not hosting it yourself, you just have to trust that the DBA is a professional, and does not to want to steal your data
there's another thread running...
July 1, 2011 at 2:57 pm
too many windows open!
i editit it off in another window, and then when i thought it was ready, hit the "reply" on the wrong tab...
I'm properly admonished now, thanks!
:w00t:
July 1, 2011 at 2:47 pm
here's a simple script to search both the job steps in msdb as well as the current database's stored procedure definitions.
this might point you to something to investigate.
I actually had...
July 1, 2011 at 2:28 pm
Lowell (7/1/2011)
since you said it happens "regularly, maybe there's an obscure snippet in a job or something
IF EXISTS...
July 1, 2011 at 2:16 pm
any chance there is a script or job doing something like this?
since you said it happens "regularly, maybe there's an obscure snippet in a job or something
IF EXISTS (SELECT...
July 1, 2011 at 2:16 pm
i've always done this with dynamic SQL; it makes for better execution plans.
my "search function makes all searches with "starts with" for text fields, and exact matches for numbers.
so searching...
July 1, 2011 at 2:02 pm
Babu thanks for giving me something new and interesting to play with; being able to parse a statement has a lot of possibilities.
i found an example in german here: http://olafhelper.over-blog.de/article-34700638.html
i...
July 1, 2011 at 11:48 am
mihir.nasikkar (7/1/2011)
Is there any option other than OPENROWSET to export the result set into excel spreadsheet ?Thanks
I'm getting caught up on words i guess.
OPENROWSET is not used to export...my...
July 1, 2011 at 9:27 am
OLE DB provider "Microsoft.Jet.OLEDB.4.0" is a 32 bit driver...so if your sql instance is 64 bit, you'd get that error.
you probably need to download the updated 64 bit ACE drivers...
July 1, 2011 at 8:08 am
what error do you get?
i think bcp exports as raw text only, so any resulting file, no matter what extension you put on it, needs to be opened in something...
July 1, 2011 at 7:02 am
Viewing 15 posts - 7,216 through 7,230 (of 13,460 total)