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

Question

Hi I am using SQLSERVER 2005. when i create andy procedure I cannot see it under my database->programatic->stored procedrre instead it is storing under sytem database... How can I move or create them under my database....

Ken · Answer

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

Muneer · Answer

Thank you Ken.. It was very helpful I used the USE