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 2008 e SQL 2005: Auditing Solutions, Audit C2

SQL 2008: Server and Database Auditing Simple Longins Tracing -> enabling SQL Server Option Login Auditing: "Both Failed and Succesfull logins" many solution scenario sqldbatips Scenario: In SQL Server 2008 Enterprise Edition, Instance and Database level audit is now a built in function of the Database Engine with its own set of instance and database level objects, Server Audit and Server Audit Specification at the instance level and Database Audit Specification at the Database level (on 
Leggi tutto il post...
Categoria: Sql Server ALL
giovedì, 24 set 2009 Ore. 09.42

Error Login "A 'S' was expected here"

"A 'S' was expected here" login error  (All versione from Nav 4.X, 5.X) Errore dovuto alla codeunit 1 che controlla la tabella degli accessi  e trova anomalie nelle associazioni utenti\gruppi permessi 2 possibilità per questo errore: 1. tabella " Windows Logins" contiene in login ID Vuoto (non pià esistente). "...if the user doesn't exist anymore the ID looks like "S-1-5-21-1102201369-1425392959-26340124-1008" now the the first "S" ... is the "S" in yo 
Leggi tutto il post...
Categoria: Dynamics NAV ALL
mercoledì, 16 set 2009 Ore. 11.31

Recovering Sql DB from "Suspect state"

I've my database, testdb, ended up in Suspect state. The SQL log shows " I/O error 38(Reached the end of the file.) detected during read at offset xxxxxxxxxx in file '\testdb_Data.MDF'" during recovery. I do not have backup to restore the database from. So to run DBCC CHECKDB, I tried to put the database in emergency(bypass recovery) mode usingupdate sysdatabases set status = 32768 where name = 'testdb'DBCC CHECKDB showed some allocation and consistency errors and suggested "repair_allow_data_ 
Leggi tutto il post...
Categoria: Sql Server ALL
giovedì, 10 set 2009 Ore. 10.59
  • Views Home Page: 450.977
  • Views Posts: 863.385
  • Views Gallerie: 0
  • n° Posts: 343
  • n° Commenti: 0
Copyright © 2002-2007 - Blogs 2.0 | Home Page Blogs
ASP.NET 2.0 Windows 2003