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

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
LVL 1
hidrauAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
jrtilsonConnect With a Mentor Commented:
0
 
hidrauAuthor Commented:
does this work for what I need?
0
 
David ToddConnect With a Mentor Senior DBACommented:
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
0
 
hidrauAuthor Commented:
thanks
0
All Courses

From novice to tech pro — start learning today.