Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain raiserror in sql server?

1032

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

1150

Explain about link server in sql server?

1062

Is BCNF better than 2NF & 3NF? Why?

1051

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1213

How to how to convert numeric expression data types using the convert() function??

1057

How many instances per computer are there in sql server 2000?

1083

How to use the inserted and deleted pseudo tables?

966

How to transfer a table from one schema to another?

1007

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

944

how to create a scrollable cursor with the scroll option? : Sql server database administration

1097

What is transaction server consistency?

1053

How to search for a string in all stored procedure in sql server?

1003

What is clustered vs nonclustered index?

949

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

2934