Solved

SQL Trace

Posted on 2014-12-15
7
152 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
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 

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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Dynamics crm 2011 8 46
SQL Server creating a temp table 7 39
SQL Split character from numbers 3 18
Join vs where 2 0
Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

746 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

9 Experts available now in Live!

Get 1:1 Help Now