Geeks With Blogs
Pankaj Tahiliani February 2009 Entries
List all the stored procedures/Tables which were modified in last 7 days
--List all the stored procedure which were modified in last 7 days SELECT name FROM sys.objects WHERE type = 'P' AND DATEDIFF(D,modify_date, GETDATE()) < 7 --List all the stored procedure which were created in last 7 days SELECT name FROM sys.objects WHERE type = 'P' AND DATEDIFF(D,create_date, GETDATE()) < 7 --List all the tables which were created in last 7 days SELECT name FROM sys.objects WHERE type = 'U' AND DATEDIFF(D,create_date, GETDATE()) < 7 --List all the tables which were modified ......

Posted On Wednesday, February 25, 2009 11:00 AM

Copyright © Pankaj Tahiliani | Powered by: GeeksWithBlogs.net