SQL Error

klum

I got an error about SQL,
It show me this error :

The Following SQL Server error(s) occurred while accessing the session table: 535,"22003",[Microsoft][ODBC SQL Server Driver][SQL Server] Difference for two datetime colunm caused overflow at runtime.

i got this error when i want to check current session by click Drill down;
I use "SQL Server 2000" on "Window Server2003" Navision V.4.0

How can I Fix this error?

Thanks in Advance

Marije_Brummel

There are several posts about this error. Please use the searchfunction

thayoot

I can not find the result for this error.
Please give me the link that can fix this error .

Thank You very much...

ara3n

http://www.mibuso.com/forum/viewtopic.php?t=12606&highlight=session+difference+two+datetime


http://www.mibuso.com/forum/viewtopic.php?t=6962&highlight=session+difference+two+datetime

davmac1

Depending on your SP level this might be a table and not a view. If it is a table, you need to get a patch from Microsoft.

ara3n

the session is a view in all navision version.

thayoot

Thank you very much,Every Body