Re: Is there a way to determine who created a stored procedure?
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Fri, 04 Jul 2008 01:12:14 -0700
Shawn Sesna (ShawnSesna@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
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.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
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
.
- Prev by Date: Re: Windows authentication still prompts for database login
- Next by Date: Re: Application Security based on SQL Security
- Previous by thread: Re: Windows authentication still prompts for database login
- Next by thread: Re: Can't find SQL Server Management Studio after install SQL Server 2
- Index(es):
Relevant Pages
|
