Web Technologies Logger
Pages
Home
Contact Us
About Us
Sitemap
Privacy Policy
Search This Blog
Thursday, 11 October 2012
Roll Back Deleted Data in sql
We shoule have Full permission of Database
Select [RowLog Contents 0] FROM sys.fn_dblog(NULL, NULL) WHERE AllocUnitName = 'dbo.Employee'
AND Context IN ( 'LCX_MARK_AS_GHOST', 'LCX_HEAP' ) AND Operation in ( 'LOP_DELETE_ROWS' )
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment