Search Results: sqlserver 2005 audit

• 
  Auditing sql server logins in sql server 2005

  There are two views provided by sql server 2005 that can be used for auditing sql server logins. They are sys.server_pricipals and sys.sql_logins. select * from sys.server_pricipals The type field in the above consists of 'S', 'R', 'U', 'G' U stands for u

  Author:  indupriya     Date: 6/7/2010     Section: Blog

  tags : sqlserver 2005 audit, sql server logins