Wednesday 7 September 2011

How to find out last 10 mofied tables and procedures in sql server

SELECT TOP 10 name, modify_date FROM sys.tables ORDER BY modify_date

SELECT TOP 10 name, modify_date FROM sys.procedures ORDER BY modify_date

No comments:

Post a Comment