SQL Server - Get Stored Procedure Last Modified Date or Updated Date in SQL Server

Introduction:

Here I will explain how to get stored procedure last modified date in SQL server or SQL server check last updated date stored procedure or query to check stored procedure modified date in SQL server 2008.

Description:

In previous articles I explained Query to get database size in SQL Server, show time difference in minute ago hour ago etc in SQL Server, get list of procedures where table name used in sql, difference b/w view and stored procedure in sql, add row items as string with comma separated values in sql server and many articles relating to SQL server. Now I will explain how to check stored procedure modified date in SQL server.

To get stored procedure last modified date in SQL server we need to write the query like as shown below

SELECT name, create_date, modify_date FROM sys.objects WHERE type = 'P'

Whenever we run above query it will return all the procedures created date and modified date of your database like as shown below

Example

If you want to get specific procedure modified date we need to write the query like this

SELECT name, create_date, modify_date FROM sys.objects WHERE type = 'P' AND name like '%your procedure name%'

Once we run above query we will get output like as shown below

Example

If you enjoyed this post, please support the blog below. It's FREE! Get the latest Asp.net, C#.net, VB.NET, jQuery, Plugins & Code Snippets for FREE by subscribing to our Facebook, Twitter, RSS feed, or by email.

Subscribe by RSS Subscribe by Email