You could use Database Workbench to trace the dependancies. Start at the triggers and any procedures used by client programs, and trace back.

Rick DeBay

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Adam
Sent: Wednesday, September 28, 2005 7:55 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Usage of SPs?

--- In firebird-support@yahoogroups.com, Sándor Tamás (HostWare Kft.) <sandortamas@h...> wrote:
> I see your point. But we have almost 600 SP's, and I think that some
of them are depricated. And the only way to find them is to run our application with full functionality, and see what SPs are used.
> At least is there a way to change these SPs all at once with some proc?

Yuck. Those shortcuts always come back to haunt you (or someone after you). You could find a tool that extracts the SP code. That would be my first step. You could then write a procedure that finds the word after "ALTER PROCEDURE" (the procedure name), then inserts some string immediately following the next begin, then run the script.

Adam






> ----- Original Message -----
> From: Adam
> To: firebird-support@yahoogroups.com
> Sent: Wednesday, September 28, 2005 1:38 AM
> Subject: [firebird-support] Re: Usage of SPs?
>
>
> --- In firebird-support@yahoogroups.com, Sándor Tamás (HostWare Kft.)
> <sandortamas@h...> wrote:
> > Hi,
> >
> >
> > Is there any possibilities to find out which procedures are used
from a
> > database in a time interval? Let's say like a counter or something?
> >
> > SanTa
>
> No.
>
> It would be rather trivial though to create a table to store that
> information and modify the stored procedure to add a record to it.
> Always insert ('SP_Name', 1) into the table, do not run "update .. set
> cnt = cnt + 1 where name = 'SP_Name'", because this will prevent the
> SP calls from occuring simultaneously.
>
> Basically, this method is an efficient way of counting
>
> http://groups.yahoo.com/group/firebird-support/message/56457
>
> Adam
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://firebird.sourceforge.net and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]




------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back!
http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/67folB/TM
--------------------------------------------------------------------~->

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Yahoo! Groups Links