I have a MS SQL Database. With a table named Products. Field name pID (pri Key) and pModified (smalltimedate). I have approx. 2000 products entered. I have to edit each product with HTML in my site admin section. currently it looks like this on the product listing*** 28451 African lady*** . I would for it to be *** 28451 African lady last modified 11/24/04 6:42pm***. This is to show which products have been modified. I am new to SQL Database, using EMS SQL Manager and frontpage 2003. It is an ASP Site. I would like to know how to create the trigger and a small script to show the last modified time/date on the webpage.