Geeks With Blogs
Pankaj Tahiliani

--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 in last 7 days
SELECT name FROM sys.objects WHERE type = 'U' AND DATEDIFF(D,modify_date, GETDATE()) < 7

--Show Sno column in result
Select (ROW_NUMBER() OVER ( Order By LoginName)) as LoginName, LoginPassword from tblLogins

Posted on Wednesday, February 25, 2009 11:00 AM | Back to top


Comments on this post: List all the stored procedures/Tables which were modified in last 7 days

# re: List all the stored procedures/Tables which were modified in last 7 days
Requesting Gravatar...
Thank you very much.

Exactly what I was looking for..

Cheers
Left by Promo Code on Mar 17, 2009 4:21 PM

# re: List all the stored procedures/Tables which were modified in last 7 days
Requesting Gravatar...
good very good keep it up
Left by megha on Jul 23, 2010 1:11 AM

Your comment:
 (will show your gravatar)


Copyright © Pankaj Tahiliani | Powered by: GeeksWithBlogs.net