Comments on snippet: 'Created Date & Last Modified Date Triggers'

huycaguy said on 12/10/07

Mon, 10 Dec 2007 12:18:45 GMT

sbarron1: make sure you use created 2 fields in your table

Created -> datetime LastModified -> datetime

Replace [TableName] with your table name -> make sure correct table name

Mon, 10 Dec 2007 12:14:09 GMT

Thanks. It works great!

Mon, 12 Nov 2007 09:59:22 GMT

I can not get it to work. I copied the code and changed the table names and I keep getting this error.

Msg 8197, Level 16, State 4, Procedure trBrandCreateDate, Line 2 The object 'Brand' does not exist or is invalid for this operation.

Can you please help.