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

LifeAsBob

  Sunday, July 22, 2018

 


Home
Blog
bob tech
Calendar
Contact Bob
Pictures
VW Buses
HomeBrew
Cook Book

 

Branson Vacation 2007

  bob Links
Toshiba   Technical ...
Mother's in the kitchen washing out the jugs, Sister's in the pantry bottling the suds, Father's in the cellar mixing up the hops, Johnny's on the front porch watching for the cops. - Prohibition Song
Wider View Insert

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

Insert Category

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'