Re: Sybase ASE - track all changes in DB made by a stored procedure

I suppose that you can do a code analysis to try to see which procs
are called from your proc, and which tables these modify, etc.

I know of a tool (non-free) that will do this for you and generate a
comprehensive report of the entire SQL code base (well - based on the
code in the database). You can check out www.sqlbrowser.com in case
you're interested.

Michael

On Mar 5, 9:16 am, Krzysztof Adamczyk
<krzysztof_DOT_adamczyk@xxxxxxxxxxxxxx> wrote:
Hi all,

I have a bunch of undocumented stored procedures (legacy).
What I want, is to find out for each procedure, what changes it makes
in all the database. We want to replace these procedures with some
equivalent (maby sth java-based), and thus I have to know what values
are modified, or inserted to the db.

What is the best approach to track these updates/inserts/deletes done by
stored procedure? Is it possible at all?

Regards,
Chris

.

Relevant Pages

  • Re: LINQ Queries vs Stored Procs
    ... Stored Procedures, you can limit the user to only executing stored ... most sql injection attacks, which are more possible with dynamic sql. ... Also about the security aspects: it's not as you claim it to be: I can ... I as a user in Marketing have to use your app which uses procs and I ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Brackets and special characters -- Brain Teaser
    ... because we dont have brackets around our table names. ... > are stuck with about two hundred stored procedures which don't have ... Unfortunately we cant strip special characters ... > procs query this db. ...
    (microsoft.public.sqlserver.programming)
  • Re: Newbie: Stored Procedures and Or Datasets ?
    ... > be a concensous that Stored Procedures are the most effective means to ... > mena less database access, can be optimised by the DBMS or Database ... query with parameters: procs are not precompiled. ... My .NET Blog: http://weblogs.asp.net/fbouma ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MSSQL vs. SYBASE
    ... > Adding RAISERROR is not an option, we would have to edit 1,000+ stored ... > procs. ... Then you would have to tame ADO. ... 1000 stored procedures in one database. ...
    (microsoft.public.sqlserver.programming)
  • Re: Database Model - Class, objects and interaction
    ... I was just proving stored procedures can call views. ... stuff like security and logging. ... So given 100,000 users, you would create database accounts for each? ... Part of our system's integrity was its reliability, and reliability is often assisted by simplicity. ...
    (comp.object)