Navision Session Table and SQL

sameer_79

Hi All,

Iam using Nav 4.3 with SQL 2005, it is possible to view navision session table through SQL Query.

Regards
SAM

matttrax

You could do an sp_who or sp_who2 in SQL to get the same information.

DenSter

The Session table in NAV links to a view in the NAV database on SQL Server. You should be able to see it from SSMS. Expand the databases node, then the one for the NAV database, then 'views' and there it should be.

stryk

... or in other terms:

USE "MyNavDB"
GO
SELECT * FROM "dbo"."Session"
GO