We help IT Professionals succeed at work.

What exactly does the sp_trace_create do? Is it used for what?

hidrau
hidrau asked
on
Hello Guys,

I am creating an application that needs to trace all the update / insert and delete from my table XX,
My question is I wonder if this sp_trace_create is suitble for what I need?

I didn't understand for what is sp_trace_create

I thank any help
Comment
Watch Question

Author

Commented:
does this work for what I need?
David ToddSenior Database Administrator
CERTIFIED EXPERT
Commented:
Hi

sp_trace_create is one of the procedures behind profiler. Given that it will pretty much catch everything happening on the server unless filtered to exactly what you want and need, you are going to drown in data.

I would suggest that there are a couple of other approaches.

Firstly have a modifiedDatetime column and a modifiedBy column, and log the changes that occur. That is, don't update or delete a row, merely insert the new version. Maybe a status flag to say what happened - update or delete etc.

Another method is to have a corresponding audit table, and have three triggers - insert/update/delete which log the relevant data in the audit table.

I wouldn't have though of using sp_trace_create for what you suggest.

But did you read the info in the link given?

Cheers
  David

Author

Commented:
thanks

Explore More ContentExplore courses, solutions, and other research materials related to this topic.