November 27, 2006 at 1:44 pm
How do we get the list of all the queries which are being executed in SQL Server 2005? Is there a tool for that?
November 27, 2006 at 2:16 pm
If you're curious about running transactions, I would look into the dynamic management views relating to transactions in Books Online, especially dm_tran_active_transactions and dm_tran_database_transactions.
November 27, 2006 at 2:25 pm
I want to know what is the equivalent of the sql profiler 2000 in sql server 2005 ?
I want to get the list of queries which are running at a time
November 27, 2006 at 2:31 pm
The profiler still exists in 2005. Except if you only have express edition!
November 28, 2006 at 11:42 am
I am assuming you are using the standard Express get the Advanced from the link below and you should get a decent Management Studio where you can see your code, with SP1 it also comes with a limited DTS. The main thing don't install the tool kit it is for the Calculus end and the way it is set up you cannot have both. Hope this helps.
http://msdn.microsoft.com/vstudio/express/sql/download/
Kind regards,
Gift Peddie
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply