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.

PLEASE!  If you want help, post the offending query that gave you the error!

Good lord, NO!!!!   Vamshi, I know you're kinda new at this, but holy mackeral this is bad!  And, if you didn't write it,...

Just an FYI...Don't forget the other difference... UNIQUE key allows 1 NULL as a value... Primary Key won't.

And, you can also build a PK without it being clustered, although there...

Anthony... it's bad form on this forum to post the same question more than once... ticks people off.  Go to your other thread and read what I posted.