Activity monitor in SQL server 2008

How to check open database connection in SQL server:

1. Open Management Studio.
2. On the standard toolbar is a little graph icon. That is the Activity Monitor (CTRL + ALT + A).
3. Click on Processes

 You can view the processes which hold the database connections.