Connect to a SQL Server Database Engine instance in Object Explorer, expand that instance, and then expand Databases. Expand the database you wish to work with, then Programmability, then Stored Procedures. Select Execute Stored Procedure from the context menu of the user-defined stored procedure you want to utilise.