How to kill active connections in SQL Management Studio

To kill active connections in SQL Management Studio 2008 do this:

1. Right-click the server in Object Explorer and select 'Activity Monitor'.
2. When it opens, expand the Processes group.
3. Now use the drop-down to filter the results by database name.
4. Kill off the server connections by selecting the right-click 'Kill Process' option.

If you are using SQL Management Studio 2005 it's a good advice to upgrade management studio to 2008 as it works with latest MSSQL2005 server updates.

Remote connection to MSSQL server on a specific port

If you use specific port (not 1433 by default) for MSSQL server remote connections, then when you want to connect trough SQL Server Management you must specify the new port in server name with comma, e.g.:

Server name: www.yourserver.com,3281