Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jdoering
Starting Member
32 Posts |
 Posted - 2002-10-21 : 10:59:06
|
| Can anyone tell me where/or how to find the modification date (Not the creation date) for a stored procedure? System tables, information_schema, or some trick that is undocumented??Our developers have modified some stored procedures here, and only want the modified ones moved to production. Of course, they didn't keep track of what they modified so I was thinking maybe there was something I could run to find this out.Thanks,Julie |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-21 : 11:12:56
|
| SQL Server doesn't store a modification date. If the procedure was dropped and created though, then the crdate column in sysobjects will reflect the "modified" date.This scenario is a perfect one for source control, and it's the only reliable means you have for controlling access and tracking modifications to source code. You need to sit your developers down and have a chat about making changes too...or just remove their CREATE/ALTER PROCEDURE rights. |
 |
|
|
nizmaylo
Constraint Violating Yak Guru
258 Posts |
Posted - 2002-10-21 : 11:41:50
|
| Julie,Rob is right, there is no easy way out, but there is a way. Search this site for code someone published a while ago on how to compare two databases to find out what objects were modified. If you can't find that code and you only need to move stored procs, compare text from syscomments to find out the differences (link servers, if the database are different boxes).helena |
|
|
|
|
|
|
Finding Modification date for Stored Procedure