Looks like I should have done more research before posting - here's an example for anyone else with the same problem to solve:

http://support.microsoft.com/default.aspx?scid=kb;en-us;262499

Thanks Paul - tyruns out I do need to capture an output value from my execution statement, however, it doesn't appear that you can specify an out parameter for sp_executesql,...

One of my pet peeves with 2000 was the inability to create user-defined roles and grant more granular DDL actions to a user (none of the 'alter' commands, for example, could...

Thanks!  That worked - my T-SQL is rusty - I forgot about using the system vars...