<< Getting a winload.exe Missing or Corrupt after Cloning new drive... | Home | SharePoint Development Tools are Severely Lacking >>

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

		

			Print | posted on Thursday, November 15, 2007 2:57 PM
		

	

	


	

	
Comments have been closed on this topic.