How can I find which port a SQL Server 2005 Instance is listening on?

Sometimes it is useful to know which port a particular instance of SQL Server is running on, especially if you are using the default behavior where the SQL Browser automatically allocates a port to an instance. Now you can find out easily using the new dynamic management views that are provided within the SQL Server 2005 environment.

Here is a simple script which shows you where you can look