1

Closed

Undelete Proc

description

Proc that recreates any deleted row and, if possible with current RI, reinserts the row as it was when it was deleted. Also inserts Undete event in audit trail log.
 
Parameters:
Schema, Table, PK
 
also reques modification of vTableDeleted view so it filteres out rows that were deleted but have now been undeleted.
Closed Apr 8, 2010 at 4:58 PM by PaulNielsenSQL
it's easy to insert ... select from the vTable_Deleted view. item closed.

comments