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

LifeAsBob

  Friday, May 1, 2026
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'
String or binary data would be truncated in table 'tempdb.dbo.#AEAA4046', column 'col2'. Truncated value: 'http://www.ask.com/main/metaAnswer.asp?t=m&s=a&metaEngine=directhit&origin=0&MetaURL=http%3A%2F%2Fas'. The statement has been terminated.