<div>
it is about: Using SQL Trace for Auditing.<br />
there are two options<br />
1. SQL Server Profiler<br />
and<br />
2. SQL Trace<br />
but i do not understand : <b>can be used from within applications</b><br />
<br />
can you give me an example with T-SQL
</div>


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

<div>
Where did you come across &quot;can be used from within applications&quot;? In a book? a conversation? a web page? here at EE?<br />
<br />
Please provide a larger quotation or a reference.
</div>


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.

<div>
In a book. Oficial course 10775
</div>


<div>
<b>SQL Server Profiler</b> is used to trace commands sent to the server and errors returned<br />
Can be heavy on resources<br />
Is run interactively<br />
Can trace command executions<br />
<b>SQL Trace</b><br />
Supplied as a set of system stored procedures that allow creation of traces<br />
Can be used from within applications<br />
Is relatively light-weight when well-filtered
</div>


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

<div>
<div class="content wysiwyg-content">
Hi experts:<br />
<br />
i am reading about SQL Trace<br />
but i do not understand: <b>Can be used from within applications</b>
</div>
</div>


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

SQL Trace

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.