Skip to content

Rizwan Ahmed

Digital transformation enabler and cricketer

  • Home
Home2012June

Month: June 2012

Getting List of Last Modified Procedures (SQL Server)

June 6, 2012June 6, 2012 Rizwan Ahmed SQL Server

You can get list of modified stored procedures by using following:

SELECT name FROM sys.objects WHERE type = ‘P’ AND DATEDIFF(D,modify_date, GETDATE()) < 7

1 Comment

Archives

  • July 2022 (2)
  • February 2020 (1)
  • January 2018 (1)
  • August 2017 (2)
  • January 2017 (1)
  • November 2016 (1)
  • May 2016 (1)
  • March 2016 (2)
  • December 2015 (2)
  • October 2015 (1)
  • July 2014 (1)
  • April 2014 (1)
  • March 2014 (1)
  • February 2014 (1)
  • January 2014 (1)
  • December 2013 (2)
  • August 2013 (1)
  • May 2013 (1)
  • April 2013 (1)
  • March 2013 (2)
  • February 2013 (2)
  • January 2013 (1)
  • December 2012 (1)
  • November 2012 (4)
  • October 2012 (2)
  • June 2012 (1)
  • March 2012 (2)
  • November 2011 (1)
  • August 2011 (6)
  • July 2011 (6)
  • June 2011 (3)
  • July 2010 (1)
  • March 2010 (2)
  • March 2009 (1)

Recent Posts

  • D365 – Dev Enviornment – Missing event logs
  • D365 Database sync – command
  • D365 F&O DBSync Error – ##[error]SYNCENGINE(0,0): Error Number: -2,State:0,Class:11
  • D365 Operations – Table Synch error (Error : System.InvalidOperationException: Table ‘XXXXXXX’: Converting Field ‘XXXXXX’)
  • IDX10205: Issuer validation failed for D365 Operations

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 149 other subscribers
Create a free website or blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • Rizwan Ahmed
    • Already have a WordPress.com account? Log in now.
    • Rizwan Ahmed
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar