July 27, 2016 at 1:48 pm
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
August 4, 2016 at 3:02 am
jmlc1 (7/27/2016)
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
To a large extent this depends on what it is you are trying to trace.
It may be simpler that you write some custom code into your procedures to handle this but there are also features such as Change Data Capture (CDC) which can help you capture activity against a Table.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply