question

Cyborg avatar image
Cyborg asked

sys.dm_exec_requests in SQL Server 2000

Hi Experts, How can i find those queries that executed on a specific date in SQL Server 2000? From SQL Server 2005, we can use dmv "sys.dm_exec requests" what is its alternative in SQL Server 2000?
sql-server-2000dmv
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

Cyborg avatar image
Cyborg answered
Sorry all! I got the solution, by using sysprocesses in SQL Server 2000
13 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image WilliamD commented ·
@Cyborg you can accept any answer by clicking the tick that is near the thumb up and thumb down for an answer. This only appears to the person who asked the question (and maybe the moderators?). This is something you haven't done yet with most of your questions here, maybe a little housekeeping would be good on your part :)
1 Like 1 ·
Fatherjack avatar image Fatherjack ♦♦ commented ·
then mark this as correct ... ;)
0 Likes 0 ·
Cyborg avatar image Cyborg commented ·
Is it possible to mark my own answer as a correct one?
0 Likes 0 ·
Oleg avatar image Oleg commented ·
@Cyborg It should be possible, and as a matter of fact, there is a bronze badge titled **Self Learner** and defined as **Answered your own question with at least 3 up votes**. Let the first upvote be from me, so all you need is accept your answer and get 2 more upvotes :)
0 Likes 0 ·
Cyborg avatar image Cyborg commented ·
Thanx Oleg, Once I got 3 Up votes then only i can accept my answer as correct?
0 Likes 0 ·
Show more comments