How can I see who is connected to my db?

Solution 1:

If I recall correctly in 2005 you can type this in a new query and then execute it:

exec sp_who
go

it will probably work in 2008.

Yes, it will: http://msdn.microsoft.com/en-us/library/ms174313.aspx

Solution 2:

You can use the Activity Monitor in SQL Server Management Studio. Once it's open look at the Processes section to see what is running, the login, database being used, and other helpful information.