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

Can we rollback records deleted by a truncate statement?

Question Posted / mp

Answer Posted / mp

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

Is This Answer Correct ?

6 Yes

9 No

Please Help Members By Posting Answers For Below Questions

What's new in sql management studio for sql server? : sql server management studio

1118

How to enable/disable indexes?

1121

What are cursors and when they are useful?

1149

Do you know sql server 2008 introduces automatic auditing?

1048

What is the difference between executequery () and executeupdate ()?

1109

What are the types of table?

1028

What are four major operators that can be used to combine conditions on a where clause?

1090

What is 1nf 2nf?

1058

What is the difference between the 2 operating modes of database mirroring?

1161

What is dynamic cursor in SQL SERVER?

1135

Differentiate between a having clause and a where clause.

1008

How do I uninstall sql server 2014?

985

What is the difference between dropping a database and taking a database offline?

1218

Explain datetimeoffset data type in sal server 2008?

971

What are the key configuration files for sql server reporting services ?

171