Interested to Buy Any Domain ? << Click Here >> for more details...
Can we rollback records deleted by a truncate statement?
- 3 Answers
- 8897 Views
- CarrizalSoft Technologies, United Healthcare, I also Faced
- E-Mail Answers
Answer Posted / anand
yes,we can ROLLBACK records deleted by truncate if we had
executed BEGIN TRAN first
ex:
Begin Tran
truncate table tablename
ROLLBACK
with out "Begin Tran" you can not rollback
| Is This Answer Correct ? | 18 Yes | 4 No |
Post New Answer View All Answers
What is difference between after and before?
What is self contained scalar sub query?
why would you call update statistics? : Sql server database administration
Explain following error properties?
Is profiler the only tool that has the ability to audit and identify ddl events? : sql server security
What are “unrepeatable reads”?
How will you find out if there are expensive SQL statements running or not?
Tell me about builtinadministrator?
What is the command used to recompile the stored procedure at run time?
What is precedence constraint?
Explain microsoft sql server functions?
How to transfer a table from one schema to another?
Can we use where clause in union?
How to concatenate two binary strings together?
Do you know the policy based administration feature of sql server 2008?
