Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Script to check for last updates in database objects Expand / Collapse
Author
Message
Posted Tuesday, August 5, 2008 1:27 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 3, 2013 6:16 AM
Points: 26, Visits: 311
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
Post #546545
Posted Tuesday, August 5, 2008 2:18 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 26, 2012 5:26 AM
Points: 1,367, Visits: 1,585
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
Post #546563
Posted Tuesday, August 5, 2008 3:40 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, June 27, 2014 8:02 AM
Points: 3,241, Visits: 4,996
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 here

Post #546596
Posted Tuesday, August 5, 2008 6:39 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Monday, June 3, 2013 6:16 AM
Points: 26, Visits: 311
Thank you the two of you, I get what I needed...
Post #547202
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse