Navision Session Table and SQL

sameer_79 · 2010-04-07

Hi All,

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

Regards
SAM

matttrax · 2010-04-07

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

DenSter · 2010-04-07

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 · 2010-04-07

... or in other terms:

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

Navision Session Table and SQL

Comments

Categories