Ariel Dimapilis (8/5/2008)
anyone can do a script to check for last updates in database objects e.g. store procedures and views. they will see the last modifiedthanks
this information is present in the sysobjects system table (I assume you are on SQL Server 2000 as this is a 2000 thread). You can query it like:
SELECT u.name AS userName
, o.name AS objectName
, updatedate AS lastUpdated
FROM sysobjects AS o
JOIN sysusers AS u ON o.uid = u.uid
WHERE OBJECTPROPERTY(o.id, N'IsMSShipped') = 0
Regards,
Andras