Only one session in session table

rofl

Hello,

[Using Nav4 SP3] a couple of days ago I faced one very confusing problem. When I try to view DB information (using system tools as well as my own session form) the only thing I always see is my own connection/session (although there are at least two active [SQL server shows all of them, but NAV (session table) - not]). I searched for similar problems in the forum, but no answers. Moreover, all permissions are granted to each user and everything is suppose to be just fine (SQL admin assured me that everything (as he thinks) must be ok), but obviously it is not. Please somebody help me to solve this "bug"... ](*,)

Thanks a lot.

kine

1) I think it depends on exact NAV client version (build no.)
2) Check that traceflag 4616 is set on the MS SQL (I am sure that you are using SQL 2005 or 2008)

Deep

You must also be a Super user of SQL database server (not only NAV) to view the sessions.

rofl

traceflag is ok (forgot to mention). When it comes to all permissions, it seems that everything is just fine. Got no clue what the problem is...