Retrive Data after Delete or Update Row of Table.

Question

Retrive Data after Delete or Update Row of Table.

engr_faruque

SSC Enthusiast

Points: 192
More actions
June 9, 2010 at 2:38 am

#145345

Is it Possible?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Unless the delete/update in question was running within a transaction, no. Restore from backup.

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

Grant Fritchey SSC Guru Points: 398916 More actions · Answer 2

At the point of a delete or insert, you do have access to the deleted & inserted temporary tables that will allow you to see what was deleted or inserted, exactly at that point. You can load those into other locations for later use.

With SQL Server 2008 you can also look to Change Data Capture to see what has been modified or created within a table.

Other than that, it's exactly as Gail said.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

Grant Fritchey (6/9/2010)
At the point of a delete or insert, you do have access to the deleted & inserted temporary tables that will allow you to see what was deleted or inserted, exactly at that point. You can load those into other locations for later use.

Specifically that's within a trigger or the OUTPUT clause of the insert/update/delete.

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

Grant Fritchey SSC Guru Points: 398916 More actions · Answer 4

GilaMonster (6/9/2010)
Grant Fritchey (6/9/2010)
At the point of a delete or insert, you do have access to the deleted & inserted temporary tables that will allow you to see what was deleted or inserted, exactly at that point. You can load those into other locations for later use.
Specifically that's within a trigger or the OUTPUT clause of the insert/update/delete.

Right. Sorry I wasn't clear on that.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning