I am using SQL server 2000 with SP4. On production database we want to find for Can SQL Server tell me which row was inserted, updated and deleted most recently?
we are not using any SQL SERVER Tools, Could anyone share this script.
No, not unless you have a trigger on the table tracking that info or a column that's updated with date and time of modifications
Gail Shaw Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci) SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter We stand on the bridge and no one may pass
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply