1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Can we rollback records deleted by a truncate statement?

Question Posted / mp

Answers were Sorted based on User's Feedback



Can we rollback records deleted by a truncate statement?..

Answer / 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

Can we rollback records deleted by a truncate statement?..

Answer / sathwika

yes we can rollback the truncated records

Is This Answer Correct ?    2 Yes 2 No

Can we rollback records deleted by a truncate statement?..

Answer / mp

No, because it is a DDL.
We can only rollback DML statements, right?

Is This Answer Correct ?    6 Yes 9 No

Post New Answer

More SQL Server Interview Questions

ow to bring suspect mode datbase online from scratch

0 Answers  

What is a trace frag? Where do we use it?

0 Answers  

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 Answers  

Can Having clause be used without Group by clause?

6 Answers   CarrizalSoft Technologies, CSC, CTS,

Define tempdb database?

0 Answers  




How to replace given values with null using nullif()?

0 Answers  

What is the advantage of sql server?

0 Answers  

What is Right Outer Join?

2 Answers  

How to Check Whether a Global Temporary Exists in a SQL Database or not?

2 Answers  

What is difference between oltp and olap?

0 Answers  

sql database suspect We have a sql database that is showing as suspect. How can we recover?

0 Answers  

What guidelines should be followed to help minimize deadlocks?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories