Solved

Please advise how to enable trace on MS SQL server 2000

Posted on 2004-09-20
6
228 Views
Last Modified: 2012-06-22
Please advise how to enable trace on MS SQL server 2000. This is some thing equivalent to enabling Auditing on Oracle DB.
0
Comment
Question by:surendranadh
6 Comments
 
LVL 2

Accepted Solution

by:
Kolya_Tchernitsky earned 100 total points
Comment Utility
Use SQL Profiler or Profiler procedures. Thisi will allow you to create your own trace based on standard events, you will be able to use filters etc
0
 
LVL 6

Expert Comment

by:peyox
Comment Utility
0
 
LVL 2

Expert Comment

by:vidnan123
Comment Utility
You can refer this link for a step-by-step process for using the SQL profiler to track the database activities of your application.

http://techrepublic.com.com/5100-6268_11-1043670-2.html
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

744 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