restoring the deleted record

**Syed Hadi** · Mar 23 '13, 12:59 PM

Firstly I want know that can we restored the deleted record back to its orignal place some column having the unique identity if yes then how.. ?
and i tried this
i search in web i found this the data is geting bak in hexa form ... even i cant able to convert it to normal form.......

Code:

SELECT [RowLog Contents 0] 
FROM   sys.fn_dblog(NULL, NULL) 
WHERE  
       AllocUnitName = 'dbo.TBLCOUNTERS'        
   AND Context IN ( 'LCX_MARK_AS_GHOST', 'LCX_HEAP' )        
   AND Operation in ( 'LOP_DELETE_ROWS' )