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:
Please see the BOL Reference on
A procedure name is an identifier name in SQL Server, and it follows the rules of the database identifiers. For object names I prefer to use the special data type sysname (a synonym for NVARCHAR(128)).
PS: see @ThomasStringer's example on an execution.
PS2: if later you'll need to add parameters, the best way to do that is to execute with sp_executesql.