I am Shashank Srivastava currently working as a SQL DBA for a client that has one of the best database environment in the world. I have two years of experience and just wanted to learn and share through the blog. This blog is just to share my knowledge with all the people and learn from them.
I have completed Microsoft Certified Technology Specialist -MS SQL SERVER 2005 , Microsoft Certified Technology Specialist -MS SQL SERVER 2008 and ITIL v3 Certified IT professional certifications.
Tuesday, September 11, 2012
To find the port and IP address on which SQL Server is running. It works for SQL 2005/2008/200R2
local_net_address,local_tcp_port from sys.dm_exec_connections where
client_net_address != '<local machine>'