Script to check for last updates in database objects

Question

Script to check for last updates in database objects

Ayie

SSC Eights!

Points: 828
More actions
August 5, 2008 at 1:27 am

#195332

anyone can do a script to check for last updates in database objects e.g. store procedures and views. they will see the last modified
thanks

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Andras Belokosztolszki SSC-Insane Points: 22031 More actions · Answer 1

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 modified
thanks

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

Andras Belokosztolszki, MCPD, PhD
GoldenGate Software

Atif-ullah Sheikh SSChampion Points: 12495 More actions · Answer 2

For SQL Server 2005, its simply

SELECT * FROM sys.objects

WHERE is_ms_shipped = 0

ORDER BY modify_date DESC

Atif Sheikh

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.
You can check my BLOG [font="Arial Black"]here[/font][/url][/right]

Ayie SSC Eights! Points: 828 More actions · Answer 3

Thank you the two of you, I get what I needed...