SQL2000 Restore

When restoring a SQL2000 backup of a Navisiondatabase, I can't enter the database anymore through Navision.
I get the following error :
"(" missing in Tablerelation #2000000006 #1

I've encountered the same error before, when restoring a SQL7 backup in SQL 2000, and I thought the problem was related to version differences between SQL 7 and SQL 2000.

Does anyone know how to solve this problem, or what is causing it ?

Thanks in advance.

I get the same error. In my case we're talking Financials Version 2.60D, which version are you running?

2000000006 table is the Company table
Wich Service pack are you running in SQL? (Was it the same when you did your back up?)
If you make a full back up an restore it, it must work.
Check if there was eventually views of relations to other SQL Databases

Regards,
John

Thanks for the timely response. I was aware that it is the company table, I haven't figured out what to do with that information however... I would have liked to export the source code, see if there is infact anything wrong with any "TableRelation" clause anywhere, recompile the company table and stick it back in the Objects table.

1. I don't actually think there is anything wrong with any TableRelation clause. Errors of this kind never tell you what's wrong, they just uniquely (hopefully) identify a problem which may be anything.
2. I don't know how to export the source directly from the SQL Server Programobjekt (as it's called in the SE version) table.

quote:

Wich Service pack are you running in SQL? (Was it the same when you did your back up?) If you make a full back up an restore it, it must work.

What difference does that make? I've never seen SQL Server corrupt backup formats between SP versions. Although, to answer your question, it's 3a on both servers

quote:

Check if there was eventually views of relations to other SQL Databases

I'm afraid I don't follow you?

Originally posted by John_Cage - 2005 Apr 18 :  09:33:50

[/quote]

Additional Info: Same error occurs if I try to create a new SQL Server Database. I've tried using both the SE version and the W1 version, same error.