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.
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