Re: Stored procedure modification date?
From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 08/30/04
- Next message: ....: "Database "Suspect""
- Previous message: Uri Dimant: "Re: Stored procedure modification date?"
- In reply to: J Jetson: "Stored procedure modification date?"
- Next in thread: J Jetson: "Re: Stored procedure modification date?"
- Reply: J Jetson: "Re: Stored procedure modification date?"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 30 Aug 2004 11:05:38 -0400
> Is there a way to tell when a user-created Stored Procedure was last
> modified?
No, SQL Server does not track this information, only creation date.
> If not, is there a way to set it up to record the date of future
> modifications? Thanks.
Do you use source control? If so, that should tell you. If not, you should
consider it. And don't let developers go in and ALTER PROC willy-nilly.
You could also instruct developers to always use DROP/CREATE. That way the
creation date is always the last modification date, but you lose history of
changes. (Again, source control is your friend.)
Finally, SQL Server 2005 will offer events and DDL triggers, one or both of
which could log such events. There is also talk that the system catalog
views will contain information about when objects were altered.
-- http://www.aspfaq.com/ (Reverse address to reply.)
- Next message: ....: "Database "Suspect""
- Previous message: Uri Dimant: "Re: Stored procedure modification date?"
- In reply to: J Jetson: "Stored procedure modification date?"
- Next in thread: J Jetson: "Re: Stored procedure modification date?"
- Reply: J Jetson: "Re: Stored procedure modification date?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
