THanks for the reply. When I delete the DB on the new server and then REBOOT prior to carrying out the restore steps all goes well without the error message.
I have a single database to migrate and it's pretty small... less that 2 Gigs total. I have very limited TSql experience which is why I am hoping to get...
Thanks for the replies. I was hoping to avoid changing the stored procedures in an attempt to capture errors. There are some uses of @@ERROR but the coders only inquire...
I added a the connection string to my page and sure enough got the correct results. It's these obvious little mistakes that keep me spinning my wheels for hours sometimes.