Solved

Please advise how to enable trace on MS SQL server 2000

Posted on 2004-09-20
6
231 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
migration MS SQL database to Oracle 30 61
Sql Stored Procedure 65 26
SqlServer no dupes 25 34
Simple SQL query from two tables 13 54
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…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

770 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