Wanted to know list of connection to your SQL database?

Execute the following stored procedure
'sp_who2 active' into Query Analyser
It will return the information with status, login, cpu time, DB Name, Command etc.