Who is in SQL?

Who is in SQL? 

SQL Server Management Studio >> New Query >> exec sp_who2

 

This will list the users logged into specific databases, especially useful if you need to force kill the sessions. 

New Query >> Kill 'spid' 

eg. Kill 11
 Andy

Turn On Trace Flag 4616 Dynamics NAV

Turn On Trace Flag 4616 Dynamics NAV

SQL Server Mangement Studio >> New Query >> master

DBCC TRACEON(4616,-1) 

Andy

Inventory Valuation - Slow Report FIX (NAV 2009/R2)

Inventory Valuation - Slow Report FIX


Microsoft released a hotfix for the Inventory Valuation report 1001 for NAV 2009 / R2 to decrease the length of time the report takes to run. This is especially important for big databases. 

Hope this helps! 

Download


Andy