|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Wednesday, March 14, 2012 11:28 AM
Points: 26,
Visits: 310
|
|
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
|
|
|
|
|
Ten 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
|
|
|
|
|
Hall of Fame
       
Group: General Forum Members
Last Login: Thursday, March 14, 2013 4:15 AM
Points: 3,240,
Visits: 4,960
|
|
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
|
|
|
|
|
SSC Rookie
      
Group: General Forum Members
Last Login: Wednesday, March 14, 2012 11:28 AM
Points: 26,
Visits: 310
|
|
| Thank you the two of you, I get what I needed...
|
|
|
|