Avatar of enrique_aeo
enrique_aeo
 asked on

SQL Trace

Hi experts:

i am reading about SQL Trace
but i do not understand: Can be used from within applications
Microsoft SQL Server

Avatar of undefined
Last Comment
enrique_aeo

8/22/2022 - Mon
SOLUTION
Aneesh

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
enrique_aeo

ASKER
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
PortletPaul

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.
enrique_aeo

ASKER
In a book. Oficial course 10775
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
enrique_aeo

ASKER
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
ASKER CERTIFIED SOLUTION
Aneesh

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
enrique_aeo

ASKER
Can you give me T-SQL