Solved

Please advise how to enable trace on MS SQL server 2000

Posted on 2004-09-20
6
234 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
ID: 12109391
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
ID: 12109599
0
 
LVL 2

Expert Comment

by:vidnan123
ID: 12110277
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
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.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

679 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