How to check the tables affected

  • Hi...

    Is there anyway to check the number of tables affected from a remote stored procedure call..... is there anyway other than writing triggers..

    If there is any query which inserts the data related to this...?

  • There is no way to tell unless you have logging inside the stored procedure.

    You can see the dependecies of the stored procedure that may not tell you how many tables are affected with DML statement.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply