SQL Server – Get Last Modified Function

  By ,

To get the last modified function​​ date, execute the script below.

 

 

SELECT​​ name,

 type_desc

 create_date,

 modify_date

FROM​​ sys.objects​​ 

WHERE​​ RIGHT(type_desc,​​ 8)​​ =​​ 'FUNCTION'

ORDER​​ BY​​ modify_date​​ DESC

 

 

 

Knowledge worth sharing...Share on linkedin
Linkedin
Share on facebook
Facebook
Share on google
Google
Share on twitter
Twitter

Related posts:

  1. SQL Server – Get Index Creation Date
  2. SQL Server – Reinitializing a Single Article In Transaction Replication
  3. SQL Server – Get the Table Structure Using T-SQL
  4. SQL Server – Resolve Error 5030 to Rename Database
Tagged  , , , , , , , , , .
Bookmark the permalink.

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *