table and store procedure create date and modify date

 

 

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

 

This post demonstrates the script which displays create date and modify date for any specific table in SQL Server.

SELECT


        [name]

       ,create_date

       ,modify_date

FROM


        sys.tables