x

[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

Cyborg gravatar image

Cyborg
10.6k 36 40 45

(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:


3 answers: sort newest

Sorry all!

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

more ▼

answered Sep 06, 2010 at 01:46 AM

Cyborg gravatar image

Cyborg
10.6k 36 40 45

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

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x476
x22

asked: Sep 06, 2010 at 01:43 AM

Seen: 3035 times

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