Activity logs in SQL Server 2005

• susy.nieva

  Newbie

  Points: 1

  More actions

  May 22, 2008 at 2:25 am

  #188000

  All I want is to get the activity logs done by the administrators. I cannot find it in the SQL Server logs. For example, if the admin deleted a certain login id, where can i see the activity logs? I need to create script for this... Pls. help... thanks. 🙂

• Stupeo

  Hall of Fame

  Points: 3067

  More actions

  May 22, 2008 at 2:42 am

  #819018

  I think your best bet for this would be to create some Server DDL Triggers that monitor the creating/deletion of logins, tables and most objects.

  The following MSDN article should help: http://technet.microsoft.com/en-us/library/ms190989.aspx

  Kind Regards,

  Matt.