yeah i've used this code for a "schema checker" which compares a database to various xml docs;

based on an internal table, if your db is marked "version 4" or...

COLUMNS_UPDATED is very misleading; it returns true if the UPDATE statement happens to include the column in sql statement, not whether it's value changed;

I believe since you cannot manipulate text/image...

wow excellent catch David! I rarely work under multiple schemas, and certainly missed this!

I've updated my code and previous links to have the correction you mentioned, and you can downloaded...

i think i've seen this before, where version 539 is not a release-to-market version of SQL , but one of the preview versions.

I had that issue where i could not...

i've never scripted images out, mostly because they can't be represented in a string;

this link might help you, but everything i've ever seen shows that you have to treat images...

you'd have to show us the sql statement...it's a simple syntax error, but we'd need to see the statement to help.

a new, seperate instance would have a greater impact on a machine than simply making tempdb starting with more than enough room to handle expansion needed by your apps calculations....

something like this? you can use a case statement in the ORDER BY for custom results.

ORDER BY

CASE

WHEN YOURCOLUMN = 2 THEN 10

WHEN YOURCOLUMN =...

Joy i believe that is a function of the application that is doing the connecting...for example SSMS will wait forever, whereas any application that is creating an instnace of a...

ironically, since the OP posted to the forum, he gets another email every time we post to the thread,

because he hasn't unsubscibed from the thread, which is different from...

if you are sure the image field contains text that was converted to varbinary, then you need to convert to nvarchar isntead of varchar i think.

here's a proof of concept:...

that is not true; I can understand how it might seem...

when you add the column with the default, you could include the WITH VALUES statment so that existing data gets the new default; then you would not have to update...

i use this a lot; it's ideal for finditng tablenames or column names that you are looking for.

stick in in the master db:

sp_find inv

finds all tables, and then all columns,...

andrew sysforeignkeys can get you all the relationships, but it's all integers in there; you have to use some functions to get the data out where it's human-readable.

for example, if...