User login in SQL version of Navision

arindam

Hi All,

How do i find out which user is logged in in Navision SQL server version ?

Regards,
Arindam

Marije_Brummel

Via File Database Info Sessions --> Drilldown

Or SQL Management Studio --> Management --> Activity Monitor

Or --> Query analyse --> sp_who

arindam

Thanks for the reply.

But how can I programetically find out which user is logged in ?

Appreciate your help.

Marije_Brummel

There is a session table.

It is hidden but you can see it in the variables when you select table.

arindam

I tried that. The table number is 2000000009.

I have defined an user called 'sa'. and my machine name is say 'M1' and domain is say 'Domain1'.

When at runtime I am accessing the "User ID" feild of session table, i am getting the value 'Domain1/M1'. I am expecting 'sa'.

I confirm that I logged in SQL option of Navision and my user id is 'sa'.

Please advice.

Regards,

Eugene

there is a system function USERID

F5 - DATABASE - Functions - USERID

arindam

Just got the solution.

Yes USERID is the one which I was looking for. It solved my problem.

Thank you all for your help.