Following script will provide name of all the stored procedure which were created in last 7 days, they may or may not be modified after that.
SELECT name
FROM sys.objects
WHERE type = 'P'
AND DATEDIFF(D,modify_date, GETDATE()) < 7
You see things; and you say 'Why?' But I dream things that never were; and I say 'Why not?'
Monday, February 9, 2009
Subscribe to:
Post Comments (Atom)
Followers
Blog Archive
-
▼
2009
(33)
-
▼
February
(8)
- Stored procedure which were created in last 7days
- To get the row count in a faster way
- Unmatching records between two tables
- Exporting the output into a text or csv file
- Taking a backup or creating a duplicate table
- Doing a bulk insert of a text file in temp table
- Getting a SQL Server RowCount Without doing a Tabl...
- How to get length of data in Text, NText and Image...
-
▼
February
(8)
No comments:
Post a Comment