Since I don't use DTS or SSIS for this type of stuff... what happens to the data that caused the error?  Can the error handler be made to save the...

Heh... thanks Lowell

Aye... nicely done, Lowell... and, I think you'll really like this, as well

Just in case someone can't use xp_CmdShell, there's a little known...

That's kinda why I use BCP for this type of stuff... you can program BCP to survive just about any error and squirrel the "bad" rows in a separate file...

Hust for a point of reference... we set TempDB to be 9 gig on bootup.

You are correct... things are going to get a little complex because you need a query to build a dynamic query from Master.dbo.SysServers.

For more reasons than I can count, you will likely regret the day that you used Text or NText if there's any chance of ever needing to edit the column.

Creating...

Did you TRY it?

Ganapathi,

It's good that the code works... but do you know WHY it works?

The only thing I can see that might be doing this is your 11PM DB Maintenance job... check it and see if you are "regorganizing" the data... there's at least...

You bet... thanks for the feedback...

We still don't have a clue how long this job may last, Bill. 

Mary,

Lowell's code is great but, as he said, there's a bit of a performance problem... takes about 4 and a half minutes to return 100,000 rows.  The following function is about...

The problem is that c.Text is an NVARCHAR column of 4000... don't forget that this is UniCode and contains 2 bytes per visible character so it's really 8k if the...

Karthik,

You didn't believe me?

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=395872#bm396072