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.

If...

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 response DC

You mention using the WITH NORECOVERYoption in your response. If I do this via Enterprise Manager, will...

Thanks for the recall Steve. I was catching up on all the posts when I got in this morning.

I chose "Manage Indexes" off the menu on my Products table...

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.

Thanks!!

Rich