Stored Proc Creator

• ssismaddy

  SSCarpal Tunnel

  Points: 4850

  More actions

  November 20, 2008 at 7:47 am

  #92831

  Hi ...we have a stored proc in our database....how Can I know who created that stored procedure??

  Thank you

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  November 20, 2008 at 9:25 am

  #901122

  Look at the default trace which is enabled by default in SQL 2005. It's a great way to find out this kind of thing.

  Here's a recent article about how to query the trace data:

  http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/

  Greg

• ssismaddy

  SSCarpal Tunnel

  Points: 4850

  More actions

  November 20, 2008 at 10:13 am

  #901176

  Thank you very much for the information.....I created DDL trigger on the database....