Sunday, November 23, 2008

Search a Stored Procedure the Date Which we added

USE yourDatabaseName;
GO
SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
AND name = 'uspYourSearchingSPName'
GO



OR

-- to get all sps

USE yourDatabaseName;
GO
SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'

GO