Wednesday, March 21, 2012

Last recompilation date of the procedure / view

Hi,

Kindly let me know How will we find the last recompilation date of the procedure / view in sql server.

Regards,

S.Balavenkatesh

perhaps what you seek is in:

select refdate, crdate from sysobjects

or

select create_date, modify_date from sys.system_objects -- 2005

?


Dave

No comments:

Post a Comment