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 |
|
shaggy
Posting Yak Master
248 Posts |
 Posted - 2007-07-26 : 09:44:41
|
| dear friends,iam new to ssql server.i want to find the modified date of stored procedures. can any one help me in this |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-07-26 : 09:56:55
|
if you are on 2005, there is a modify_date column in sys.objects:select name, modify_date from sys.objects where type='P'
elsasoft.org |
 |
|
|
shaggy
Posting Yak Master
248 Posts |
Posted - 2007-07-26 : 10:07:09
|
| iam using sql 2000 is there any solution |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-07-26 : 10:13:00
|
don't think so, not from the system catalogs.really you ought to have all your scripts in a source control system though, so you could easily track changes. real programming projects use source control.
elsasoft.org |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-07-26 : 10:15:05
|
actually, if you always use DROP/CREATE instead of ALTER, this might help you:select name, crdate from sysobjects where xtype='P'
elsasoft.org |
|
|
|
|
|
|
how 2 find modified Sps