// 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...