• kll (4/15/2010)


    Carlos Sacristan (4/15/2010)


    But what happens with the internal calls that a store procedure could make? For example, if sp_a calls sp_b, and sp_b is never called directly, you probably think that sp_b could be deleted

    Sp_b should have its own line, as it of course will have an SP_starting event to log.

    Personally I will be more afraid of missing some of the rarely used SPs. If they are named in a sane way, the name might tell you something. When I am in doubt, I rename the SP to something like SP_name_old and wait for something to break. If nothing breaks within a year or so, it should be safe to delete.

    Of course we all have backups and version control, so you could just delete the buggers and restore from CVS when something breaks. 😉

    That's true, I'm confused with rpc:completed and sql:batchcompleted, wich I usually use. Thanks