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 |
|
confident119
Starting Member
12 Posts |
 Posted - 2009-07-02 : 09:50:37
|
| In Sql server 2000, is it possible to see the last execution timestamp for procedure or view? |
|
|
sql_er
Constraint Violating Yak Guru
267 Posts |
Posted - 2009-07-02 : 13:11:32
|
| I think it is not possible. One way to do it is to create a separate table for this purpose, and modify the stored procedures you need to monitor to insert its name/timestamp into that table |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-07-03 : 02:33:30
|
quote:
Originally posted by confident119
In Sql server 2000, is it possible to see the last execution timestamp for procedure or view?
Not directly possible in SQL Server 2000, though possible 2005 thru DMVsMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
last execution timestamp for procedure or view?