October 2, 2003 at 1:40 pm
is there a way to find the modified date for a store procedure?
October 2, 2003 at 2:31 pm
If you use alter for sp - answer is no, if you recreate sp - see sysobjects field crdate.
October 2, 2003 at 3:36 pm
correct. No way to tell when it was modified if it was ALTER'd. The version field will be incremented by 16, but unless you track that on a regular basis you will not know the time frame in which it was altered.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply