Your script is good, however you always need to ensure you include schema in queries like this, when you don't, you run the risk of similarly named objects grouping together...

No probs, glad I could help.

I find enabling RPC assists in communications between the 2 SQL servers.

I've got a SQL 2005 Standard Server (ServerA) talking to a SQL 2005 Express (ServerB) server. Initially inserts...

Thanks for your feedback, I found the culprit and have made a change or two. It now works for ntext and uniqueidentifier. I've put the update on the original script,...

That story was hilarious,

I have one that I thought was pretty good. It happened to a colleague of mine. He was liaising with a customer and trying to get them...