wiki.dynamicsbook: NAV 3.70 on SQL 2005

[Blog bot]

New page

Dynamics NAV 3.70 is designed to run on SQL 7 and SQL 2000. It can not run in a production environment on SQL 2005. Oftne though you may need to work with a 3.70 database on SQL 2005 for test or development purposes. In this case the following makes this possible.

NOTE: Do NOT use this procedure in a live production database.

In the NAV 3.70 database there is a view that shows current users sessions. In thisview there is a column:

CASE WHEN SP.[blocked] <> 0 THEN SP.[waittime] ELSE 0 END

this column should be changed to:

CASE WHEN SP.[blocked] <> 0 THEN CAST(SP.[waittime] AS INT) ELSE 0 END

now you should be able to work with the database.

Источник http://wiki.dynamicsbook.com/index.php?tit....70_on_SQL_2005