Where to put Stored Procedures in SQL 2005

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pvong - 24 Jul 2008 18:28 GMT

I'm trying to save a SP into the DB but it's asking me for a location. I'm
doing this in SQL Mgmt Studio. This is my first SP from Mgmt Studio. I
don't want the SP to be a file. I want it in the DB.

Reply to this Message

Aaron Bertrand [SQL Server MVP] - 24 Jul 2008 18:33 GMT

When you CREATE a procedure in Management Studio, you do so by executing the
CREATE PROCEDURE statement, and make sure that the query window has the
context of the correct database (you can do so with a USE database command,
or by changing the value in the database dropdown in the toolbar). The save
button is for saving the script as a file. Which is not a bad idea to do
so, but this has nothing to do with the actual object in the database. Think
of the script file as the source code to a DLL or EXE, and the procedure
itself as the DLL or EXE.

On 7/24/08 1:28 PM, in article eT8rQJb7IHA.5440@TK2MSFTNGP02.phx.gbl,

> I'm trying to save a SP into the DB but it's asking me for a location. I'm
> doing this in SQL Mgmt Studio. This is my first SP from Mgmt Studio. I
> don't want the SP to be a file. I want it in the DB.

Reply to this Message

Andrew Morton - 25 Jul 2008 11:27 GMT

> I'm trying to save a SP into the DB but it's asking me for a
> location. I'm doing this in SQL Mgmt Studio. This is my first SP
> from Mgmt Studio. I don't want the SP to be a file. I want it in
> the DB.

Click the "Execute" button.

Andrew

Reply to this Message