How to know affected table in database. [Resolved]

Posted by Alok under Sql Server on 5/6/2016 | Points: 10 | Views : 278 | Status : [Member] | Replies : 1
suppose i am new to any project.
so i randomly hit my application like 'save'.
I want to know the names of all affected tables.
So is there any sql query through which i can know the affected tables in database. ?

Thanks & Regards,
Alokssm



Responses

Posted by: Professionaluser on: 5/6/2016 [Member] [MVP] Bronze | Points: 50

Up
0
Down

Resolved
Trace the SQL actions by opening SQL Profiler and create a trace

refer the below link for SQL Profiler usage,
http://www.codeproject.com/Articles/21371/SQL-Server-Profiler-Step-by-Step

Alok, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response