http://snipplr.com/language/sql/tags/modified Recent snippets posted on Snipplr.com en-us Thu, 20 Jun 2013 15:37:31 GMT http://snipplr.com/view/63536/last-modified/ Lists when tables, stored procedure, views and functions where last modified. Shows only modified items within the last 14 days.

]]> Thu, 23 Feb 2012 20:01:21 GMT http://snipplr.com/view/63536/last-modified/ http://snipplr.com/view/2595/created-date--last-modified-date-triggers/ First, create two new fields in your table "Created", and "LastModified" as "datetime" fields, being sure to allow nulls. Then run this code as a query to create triggers that will update the appropriate field when a record is modified, or a record is inserted. This proves very useful when you're dealing with a huge database. In the code below replace [TableName] with your actual table name, and replace [UniqueID] with a unique ID field name in your table.

]]> Thu, 03 May 2007 10:52:06 GMT http://snipplr.com/view/2595/created-date--last-modified-date-triggers/