Database sessions

Navrookie

Hi

When I look in Navision Database Information in Current Session , It show total user name and their details apart from which it shows Number of login session with SA login. Can someone say what it is..

DenSter

That depends on what is running on your machine. The Sessions view shows you all active sessions on SQL Server, including sessions that don't belong to the NAV database. It should include information about the database, the application, the user ID, things like that, so from there you should be able to figure it out. For instance, if you are looking at the NAV database in SSMS using the SA account, that would show up as a session. If you have 6 different query windows running, that would show up as 6 sessions.