Can SQL Server Log provide history like "Who executed drop and create object script?"

• sumit kende

  SSC Veteran

  Points: 272

  More actions

  September 25, 2008 at 2:54 am

  #93830

  Hello,

  Yesterday someone had executed drop and create SPs script on development database. Is it possible to track from which computer this was happeded? b'cause most of us uses common creadentials for login.

  So machine name will useful to track it.

• Chandra Sekhara Vyas Dhara

  SSChampion

  Points: 10207

  More actions

  September 25, 2008 at 3:40 am

  #876847

  You will get only user name.

• sumit kende

  SSC Veteran

  Points: 272

  More actions

  September 25, 2008 at 3:49 am

  #876853

  Thanks for reply.

  I seached SQL Server Log but unable to find anything about it, where do I find, atleast username by which this problem occured.

• Rajesh kasturi

  SSCarpal Tunnel

  Points: 4007

  More actions

  September 25, 2008 at 4:30 am

  #876868

  Hi,

  You can find which user dropped tables and sp's from your database by using database log reader tool.

  Hi, here is the link to download the log reader

  http://quest.com/quest_download_assets/latest_versions/logreaderforsqlserver_12.msi

  With out log reader it is not possible. By using DDL Triggers in SQL Server 2005 you would have implemented Auding system.

  Rajesh Kasturi