Is there a way to determine who created a stored procedure?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shawn Sesna - 03 Jul 2008 23:22 GMT

I'm using SQL Server 2005 and am wondering if there is a way to determine who
created a stored procedure? I've looked in sys.objects, but all it gives me
is the original create date and the last modified date.

Reply to this Message

Erland Sommarskog - 04 Jul 2008 09:12 GMT

> I'm using SQL Server 2005 and am wondering if there is a way to
> determine who created a stored procedure? I've looked in sys.objects,
> but all it gives me is the original create date and the last modified
> date.

No, there is nothing out of the box. One could think that looking at the
owner would reveal the answer, but the owner is by default always the
owner of the schema.

You could create a DDL trigger that logs CREATE/ALTER PROCEDURE to a
log table to capture this information.

Signature

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Reply to this Message

Shawn Sesna - 07 Jul 2008 16:03 GMT

Thank you for your response, this answered the question.

> > I'm using SQL Server 2005 and am wondering if there is a way to
> > determine who created a stored procedure? I've looked in sys.objects,
[quoted text clipped - 7 lines]
> You could create a DDL trigger that logs CREATE/ALTER PROCEDURE to a
> log table to capture this information.

Reply to this Message