14 September 2012

To know the stored procedure created date and modified date in Sql Server

To know the stored procedure created date and modified date in Sql Server


SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
AND name = 'sp_name'  -- stored procedure name



No comments:

Post a Comment

Comments Welcome

Consistency level in Azure cosmos db

 Consistency level in Azure cosmos db Azure Cosmos DB offers five well-defined consistency levels to provide developers with the flexibility...