SQL Server Error While Accessing Session Table

Business Central/NAV Developers Forum
1

Hi, Can anyone shed light on the following error message I got when looking to see who was logged into Navision…“The following SQL error occurred while accessing the Session Table”…535,“22003”,[Microsoft][ODBC sql server driver][sql server] difference of two datetime columns caused overflow at runtime. AS mentioned this happened when I went File, database information and clicked the arrow to drill down to see which users are logged in to Navision. Thanks

2

http://www.mibuso.com/forum/viewtopic.php?t=7764&highlight=difference+two+datetime+columns+caused

3

Thanks Mark, have passed this onto the person who found the error and who is also the SQL ‘expert’. Paul

4

Has been discussed in this forum as well as far as I remember: http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=16349&SearchTerms=22003

5

Thanks Thomas, that link is exactly what I wanted. You are a star…Paul

6

Glad if I can help