Solved

look at recent run queries in SQL 2000

Posted on 2011-09-24
2
254 Views
Last Modified: 2012-05-12
since there was no DMV, is there any other mechanism how we could check recent run queries if they are still in cache in 2000 version?
0
Comment
Question by:25112
2 Comments
 
LVL 20

Accepted Solution

by:
Marten Rune earned 500 total points
ID: 36594484
In SQL 2000, you need to start a trace first (i e profiler).

//Marten
0
 
LVL 5

Author Comment

by:25112
ID: 36595099
ok-
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to shrink a transaction log file down to a reasonable size.

914 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