Tracing data movement through backend SQL stored procedures and functions

• jmlc1

  Valued Member

  Points: 66

  More actions

  July 27, 2016 at 2:10 pm

  #309854

  Hello. Hope I am posting in the correct forum. I have some database experience though I am somewhat new to SQL Server so I have what I think is a general question (I hope). It is as follows:

  "How to trace data movement through backend SQL stored procedures and functions?"

  In a nutshell, I just need some direction on this. Are there canned stored procs and or functions that can do this or does this have to be done via custom stored procs/functions? Any insight or just a general outline would on how to do this would be most helpful.

  Thanks for any help you can provide.

  Joe

• Guras

  SSCertifiable

  Points: 6518

  More actions

  July 28, 2016 at 10:15 am

  #1892518

  What do you mean by data movement? Are you trying to see what was the before and after value of a field after an updation?