which user modified the stored procedure

Question

I want to find out the following details  in sql server 2008

1) who created this sp
2) who has last modified this sp

Please let me know how do i find this out.
I am able to find the created and modified dates only using sys.objects but i need the user names also.

Thanks in advance.
Raj

Answer 1

SQL Server doesn't store this information in its internal system tables. You can see who *owns* the procedure, but that is not neccesarily the same as who created or last modified the procedure. You might be able to find out through the defult trace (the your data folder for .trc files), but this informaiton is only kept for 5 files, 100MB each.

---

Tibor Karaszi, SQL Server MVP | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karaszi

Answer 2

To add to Tibor's reply, there is a Standard Report that will show you the schema change information that comes from the default trace. This simplifies things somewhat for you.  (Unless you have the default trace turned off.)

In SSMS, right click on Server Name, choose Reports / Standard Reports / Schema Changes History.

The list is in time order with most recent at the top.  However, once the report is created, you can export to Excel to make it easier to search for a specific name.



RLF