SQL Trace

Hi experts:

i am reading about SQL Trace
but i do not understand: Can be used from within applications
enrique_aeoAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
That's correct you can initiate a trace within the application, for example all the sql server monitoring tools uses sql server traces.
0
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
If you could provide a link / context that would be helpful. I think it referring to the fact that, you can create / start / stop a trace from application
0
 
enrique_aeoAuthor Commented:
it is about: Using SQL Trace for Auditing.
there are two options
1. SQL Server Profiler
and
2. SQL Trace
but i do not understand : can be used from within applications

can you give me an example with T-SQL
0
Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

 
PaulCommented:
Where did you come across "can be used from within applications"? In a book? a conversation? a web page? here at EE?

Please provide a larger quotation or a reference.
0
 
enrique_aeoAuthor Commented:
In a book. Oficial course 10775
0
 
enrique_aeoAuthor Commented:
SQL Server Profiler is used to trace commands sent to the server and errors returned
Can be heavy on resources
Is run interactively
Can trace command executions
SQL Trace
Supplied as a set of system stored procedures that allow creation of traces
Can be used from within applications
Is relatively light-weight when well-filtered
0
 
enrique_aeoAuthor Commented:
Can you give me T-SQL
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.