Saturday, December 3, 2011

SQL Query to find Last Modified date ,Created date of a stored Procedure

This post demonstrates the script which displays create date and modify date for any specific stored procedure in SQL Server.
USE GSIt;
GO
SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
AND name = 'USP_JOIN_COLLEGE_DETAILS'
GO

Here GSIt is the name of the database and USP_ COLLEGE_DETAILS is the name of the stored procedure.

No comments:

Post a Comment