Accessing MS-SQL Process Info

  • Thread starter Thread starter Morten Snedker
  • Start date Start date
M

Morten Snedker

In MS-SQLEM -> Management -> Current Activity you can see active
connections. Are these accessible through ADO.NET?

At a given time I wish to kill all processes to a certain database -
and just wondered if it is possible through ADO?

Thanks for advice and time spent.


Regards /Morten
 
Morten said:
In MS-SQLEM -> Management -> Current Activity you can see active
connections. Are these accessible through ADO.NET?

At a given time I wish to kill all processes to a certain database -
and just wondered if it is possible through ADO?

Thanks for advice and time spent.
Click to expand...

Check in Books online the topic: "Monitoring with SQL Server
Enterprise Manager"

In there you'll find Transact SQL examples how to monitor various
aspects of the sqlserver system. You can then execute these using
ADO.NET.

Frans

--
 
Back
Top