That returns the max data length for those items you want to update... not all items.  That not-with-standing, it looks to me like you have well under the 8000 characters...

Not really... if you create a # temp table (non-global) in a proc, that temp table will be available in any proc below that because it's the same session (although it's...

Hari... are you calling the function using SQL that's embedded in the GUI code?  If so, Koji is absolutely correct... the code must add the outer quotes as part of...

Heh... you're right, David.   But it was easy to find... just clicked on the author's name and looked at the previous posts for...

I'm sorry Vamshi... I didn't mean to sound so outragous about what you wrote.  It's outstanding that you're diving into a book (although you might want to get a different...

If you're partially migrated, do it in SQL Server, now.  If you continue to build new things in the old system, you will simply prolong the migration and maybe even...

Not if you sink the boat in the process.  There may be a reason the manager wants things done a certain way (it's usually political).  Of course, the manager just...

Very nicely done, Peter.  Nasty fast, too!

Are you fighting lots of XML indexes?

What the max DATALENGTH of the text column, please?

If you copied the data through a linked server to a temp table like you did with OPENROWSET, the speed would be the same.

The problem with OPENROWSET is that the...

Heh... so write the triggers to send him personal pages and emails when the triggers fail   That will make him keenly aware of...

I'm thinking that it's a bad idea to use a trigger for this... what happens when one of the servers is down for some reason?  You got it, the other...

This looks a lot like homework or an interview question... please post what you've tried and we'll go from there.