How can I execute a stored procedure whose name is in a variable? Given a variable that contains a stored procedure name:

DECLARE @stored_procedure_name varchar(512);
SET @stored_procedure_name = 'some_stored_procedure_name';


How can I execute the stored procedure (without passing in any arguments)?
You can use the variable directly:

exec @stored_procedure_name;


Please see the BOL Reference on EXECUTE.