[Closed] 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?

more ▼

asked Sep 06, 2010 at 01:43 AM in Default

avatar image

10.8k 37 55 51

(comments are locked)
10|1200 characters needed characters left

The question has been closed Sep 07, 2010 at 08:27 PM by Cyborg for the following reason:

1 answer: sort voted first

Sorry all!

I got the solution, by using sysprocesses in SQL Server 2000

more ▼

answered Sep 06, 2010 at 01:46 AM

avatar image

10.8k 37 55 51

then mark this as correct ... ;)

Sep 06, 2010 at 03:25 AM Fatherjack ♦♦

Is it possible to mark my own answer as a correct one?

Sep 06, 2010 at 04:45 AM Cyborg

@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 :)

Sep 06, 2010 at 03:32 PM Oleg

Thanx Oleg, Once I got 3 Up votes then only i can accept my answer as correct?

Sep 06, 2010 at 08:38 PM Cyborg

@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 :)

Sep 07, 2010 at 12:07 AM WilliamD
(comments are locked)
10|1200 characters needed characters left

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 06, 2010 at 01:43 AM

Seen: 4325 times

Last Updated: Sep 06, 2010 at 03:26 AM

Copyright 2017 Redgate Software. Privacy Policy