Skip to content

SQLServer.info

SQL Server Help And Tips

  • Home
  • About
  • Contact

easy

Get The Modified Date Of A Stored Procedure [Easy]

December 1, 2017 by robert
Facebooktwitterredditpinterestlinkedinmail

I just wanted to share the easiest way to get the modified date from a stored procedure in SQL Server. You do it just by accessing the Procedures table.

1
2
3
4
5
SELECT Name,
Create_Date,
Modify_Date
FROM sys.Procedures
WHERE Name = 'Animal_Update'

Categories maintenance Tags easy, selecting, server, stored procedures, t-sql, tips Leave a comment

Recent Posts

  • SQL Server Data Types To JSON Data Types
  • Get The Modified Date Of A Stored Procedure [Easy]
  • SQL Server Nested Select
  • SQL Server Kill All Connections
  • Script Multiple Objects [Easy]

Categories

  • basics
  • data formatting
  • database design
  • errors
  • maintenance
  • management studio
  • sql server management
  • syntax
  • tools

Archives

  • December 2017
  • November 2017
  • September 2017
  • August 2017
  • July 2017
  • May 2017
  • July 2016
  • February 2015
  • November 2014
  • October 2014
  • May 2014
  • April 2014
  • March 2014
  • February 2014
© 2023 SQLServer.info • Built with GeneratePress