Welcome to CedarLogic, LLC - Shawn Cicoria Sign in | Join | Help

Shawn Cicoria - CedarLogic

Perspectives and Observations on Technology

News





  • Unity08.com

November 2007 - Posts

How to get a list of SQL Procedures, Functions, Views that have recently change?
Today, I needed a quick view of what objects in a SQL DB had changed. The following get's me that in a nice list: SELECT [name], [type], create_date, modify_date FROM sys.objects WHERE [type] in ('P', 'FN', 'V') order by Modify_Date desc Read More...