Geeks With Blogs

News





INauseous() Shawn Cicoria - Solution Architect, Craftsman and Artisan - INauseous() - Main Blog Here: www.Cicoria.com

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


		        
		
			Posted on Thursday, November 15, 2007 2:57 PM


		SQL
	
 | Back to top
		
		


Comments on this post: How to get a list of SQL Procedures, Functions, Views that have recently change?

Comments are closed.
Comments have been closed on this topic.
Copyright © Shawn Cicoria | Powered by: GeeksWithBlogs.net