1. How identical is identical?

2. If you reverse the two servers completely - by transferring all content of server A to server B, and then transferring all original...

This feels familiar, like it's been posted and answered before. Have you searched the forums for like issues? You may get some hints, or even answers, there (here).

More simply, you need to use the Upgrade Advisor by running it against the 'before' environment. Loading the database into SS 2k5 is placing the content into the 'after'...

Do you have a 'test' environment? As part of your 'promotion' you will want to experiment with actually performing restores (NOT in production environment), so that when you have...

What else is running that could 'grab' row handles? At what point in your processing are you getting this message? Do you believe this message is legitimate or...

scope? scale? what's the size of the problem you are trying to solve?

IF I remember correctly, to capture the 'RIGHT(value,1), you will need to use a 'SUBSTR(field,LEN(field)-1,1) to get the equivalent in SQL PLUS.

Are you attempting to use the '%'...

neener - it sounds like you are using faulty logic to achieve your ends. WHY would you use the install to remove a database that 'is no longer in...

One other thought - is there a way of 'observing' the query in execution to identify where/what the bottleneck is? While you test this weekend?

OK, you did restores and you did Attaches. Which have the 70 instead of 90? Both? or just one type?

Also, are the codes being reset...

Also, you might want to visit the other forum posts discussing the upgrade to SS2k5 from either SS2k or SS7

you need to 'copy objects'? or you need to replicate functionality? What's the real objective here? Not all of the components you seek to 'copy' can be...

1. Are you in mixed mode or Windows Authentication only?

2. What are you trying to accomplish? Whether a user has valid access directly to the database? ...

Do you have a test database to experiment with? Have you tried it to see what happens? Why would you want to shrink your log file? It...

Is there a reason NOT to update to SP2?