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

LifeAsBob

  Friday, April 19, 2024
Wider View Login

Cluster
DOS
IBM - AS400
MOM
Performance Counters
Service Broker
SQL Server
     Temporary Database
     Views
     Backup
     SQL Mail
     DTS - Data Transformation Services
     Memory
     Security
     Excel
     Jobs SQL Agent
     MSDE
     Install
     DBCC
     User Management
          Audit Level - Login ...
     System Databases
     BCV
     Deadlocks
     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'