Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 8 of 8 total |
How to edit stored procedures |
Thu, Feb 8 2007 9:57 PM | Permanent Link |
"Bern Rudisill" | Maybe I am missing something but how do you edit stored procedures?
Bern -- |
Fri, Feb 9 2007 3:38 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Fri, Feb 9 2007 5:04 PM | Permanent Link |
"Bern Rudisill" | 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? -- |
Sat, Feb 10 2007 2:39 AM | Permanent Link |
Muhammad Mamouri | 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 |
Sat, Feb 10 2007 5:23 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Sat, Feb 10 2007 12:33 PM | Permanent Link |
"Harry de Boer" | 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? > > -- > |
Sun, Feb 11 2007 9:56 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Sun, Feb 11 2007 9:57 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |