If DDL fails is whole transaction rolled back to sql server?

Hi Shalini,

Yes , When DDL Fails , whole transaction rollback.

for more please refer below link.

i hope it will help you more.



http://sqlserverpedia.com/wiki/Transaction_Overview



Thanks.

If this help you please mark it as accepted answer.

just try like this
Declare @conunt int

Begin Transaction T1
begin
--DDl Statement
Set @count=@@RowCount-- will set no of rows affected by ddl statement.
if(@count>0)
Commit Transaction T1
else
Rollback Transaction T1
End
End Transaction T1
may helps you.