RS First Dynamics NAV Blog


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

Anno 2014

Anno 2013

Anno 2012

Anno 2011

Anno 2010

Anno 2009

Anno 2008

Anno 2007

SQL Server “IN RECOVERING” State

SQL Server “IN RECOVERING” State   Quickly Solutions to solving. 1.     Stop the service (MSSQLSERVER); 2.     Rename or delete the Database and Log files (C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data...) or wherever you have the files; 3.     Start the service (MSSQLSERVER); 4.     Delete the database with problem; 5.     Restore the database again.   DETACH TO CLE 
Leggi tutto il post...
Categoria: Sql Server ALL
mercoledì, 30 giu 2010 Ore. 18.33

DEADLOCK_PRIORITY of a NAS

Setting DEADLOCK_PRIORITY with "sp_$ndo$loginproc" Well, in a perfect world we would never encounter deadlocks with NAV, but unfortunately things are not that perfect ... so we will always have deadlocks, sometimes more, sometimes less. It is quite annoying, when a DL occurs and some unattended process, e.g. a NAS or NAV Job Scheduler, is killed, because these processes hardly could resume I just found a way to - at least - define the DEADLOCK_PRIORITY for such processes with NAV, using the s 
Leggi tutto il post...
Categoria: Dynamics NAV ALL
giovedì, 03 giu 2010 Ore. 12.38
Statistiche
  • Views Home Page: 469.057
  • Views Posts: 885.845
  • Views Gallerie: 0
  • n° Posts: 343
  • n° Commenti: 0
Copyright © 2002-2007 - Blogs 2.0
dotNetHell.it | Home Page Blogs
ASP.NET 2.0 Windows 2003