MSSQL - Viewing queries?

jedimastermopar

03-07-2007, 11:33 PM

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

nikkiH

03-08-2007, 09:57 PM

SQL Server 2005?
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1159433,00.html?bucket=ETA&topic=301323

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

SSJ

03-09-2007, 05:45 AM

SQL Server 2005?
http://searchsqlserver.techtarget.com/tip/0,289483,sid87_gci1159433,00.html?bucket=ETA&topic=301323

http://msdn2.microsoft.com/en-us/library/ms181091.aspx
Thanks NiKKi.
Really very helpful articles...