Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

How many system endpoints are available in SQL Server 2005? Expand / Collapse
Author
Message
Posted Monday, July 26, 2010 10:10 PM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 9:21 AM
Points: 889, Visits: 1,453
Comments posted to this topic are about the item How many system endpoints are available in SQL Server 2005?

Thanks.
Post #959174
Posted Tuesday, July 27, 2010 1:52 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Thursday, October 16, 2014 1:30 AM
Points: 862, Visits: 1,558
Thank you for the question. I tossed my 5-sided coin and got the right answer, then read up on endpoints.

http://www.simple-talk.com/sql/database-administration/sql-server-endpoints-soup-to-nuts/ gives a good description of endpoints.
Post #959232
Posted Tuesday, July 27, 2010 3:46 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, July 9, 2013 11:12 PM
Points: 1,263, Visits: 1,081
Apparently trusted the wrong reference on MSDN:

http://msdn.microsoft.com/en-us/library/ms191220(SQL.90).aspx

as this gives a list of 6 automatically created endpoints...

Thanks for the question and for teaching me to doubt any of the Microsoft online resources any time.
Post #959275
Posted Tuesday, July 27, 2010 6:25 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 10:26 AM
Points: 634, Visits: 1,540
I had never heard of endpoints, but apparently my BOL reference was better than Michael's :) I did get it correct.

http://blogs.msdn.com/b/sql_protocols/archive/2005/10/14/480842.aspx

Thanks for question - learned something new today.

Cindy
Post #959326
Posted Tuesday, July 27, 2010 6:36 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 2:36 PM
Points: 2,818, Visits: 2,565
I love questions that make me do a little reading to brush up on weak areas. Thanks.
Post #959335
Posted Tuesday, July 27, 2010 9:07 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 2:04 PM
Points: 17,811, Visits: 15,735
Nice question. No idea why this stuck in my head without review or research.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #959468
Posted Tuesday, July 27, 2010 9:09 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 9:21 AM
Points: 889, Visits: 1,453
Thanks Jason...! Actually, I was configuring a "Database Mirroring" once, so thought to post the question to the Group! :)

Thanks.
Post #959471
Posted Tuesday, July 27, 2010 10:21 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, September 5, 2014 2:00 PM
Points: 2,160, Visits: 2,191
Thanks for the question, though I find it interesting that BOL has conflicting information.
Post #959818
Posted Wednesday, July 28, 2010 2:25 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 23, 2012 1:46 PM
Points: 23, Visits: 21
Thanks for the question ... I read up a little about endpoints from Microsoft's site and came across only the Dedicated Admin Endpoint that is created automatically. I selected 1 as the answer, and you can bet I was wrong!

I should have read till the end of the article before answering the question
Post #959888
Posted Thursday, July 29, 2010 9:39 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 11:02 AM
Points: 20,734, Visits: 32,497
I'll disagree and say 6:

Shared Memory
Named Pipes
TCP/IP
VIA
DAC
HTTP




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #960818
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse