Loading ...

SQL: List of stored procedures modified in last n Days

Who is online?  0 guests and 1 members
home  »  blogs  »  Raghav Khunger  »  SQL: List of stored procedures modified in last n Days

SQL: List of stored procedures modified in last n Days

(0)
(691)
4.87
/5
Avg: 4.87/5: (1 votes)

posted 2/21/2012  by Raghav Khunger

Below is the script to get list of stored procedures in last n days.

SELECT  [name]
FROM    sys.objects
WHERE   [type] = 'P'
        AND DATEDIFF(dd, [modify_date], GETDATE()) < 10

Above 10 is the number of days. You can change that value according to your need. Below is the output of my screen after running the above script on AdventureWorks DB:


 tags: SQL, sql-server, sql-server-2008, stored-procedures

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?