RS First Dynamics NAV Blog


...from NAV 3.60 to NAV 2013
Home Blogs | Home | Login | Contact | My Profile | RSS | About | Cerca

KILL SQL INACTIVE SESSIONS FOR 'NAV APPLICATIONS'

// 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...
Categoria: Dynamics NAV ALL
venerdì, 06 lug 2012 Ore. 08.58

Scrivi un commento


Non è possibile inviare commenti a questo Blog

Commenti

Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003