Hello. 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.