Published on: 25 Jan, 2021

How to find the last modified stored procedure in TSQL?

Tumblr Digg Google Plus

If you want to retrieve the latest modified stored procedure in TSQL. You can query the latest changes by looking into the sys.objects table with column type equals to 'P'.

Here is the TSQL query to get the latest modified stored procedure in SQL Server.


SELECT * 
FROM sys.objects
WHERE type = 'P'
ORDER BY modify_date DESC

Comments

There are no comments available.

Write Comment
0 characters entered. Maximum characters allowed are 1000 characters.