Sessions: 89 The postings on this site are my own and do not represent my Employer's positions, advice or strategies.


  Saturday, May 8, 2021
Wider View Login

IBM - AS400
Performance Counters
Service Broker
SQL Server
     Temporary Database
     SQL Mail
     DTS - Data Transformation Services
     Jobs SQL Agent
     User Management
          Audit Level - Login ...
     System Databases
     Temp Tables
Windows OS

Will be added as a sub-category of, User Management
Audit Level - Login Failures
-- -- sets auditing level to log failures -- Tested and run on SQL 2000, not yet tested or known if the -- registry settings are the same for sql 2005 -- xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer', N'AuditLevel', REG_DWORD,2 exec xp_loginconfig 'audit level'