SP with in SP

[twigs1981]

I am trying to create a that calls other stored procedures. If I call one and it fails I want to roll back, but I when I try to do something like

declare @MyResult nchar (50)
SET @MyResult = EXEC master.dbo.sp_addrolemember @role, @username

I get "Error 156: Incorrect syntax near keyword 'EXEC'". Could someone point me in the right direction?

Thank you!

 

[vadimg]

declare @MyResult nchar (50)
EXEC @MyResult = master.dbo.sp_addrolemember @role, @username