Error message after restoring a database

schwenth

Hi all,

we use NAV 4.03 together with MS SQL Server 2005. I just restored a database on the server, and the restore was finished without errors. The application was working well. After I logged off, I tried to log in again and got the following error after typing my user/password:

The session table contains a Microsoft Business Solutions-Navision data type that is not compatible with the SQL Server data type:

Field: Wait time(MS)
Type:Integer
SQL type:BIGINT

But I simply restored the database from a backup.... ](*,)

Thank you for your help....


Thilo

kine

[edited]

DenSter

Sometimes there's a problem where the views are not all restored. You'll need to copy it to your new database. In the original database, in Enterprise manager/Management Studio, find a view called 'Session'. Script this view as a CREATE script and copy it to the new database. You may have to repeat that for the "Session (SQL)" view.