Jeetu .NET SQL
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment