Not sure why you don't just let the tools do it for you... if you use EM to make the change, it will do everything for you... no fuss, no...

You had an Assembler?  Lucky you... Much of the code I wrote in the "good old days" was hand-assembled machine language... now THAT was fun

Looks like I'm not the only one that can't sleep... thanks, Prasad.

And they say understanding underlying data structures is no longer important... the '00' unicode country code in these examples sticks out like a sore thumb to anyone who has seen...

Conversions are a bit costly performance wise... the following works approximately 45% faster on a million row test...

 SELECT DATEADD(dd,DATEDIFF(dd,0,GETDATE()),0)

S'ok... I've been with SQL Server since it was 6.5 and I keep wondering when the next fault will occur

Outstanding... Thanks for the feedback, Michael.

Then I think you need to take Serqiy's advice... he wasn't talking "Trojan Horse" as in "Virus"... he was talking about taking the easy way out with NVARCHAR(MAX) which is...

Sounds like you did your homework... glad it worked out.

Here's a simple one... the only problem with it is if a table name straddles an 8 k boundry... then it will miss the table name...

--Find name of...

What do you mean when you say it "timed out"?  What app are you in?

Thanks Serqiy.  Nope, I haven't actually lost my mind (yet).  I think just about everyone except the guy who wrote that knows that creating indexes on bit columns is a...

I dunno wth he found but I kinda like the looks of the calculated column... could be sargeble that way...

I'm a bit confused... are you trying to import the file (your comment about Bulk Insert) or are you trying to export to a text file and have the date...