Unspecified error after DB restore

[Guest_imported]

I'm attempting to transfer a DB from one server to another... should be a simple procedure. I wish to transfer tables and the data contained within. So, I click on backup, go through the steps, and it's done. No problems. Just as a test, i restored the DB, quickly perused it to check for any errors, and none existed.

So, off I go to the remote server, transfered the backup, and restored in exactly the same manner. Everything looks good, tables are all there, correct columns. However, if I try to return all rows, the top rows, or do any kind of SQL Query on any of the restored tables, I get one of those useful "Unspecified error" messages, which reads as follows.

An unexpected error happened during this operation.

[Query] - Query Designer encountered a Query error:
Unspecified error

I'm pretty new to SQL Server, so any help would be extremely useful, and greatly appreciated.

Thank you,
Simon

 

[Andel]

I'm guessing that you're using SQL 6.5. If that's true, installing the latest service pack should solve your problem.

Andel
andelbarroga@hotmail.com

http://andyb.8m.com