INauseous()

November 2007 Entries

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

Archives

Post Categories

Image Galleries

Other Blogs

Twitter: cicorias building http://www.c...actoror http://spext...om/ -not sure which is the NEW url about 252 days ago

cicorias wiring my flat panel about 805 days ago

Tag Cloud