April 22, 2005 at 6:14 am
1) how to get the last updated record in a table in SQL2000
April 22, 2005 at 6:16 am
Unless you have a trigger that keeps track of the changes, you'll have to buy a log explorer software to extract that info. Sql server doesn't keep track of that information anywhere else than the transaction log.
April 22, 2005 at 7:18 am
You would need to add a column like Last_Updated and then create a trigger to update the column whenever something was inserted/updated on the table.
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
April 24, 2005 at 10:49 pm
Yeah thanks for that.. Now another question...similar to the one above..Is it possible to know the last updated table..
April 25, 2005 at 6:20 am
You would have to create a table that held the data such as TableName and LastUpdtated and then put a trigger on every table to update your Table.
----------------
Jim P.
A little bit of this and a little byte of that can cause bloatware.
April 25, 2005 at 10:33 pm
thanks for those..
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply