Maybe I am missing something but how do you edit stored procedures?

Bern

--

Bern,

<< Maybe I am missing something but how do you edit stored procedures? >>

You have to drop them and re-create them if you wish to modify them.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> Bern,
>
> << Maybe I am missing something but how do you edit stored
> procedures? >>
>
> You have to drop them and re-create them if you wish to modify them.

So in otherwords even though we wrote the stored proc in ElevateDB we
also have to keep the store proc somewhere else in text form.

So is there not an editor in ElevateDB to reedit a stored proc or view
etc once it is added?

--

SQL Server 2005 has a nice feature for this (May be there were such thing in 2000 too hat
I didn't know) When you want Modify and StoredProc, It automatically write a stored proc
that Alter the StoredProc that you want to modify it.
If ElevateDB does not support Alter for StoredProc, it can write a StoredProc that delete
existed StoredProc and Create a new one.


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Bern,

<< Maybe I am missing something but how do you edit stored procedures? >>

You have to drop them and re-create them if you wish to modify them.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


><< Maybe I am missing something but how do you edit stored procedures? >>
>
>You have to drop them and re-create them if you wish to modify them.

Is this forever and ever or until after the initial release stabilises and you get time to sort it out?

Roy Lambert

I believe you can do:

SELECT * FROM Information.Procedures

That way you don't need them in a txt file

Regards, Harry


"Bern Rudisill" <bernr@no-sp.am.exitcare dot com> schreef in bericht
news:6E31547B-7D28-41FD-9C5F-B98C807B86C4@news.elevatesoft.com...
> Tim Young [Elevate Software] wrote:
>
> > Bern,
> >
> > << Maybe I am missing something but how do you edit stored
> > procedures? >>
> >
> > You have to drop them and re-create them if you wish to modify them.
>
> So in otherwords even though we wrote the stored proc in ElevateDB we
> also have to keep the store proc somewhere else in text form.
>
> So is there not an editor in ElevateDB to reedit a stored proc or view
> etc once it is added?
>
> --
>

Bern,

<< So in otherwords even though we wrote the stored proc in ElevateDB we
also have to keep the store proc somewhere else in text form. >>

As Harry indicated, you can query the database's Information schema to find
out anything that you want to know about a given procedure:

http://www.elevatesoft.com/edb1sql_procedures_table.htm
http://www.elevatesoft.com/edb1sql_procedureprivileges_table.htm
http://www.elevatesoft.com/edb1sql_procedureprivileges_table.htm

That's how the EDB Manager gets its information for display - via queries on
the Information schema.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< Is this forever and ever or until after the initial release stabilises
and you get time to sort it out? >>

No, just initially.  The first minor release will most likely address this
issue.

--
Tim Young
Elevate Software
www.elevatesoft.com