Tracing data movement through backend SQL stored procedures and functions

1

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.

Joe

2

Nothing automatically does that. It would be huge overhead to do automatically since no one may ever need it.

Probably easiest would be to add logging logic to the start of each proc. You could also create a special table to store the caller info in, so that called procs could determine what proc called them.