Aspdotnet-Suresh

aspdotnet-suresh offers C#.net articles and tutorials,csharp dot net,asp.net articles and tutorials,VB.NET Articles,Gridview articles,code examples of asp.net 2.0 /3.5,AJAX,SQL Server Articles,examples of .net technologies

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

Jan 20, 2014
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:


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 RSS subscribe by email Subscribe by Email

5 comments :

Anonymous said...

great!!!!!!!

Unknown said...

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



in the above query what is "type='P'"??
how to get the same for table??

Anonymous said...

How to see the result in the output box

Bhavesh Bhuva said...

Thank you.....

Anonymous said...

another simple method would to to call the system view :-
Select * from sys.procedures

Give your Valuable Comments

Note: Only a member of this blog may post a comment.

© 2015 Aspdotnet-Suresh.com. All Rights Reserved.
The content is copyrighted to Suresh Dasari and may not be reproduced on other websites without permission from the owner.