Krishna and Ed ,

Thank you so much for the feedback!

I want to ultimately take MCDBA ...and I know this is the starting point...So On my way to the preperation now.

I...

Thank you very much David for the reply. I ended up writing a batch file to copy over the filefrom the Prod server and then doing the restore.

So this means that the issue is with server level permissions correct?

Yes I believe that is hte issue.

The mesage I got was

Server: Msg 3201, Level 16, State 2, Line 1

Cannot open backup device '\\prod_server_name\drive$\sqldumps\Prod_db.BAK'. Device error or device off-line. See...

Yes that was the reason I added the user to ddl_admin.

The alter proc does not work

Folks,

This is still not solved. When we tried to wrap this in a cursor to find a potentially bad row but it din't return anythign..it worked well...

Any ideas here...

Thank You..I tried diff data sets but it did not fail..

I did a dbcc reindex on the table...and then it worked..pages were torn somewhere i guess..Incidentally we had a network...

Thank you Lowell...Now all files open in 2000 query analyzer..

Hi Steve,

I really appreciate your reply,but could be more specific on where to find the tools in windows system..i fished into tools in sqlserver/90/tools but couldnt find anythign myself ....