Post reply

tables affected after procedure run

  • October 22, 2008 at 10:17 pm

    #200167

    can anyone suggest some querry with which i can find how many tables were affected( with insert or update) with last querry.

    say if i run some procedure

    insert_into_tables (............)

    update_into_tables(................)

    then

    i run some command which shud return the name of tables which got some value inserted or updated with the previous procedure

    kindly help

  • October 22, 2008 at 11:02 pm

    #888452

    shiwani2002sg (10/22/2008)

    can anyone suggest some querry with which i can find how many tables were affected( with insert or update) with last querry.

    say if i run some procedure

    insert_into_tables (............)

    update_into_tables(................)

    then

    i run some command which shud return the name of tables which got some value inserted or updated with the previous procedure

    kindly help

    Use SQL profiler where on the basis of the options you choose, you can track each and every change.

    or, if you are looking for any other solution. please let me know

    kshitij kumar
    kshitij@krayknot.com
    www.krayknot.com

  • October 23, 2008 at 4:52 am

    #888535

    thanks for ur valueable time n support

    but is there any other way to find the name of tables got affected by last procedure

    coz, m using SQL Server 2005 bt unable to lead profiler, each time i open it says ' The application failed to initialize peroperly(0xc00000005)'

    i tried to install sql 3 to 4 times bt each time gives same error.

    can i use any other inbuild log or function as ::fn_dblog () etc. bt i think these ones dont return table names bt just inform abuot insert or delete , update etc

    Thanks

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

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