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...

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...

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...

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...

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...

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...

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:

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...

Lowell (7/1/2011)

---

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...

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...

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...

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...

I'm getting caught up on words i guess.

OPENROWSET is not used to export...my...

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...

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...