Search

Thursday, February 9, 2012

When a stored procedure was last modified?

We can get Stored procedure's create date easily by management studio. But finding modified date is not easy. Use below Script to find this. Using below script we can get other objects details also.

USE <Database_Name>;
GO
SELECT name, create_date, modify_date,type_desc
FROM sys.objects
where
name = '<Object_Name>'
GO

No comments:

Post a Comment