how to bring stored procedure under my database instead system database?

When you create the procedure you can either do one of 2 things


1.   In the code right before the create procedure statement say

USE [your database name here]
create procedure usp.yournamehere

2. 
In SQL Management Studio right below the New query button you should see a drop down box that has master database  in it ...simply select your database and then execute when you are creating

To fix this probably the easist thing to do would be delete it from master and re-create in your database

Hope that helps