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

i just tested it, and it would not work; created a word doc with "[header]" in the header,"[footer]" in the footer, and "[body]" in the main document;

saved it and...

if your template has a keyword you could search for, like a token of "[footer]" that you could search for and find/replace as a raw text string, that might be...

All right! things are going to be so much easier now!

so when i define a table, i can decide to use my own default ie, "1" for the default value,...

because the data is quote delimited, you'll need to use a format file, i think; BOL or a google search will be your best bet to help you research and...

you definitely should follow Jeff's advice and add a datetime column to the table; it'll save you a lot of toruble, and is harmless:

ALTER TABLE [tblCustomerImages] ADD [CreatedDate] DATETIME DEFAULT...

I'd also note that Referential Integrity is a best practice; be sure to read all the articles on Best Practices /Worst Practices here on SSC to get a good flavor...

basically, you'd replace #EXAMPLE with the query(in parenthesis) you were going to use; without all the CREATE TABLE info, there;s nothing i could test based on the sql you posted;...

it looks like you want to get duplicate rows, but ignore the Title, right? I'd probably not partition on the date, either, but look at this and see if it...