On linux you can use "lsof -i" to see all current connections, I used to use something similar on >>Windows, but can't remember what it was.
The tool you're looking for is called fport, and is distributed for free by Foundstone. It lists which program is using each open port. Alternatively you can just use netstat -an to just see which ports are actively communicating or listening, but it won't show you which program is using that port.
Matt
_________________________________________________________________
Is your PC infected? Get a FREE online computer virus scan from McAfee® Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
