How to Execute a stored procedure

Execute a stored procedure

1.       In Object Explorer, connect to an instance of the SQL Server Database Engine, expand that instance, and then expand Databases.

2.       Expand the database that you want, expand Programmability, and then expand Stored Procedures.

3.       Right-click the user-defined stored procedure that you want and select Execute Stored Procedure.

4.       In the Execute Procedure dialog box, specify a value for each parameter and whether it should pass a null value.

You need to add a , between the paramValue1 and paramValue2. You missed it.

EXEC proc_name 'paramValue1','paramValue2'