Loading ...

SQL: Get created and modified date of a stored procedure

Who is online?  0 guests and 0 members
home  »  blogs  »  Raghav Khunger  »  SQL: Get created and modified date of a stored procedure

SQL: Get created and modified date of a stored procedure

(0)
(538)
0
/5
Avg: 0/5: (0 votes)

posted 2/21/2012  by Raghav Khunger

Today I was working with some Stored procedures and I was in a need where I need to know the created and modified date of stored a procedure. Following is the script which I would like to share which I used to get the desired result:

GO
SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
--AND name = 'sp_dts_getfolder'
GO

Output at my screen: 

 tags: SQL: Get created and modified date of a stored procedure

Product Spotlight

ASP.NET Hosting Spotlight
 

Comments (no comments yet)

Add a new comment

Confirm

Latest community blog posts

  • ASP.NET: Form authentication timeout in web.config overriding the manual ticket timeout
    7 days ago by Raghav Khunger
    While working with one of the sample application I noticed that form authentication timeout in web.config was overriding the manual ticket's (which we created via code) timeout. Below is the code which was written in the application: var ticket = new FormsAuthenticationTicket(1, "UserName", DateTime...
  • jQuery: Set cursor position in textbox
    4/13/2012 by Raghav Khunger
    In this blog I will show how to select a range of characters in textbox with jquery. In my demo I have used one textbox and one button. On click of button arange of characters in textbox will be selected. Below is the sample code: <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="ser...
  • Could not load file or assembly 'Newtonsoft.Json, Version=3.5.0.0...
    9 days ago by Raghav Khunger
    Recently we moved from Newtonsoft.Json 3.5 to 4.0 version. We noticed that we were getting Could not load file or assembly 'Newtonsoft.Json, Version=3.5.0.0.. while working with Twitter authentication which we were using in our application. The third party dll which we were using for Twitter authent...
  • jQuery Mobile Login Dialog Box
    11/17/2010 by Tim Eisenhauer
    PRODUCT SPOTLIGHT This is an addition to my series of blog posts on jQuery Mobile: jQuery Mobile Introduction & Tips To Get Started jQuery Mobile Getting Started So, if you've been following my posts so far, you should have a good overview of jQuery Mobile, it's documentation, how to set up your...
  • message icon with count disply.
    3/28/2012 by SONAL KHAIRE
    add message icon with count displayed on it as new messages come into my gridview. i want to do this in asp.net for web application.

Raghav Khunger's latest blog posts

Product Spotlight

ASP.NET Hosting Spotlight

 

Quick Vote

What kind of email newsletter would you prefer to receive from CodeAsp.Net?