Go Back   CodingForums.com > :: Server side development > MySQL > Other Databases

Before you post, read our: Rules & Posting Guidelines

Reply
 
Thread Tools Rate Thread
Enjoy an ad free experience by logging in. Not a member yet? Register.
Old 03-07-2007, 11:33 PM   PM User | #1
jedimastermopar
Regular Coder

 
Join Date: Nov 2006
Posts: 106
Thanks: 0
Thanked 0 Times in 0 Posts
jedimastermopar is an unknown quantity at this point
MSSQL - Viewing queries?

Hey,
Just wondering if anyone knows how to view the active and running queries being run against a MS SQL Server 2005? I used to be able to do it in 2000 but can't figure it out in 2005

Last edited by guelphdad; 03-08-2007 at 03:35 PM..
jedimastermopar is offline   Reply With Quote
Old 03-08-2007, 09:57 PM   PM User | #2
nikkiH
Senior Coder

 
nikkiH's Avatar
 
Join Date: Jun 2005
Location: Near Chicago, IL, USA
Posts: 1,973
Thanks: 1
Thanked 32 Times in 31 Posts
nikkiH is on a distinguished road
SQL Server 2005?
http://searchsqlserver.techtarget.co...A&topic=301323

http://msdn2.microsoft.com/en-us/library/ms181091.aspx
__________________

If this post contains any code, I may or may not have tested it. It's probably just example code, so no getting knickers in a bunch over a typo, OK? If it doesn't have basic error checking in it, such as object detection or checking if objects are null before using them, put that in there. I'm giving examples, not typing up your whole app for you. You run code at your own risk.
Bored? Visit
http://www.kaelisspace.com/
nikkiH is offline   Reply With Quote
Old 03-09-2007, 05:45 AM   PM User | #3
SSJ
Regular Coder

 
Join Date: Mar 2007
Posts: 230
Thanks: 0
Thanked 4 Times in 4 Posts
SSJ is an unknown quantity at this point
Thanks NiKKi.
Really very helpful articles...
__________________
Best Joomla Design Agency India ||PSD to Joomla Template || Award Winning Web Design Company India
SSJ is offline   Reply With Quote
Reply

Bookmarks

Jump To Top of Thread


Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +1. The time now is 08:58 AM.


Advertisement
Log in to turn off these ads.