This is easily done, so let us explain how. OK, so begin by opening the SQL Server tool. From there, choose the database where you want to create a stored procedure.