When you Edit a stored procedure in QA it comes up as an ALTER
PROCEDURE. So, you make your changes and execute it, and it alters
the procedure.
Roy Harvey
Beacon Falls, CT
On Thu, 16 Aug 2007 13:09:05 -0400, "Robert Morley"
[quoted text, click to view] <rmorley@magma.ca.N0.Freak1n.sparn> wrote:
>Okay, so people keep trying to convince me that the SQL 2000 QA is all great
>& powerful, etc. In three years, I've never had much use for it except as
>an immediate execution window and occasional query-plan verification tool,
>but have decided to "get to know it better" in the hopes that somehow it'll
>prove to be as useful as everyone keeps trying to convince me it is. So,
>needless to say, I was more than a little surprised when something so simple
>tripped me up.
>
>I right-clicked an object (a Stored Procedure) in the Object Browser and
>chose "Edit". I made my changes. Now I want to save those changes back to
>the object it came from, but I'm damned if I can figure out how to do
>something that to me seems like it should be simple and obvious. Save to
>File is right there, but that's not what I want to do. How do I save the SP
>I'm editing back to the database?
>
>
>
>Thanks,
>Rob
D'oh! I even remember noticing it was an ALTER PROCEDURE, and just never
clued in. Thanks, Roy.
Rob
[quoted text, click to view] "Roy Harvey" <roy_harvey@snet.net> wrote in message
news:ts29c312v3o3isbhgvj17iefdl6qpp4pqs@4ax.com...
> When you Edit a stored procedure in QA it comes up as an ALTER
> PROCEDURE. So, you make your changes and execute it, and it alters
> the procedure.
>
> Roy Harvey
> Beacon Falls, CT
>
> On Thu, 16 Aug 2007 13:09:05 -0400, "Robert Morley"
> <rmorley@magma.ca.N0.Freak1n.sparn> wrote:
>
>>Okay, so people keep trying to convince me that the SQL 2000 QA is all
>>great
>>& powerful, etc. In three years, I've never had much use for it except as
>>an immediate execution window and occasional query-plan verification tool,
>>but have decided to "get to know it better" in the hopes that somehow
>>it'll
>>prove to be as useful as everyone keeps trying to convince me it is. So,
>>needless to say, I was more than a little surprised when something so
>>simple
>>tripped me up.
>>
>>I right-clicked an object (a Stored Procedure) in the Object Browser and
>>chose "Edit". I made my changes. Now I want to save those changes back
>>to
>>the object it came from, but I'm damned if I can figure out how to do
>>something that to me seems like it should be simple and obvious. Save to
>>File is right there, but that's not what I want to do. How do I save the
>>SP
>>I'm editing back to the database?
>>
>>
>>
>>Thanks,
>>Rob
>>
