Is last update recorded? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Is last update recorded?

Can I find a stored procedure is updated or not? Is there anywhere recorded the stored procedure’s last update? CanadaDBA
No. Although there is a crdate in sysobjects, it’s pretty useless (as it won’t change) when the procedure is updated via ALTER PROCEDURE. However, if this is done via DROP and CREATE PROCEDURE, crdate will reflect this. —
Frank Kalis
SQL Server MVP
http://www.insidesql.de
Agreed to frank kalis,
good discussion on this check
http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic1421.aspx
quote:Originally posted by FarhadR Can I find a stored procedure is updated or not? Is there anywhere recorded the stored procedure’s last update? CanadaDBA
This is getting changed in SQL 2005 where you can get details of updation to a SP. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Good News
quote:Originally posted by satya This is getting changed in SQL 2005 where you can get details of updation to a SP. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>