Finding the last table update SQL Server v 7.0

[John]

How can I determine the last update to a table in SQL Ser. 7.0
Thank you,

[AC]

Hi John,

You can write a trigger to monitor for an update of that table. The trigger
will look like:

select field_ID, some_field, other_fields,... from inserted

And then from the front-end (if you are doing something from web), you can
retrieve that recordset and show the ID value just like you retrieve any
recordset using ADO.

For other related case of inserting a record, you can use select @@identity
to retrieve ID for last inserted record.

Hope this would help.

AC

"John" <JohnVann@aol.com> wrote:
>
>How can I determine the last update to a table in SQL Ser. 7.0
>Thank you,