MS SQL 2008 Audit query- Need Server names, DBs name and login information

• ichbinraj

  SSCommitted

  Points: 1627

  More actions

  August 28, 2013 at 5:00 pm

  #281739

  Hi,

  I am writing a query to get the following information for my audit report. Can someone please send me script or help with this.

  Server Name

  SQL Server Instance Name

  Database Name

  Login Name

  User Name

  Role/permission assigned

  Report Date (current date)

  Appreciate your help.

  Thanks

  Ichbin