Roberto Stefanetti NAV Blog


...from NAV 3.60 to NAV 2013
Archivio Posts
Anno 2016

Anno 2015

Anno 2014

Anno 2013

Anno 2012

Anno 2011

Anno 2010

Anno 2009

Anno 2008

Anno 2007

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
DYNAMICS NAV MVP 2016



FOLLOW ME! ON SOCIALS

Statistiche
  • Views Home Page: 259.541
  • Views Posts: 572.811
  • Views Gallerie: 661
  • n° Posts: 347
  • n° Commenti: 26
Mappa
Meteo
Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003