InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 23 May 2013 04:41:43 GMT20http://www.sqlservercentral.com/Forums/Topic1071141-392-1.aspxHey thanks HowardW.I got the details and now I have updated myself :-PRegards,AJTue, 01 Mar 2011 07:22:55 GMTAJ07http://www.sqlservercentral.com/Forums/Topic1071141-392-1.aspxNo, pretty much everything that happens within the scope of an individual database is part of the transaction and can be rolled back, including DDL and indeed TRUNCATE (another transaction myth).Have a look here for T-SQL Statements that are not allowed within a transaction:[url]http://msdn.microsoft.com/en-us/library/ms191544.aspx[/url]Tue, 01 Mar 2011 06:12:59 GMTHowardWhttp://www.sqlservercentral.com/Forums/Topic1071141-392-1.aspxHi Guys, I had this understanding that the DDL statements are autocommit statements and if any DDL statement is written in any TRANSACTION then as the DDl statement executes all the DML before it got commit.I tried below script -CREATE TABLE AJ1 (ID INT IDENTITY(-1,1))--CREATE TABLE AJ2(ID INT IDENTITY(-1,-1))INSERT INTO AJ1 Default valuesINSERT INTO AJ1 Default valuesINSERT INTO AJ1 Default valuesBEGIN TRANINSERT INTO AJ1 Default valuesINSERT INTO AJ1 Default valuesINSERT INTO AJ1 Default values--DROP TABLE AJ1CREATE TABLE AJ2(ID INT IDENTITY(-1,-1))INSERT INTO AJ1 Default valuesINSERT INTO AJ1 Default valuesINSERT INTO AJ1 Default valuesRollBack select * from AJ1select * from AJ2I am getting the below mentioned message - (1 row(s) affected)(1 row(s) affected)(1 row(s) affected)(1 row(s) affected)(1 row(s) affected)(1 row(s) affected)(1 row(s) affected)(1 row(s) affected)(1 row(s) affected)ID------------101(3 row(s) affected)Msg 208, Level 16, State 1, Line 23Invalid object name 'Aj2'So now I am a bit confused that DDL statements can be rolledback if written in TRANSACTION.Any suggestion or reference.Regards,AJTue, 01 Mar 2011 05:57:48 GMTAJ07