Solved

SQL Trace

Posted on 2014-12-15
7
153 Views
Last Modified: 2014-12-26
Hi experts:

i am reading about SQL Trace
but i do not understand: Can be used from within applications
0
Comment
Question by:enrique_aeo
  • 4
  • 2
7 Comments
 
LVL 75

Assisted Solution

by:Aneesh Retnakaran
Aneesh Retnakaran earned 500 total points
ID: 40501580
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
 

Author Comment

by:enrique_aeo
ID: 40501674
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
 
LVL 48

Expert Comment

by:PortletPaul
ID: 40501942
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
Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

 

Author Comment

by:enrique_aeo
ID: 40502273
In a book. Oficial course 10775
0
 

Author Comment

by:enrique_aeo
ID: 40508082
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
 
LVL 75

Accepted Solution

by:
Aneesh Retnakaran earned 500 total points
ID: 40508099
That's correct you can initiate a trace within the application, for example all the sql server monitoring tools uses sql server traces.
0
 

Author Comment

by:enrique_aeo
ID: 40510244
Can you give me T-SQL
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to shrink a transaction log file down to a reasonable size.

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now