Wednesday, September 28, 2011

Query to get list Stored Procedures ordered by modified date

Getting list of stored procedures ordered by modified date can be useful to find recently modified sps

-- Queries the sys.objects system view to gather information
-- about user defined stored procedure database objects;
-- specified with type='P'.
-- order by modified date--

SELECT
FROM sys.objects -- User defined objects system view

WHERE type = 'P' -- Only return stored procedures
ORDER BY modify_date desc name, create_date, modify_date




Refer the following link on msdn for more information that you can get using sys.objects
http://msdn.microsoft.com/en-us/library/ms190324.aspx

No comments:

Post a Comment