How to add a procedure to my database.

Question

I have a procedure and i don't get any option to add that to my database.

Jignesh Trivedi · Answer

hi are you using Management studio for SQL server or Visual studio IDE? please refer http://msdn.microsoft.com/en-IN/library/ms345415%28v=sql.100%29.aspx http://msdn.microsoft.com/en-in/library/ms345415.aspx hope this will help you.

Arul Manivannan · Answer

Hi Santhosh Just right click on the database in SQL Server management studio and select new query a plain text tab will be displayed.Just paste your procedure code and execute it. Thanks Arul Manivannan