Auditing in SQL Server 2005

• beejug1983

  SSCertifiable

  Points: 6491

  More actions

  January 14, 2011 at 7:20 pm

  #157392

  HI,

  Yesterday one of my colleague asked me a question i.e. if someone wants to get the list of users who logged on the SQL server at any particular date. I told him one solution is to read the error log file and another option is to enable "C2 Auditing" but "C2 Auditing" only gives information after we enable it, but what about the list before enabling "C2 Auditing". Is there any other way to find the information of users logged on any particular date.

  Thanks in advance.

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  January 18, 2011 at 6:29 am

  #1274668

  You can make use of the Default Trace[/url] to get that information.

  Enabling C2 audit can make the drive run out of space pretty quickly apart from other overheads. Here[/url] is one such example.

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga