Finding the last table update SQL Server v 7.0
How can I determine the last update to a table in SQL Ser. 7.0
Re: Finding the last table update SQL Server v 7.0
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.
"John" <JohnVann@aol.com> wrote:
>How can I determine the last update to a table in SQL Ser. 7.0
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL