// KILL SQL INACTIVE SESSIONS FOR NAV APPLICATIONS// ONLY FOR SLEEPING SESSIONS
a very Simple SQL Stored Procedure to 'kill' sql inactive sessionsidle (sleeping) for 10 minutes related to "Nav Client" applications
*** it's necessary to identify correct "application name" ****** ex: program_name LIKE N'%NAV client% *** or %NAV Web%
Stored Procedure Script
DECLARE @v_spid INTDECLARE c_Users CURSOR FAST_FORWARD FOR SELECT SPID FROM master..sysprocesses
Leggi tutto il post...