Problem With Rollback Statement

Hi,





I have written a store procedure which inserts data into two tables. What I want do is to rollback transaction if the second insert fails. Below is a code.





Does anyone see my error?





Thanks,





poc1010








Create proc AddProducts





@dcint=null,


@pcint=null,


@imagepathvarchar(50)=null,


@typevarchar(2)=null,


@descriptionvarchar(1000)=null,


@gendervarchar(8)=null,


@productidint=null,


@pccodevarchar(2)=null,


@weightvarchar(80)=null,


@pricemoney=null,


@activevarchar(1)=null





as





declare @errorsave int


set @errorsave=0


declare @dg int





Begin transaction





insert productdescription(


designercategory,


productcategory,


imagepath,


type,


[description],


gender)


values(@dc,


@pc,


@imagepath,


@type,


@description,


@gender)





if @@error <> 0


set @errorsave=@@error





set @dg = @@identity





begin


insert Products(


productid,


designergroup,


designercategory,


productcategory,


pccode,


weight,


price,


active)


values(@productid,


@dg,


@dc,


@pc,


@pccode,


@weight,


@price,


@active)








if @@error <> 0


set @errorsave=@@error


end








if @errorsave <> 0


begin


print 'Insert into Products tables failed'


rollback transaction


return -5--Insert into Products tables failed


end








commit transaction


print 'Success'


return 0 --Success