Your company's ad could live here and reach over 50,000 people a month!

Share This Post

SQL Query To Retrieve SQL Server TCP EndPoint Information

The SQL Query here will allow you to retrieve information from your SQL Server installation pertaining to your TCP Endpoints.

SQL Query:


Name ‘Endpoint Name’,

‘Protocol’ = Case

When Protocol = 1 Then ‘HTTP’

When Protocol = 2 Then ‘TCP’

When Protocol = 3 Then ‘Name Pipes’

When Protocol = 4 Then ‘Shared memory’

When Protocol = 5 Then ‘Virtual Interface Adapter’



‘Type’ = Case

When Type = 1 Then ‘SOAP’

When Type = 2 Then ‘TSQL’

When Type = 3 Then ‘Service Broker’

When Type = 4 Then ‘Database Mirroring’


‘State’ = Case

When State = 1 Then ‘Stopped’

When State = 2 Then ‘Disabled’

Else ‘Started’


‘Administrative Endpoint’ = Case

When Is_Admin_Endpoint = 0 Then ‘No’

When Is_Admin_Endpoint = 1 Then ‘Yes’



From Sys.TCP_Endpoints

Share This Post

Don Hite began writing as a columnist for Rod Trent on SWYNK.Com (Now Enterpriseitplanet.Com) in the winter of 1999. In January of 2002 he co-founded the Kansas City Regional Systems Management Users Group (KCRSMUG) along with Janis Keim. Don is the eldest of four children and was born in the Army hospital at Wurzburg Germany in November of 1957. After living in Bad Kissingen Germany for the first few years of his life the Hite family moved back to the United States after his father retired from the army when Don was still in kaki army diapers. Educated by trade as a commercial master electrician Don made the career change from terminating Copper Conductor cable to terminating Ethernet cable in the early 1990’s. Don is married and lives on a farm in rural Kingsville Missouri with his wife Virginia (Ginny) and has a Son Lee, Stepdaughter Lisa and an 11 year old grandson named Blake.

Leave a Reply