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 |
|
swatib
Posting Yak Master
173 Posts |
 Posted - 2005-12-13 : 06:57:21
|
Hello.........Is there a way to find out when a stored procedure was last updated?Njoy Life  |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-13 : 07:02:53
|
| No way until you run profiler and save the result or manually document itMadhivananFailing to plan is Planning to fail |
 |
|
|
swatib
Posting Yak Master
173 Posts |
Posted - 2005-12-13 : 07:06:03
|
| Hmmm.......... OK BossNjoy Life |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-13 : 07:10:39
|
| Are you preparing for interview? MadhivananFailing to plan is Planning to fail |
|
|
|
swatib
Posting Yak Master
173 Posts |
Posted - 2005-12-13 : 07:13:44
|
| No.... I'm trying to find the answers of the questions that can be raised 4 SQL Server.Njoy Life |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-12-13 : 08:21:40
|
| "Is there a way to find out when a stored procedure was last updated?"SQL stores the date the Sproc was created but not when it was updatedIf you always use DROP PROCEDURE ... CREATE PROCEDURE ... you can use that date. However, if you use ALTER PROCEDURE ... you can'tWe have an SProc call at the top of all our scripts that "logs" the fact that that script was run, and this allows us to see the dates when we ran a particular script (it also logs the "version number" of that script).We store each Stored Procedure in a separate file, so in effect we get a LOG of whenever each Sproc is updated.Kristen |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-13 : 08:28:28
|
quote:
Originally posted by swatib
No.... I'm trying to find the answers of the questions that can be raised 4 SQL Server.Njoy Life
Thats good Regularly visit this site and read the threadsMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Stored Proc last updated