<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss Content Posted by Unknown Unknown
»
Protocols
14 posts, Page 1 of 2
1
2
»»
Protocols
Rate Topic
Display Mode
Topic Options
Author
Message
Site Owners
Site Owners
Posted Thursday, December 27, 2007 8:39 PM
SSChampion
Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040,
Visits: 1
Comments posted to this topic are about the item
Protocols
Post #436879
Kevin Brennan
Kevin Brennan
Posted Friday, December 28, 2007 4:00 AM
SSC Journeyman
Group: General Forum Members
Last Login: Wednesday, September 05, 2012 9:16 AM
Points: 77,
Visits: 248
I think that it would be impossable to get this question correct ( unless you chose the incorrect series)as it does not give you the option to select Local named pipes as opposed to (generic) named pipes which includes both local and network connection type
Of course named pipes is disabled for network connections
Kevin Brennan M.Sc, MCITP, MCDBA, MCSE, MCTS,MCP+I
Post #436975
William Vach
William Vach
Posted Friday, December 28, 2007 5:29 AM
SSCrazy
Group: General Forum Members
Last Login: 2 days ago @ 9:09 AM
Points: 2,114,
Visits: 1,073
According to SQL Server Books online, named pipes are enabled for Local connections. This should have been specified in the list of protocol types.
Post #437004
jlsmith-543348
jlsmith-543348
Posted Friday, December 28, 2007 7:15 AM
Valued Member
Group: General Forum Members
Last Login: Tuesday, August 16, 2011 5:47 AM
Points: 68,
Visits: 36
This isnt a fair question, named pipes is enabled locally, but tecnically enabled, if you look at the develper center, it in facts states enabled:
http://msdn2.microsoft.com/en-us/library/ms190198.aspx
Post #437036
SanjayAttray
SanjayAttray
Posted Friday, December 28, 2007 8:29 AM
Hall of Fame
Group: General Forum Members
Last Login: Friday, March 15, 2013 2:43 PM
Points: 3,924,
Visits: 1,554
Shared memory - TSQL LocalMachine
Named Pipes - TSQL Named Pipes
TCP/IP - TSQL Default TCP
VIA - TSQL Default VIA
DAC - Dedicated Admin Connection
SQL DBA.
Post #437080
James_DBA
James_DBA
Posted Friday, December 28, 2007 8:35 AM
SSC-Addicted
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 2:20 PM
Points: 464,
Visits: 8,717
I gotta say that I agree with everyone else on this one; the question was a bit of a tricky question in that "Named Pipes" is technically enabled, even if it is only for local connections.
It would've been nice to have an option (or two, to throw us off) with selecting a protocol as being enabled with local connections only.
What a way to end the year!....
Happy New Years all!
James
~ Without obstacles, you cannot progress ~
http://sqln.blogspot.com/
Post #437084
brewmanz
brewmanz
Posted Friday, December 28, 2007 2:41 PM
SSC-Addicted
Group: General Forum Members
Last Login: Tuesday, December 04, 2012 11:16 AM
Points: 477,
Visits: 389
Once again, the question poser asks one question ("which protocols are enabled") and gives a wrong answer, by using a definitive statement that answers a DIFFERENT issue (about "Network Protocols"). Network? When did that word slip into the question? Who limited things to NETWORK protocols?
Obviously(?) named pipes are only local with the default installation, but that IS a protocol. Okay, it's not a NETWORK protocol, but that wasn't the question, was it?
It's bad enough getting a wrong answer when I've got it wrong; it's downright exasperating when the 'right' answer is demonstrably wrong!
Doesn't anybody check that the question poser knows what they're talking about?
Post #437244
bitbucket-25253
bitbucket-25253
Posted Sunday, December 30, 2007 10:16 AM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 5,103,
Visits: 20,220
Agree with the fact that the question is not properly phrased for what it considered the correct answer.
NOW WILL SOME ONE BE NICE AND TAKE THE FLAG OFF OUR RECORDS INDICATING THAT WE DID NOT ANSWER THE QUESTION CORRCTLY
If everything seems to be going well, you have obviously overlooked something.
Ron
Please help us, help you -before posting a question please
read
Before posting a performance problem please
read
Post #437386
Steve Jones - SSC Editor
Steve Jones - SSC Editor
Posted Sunday, December 30, 2007 11:11 AM
SSC-Dedicated
Group: Administrators
Last Login: Yesterday @ 11:20 AM
Points: 31,437,
Visits: 13,752
All answers have been marked correct.
Follow me on Twitter:
@way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
Post #437389
bitbucket-25253
bitbucket-25253
Posted Sunday, December 30, 2007 1:57 PM
SSCertifiable
Group: General Forum Members
Last Login: Yesterday @ 12:39 PM
Points: 5,103,
Visits: 20,220
Steve Jones - Editor (12/30/2007)
All answers have been marked correct.
More than I expected, and more than we deserve, no matter let me say thank you.
Now what are you doing working on a Sunday?
If everything seems to be going well, you have obviously overlooked something.
Ron
Please help us, help you -before posting a question please
read
Before posting a performance problem please
read
Post #437402
« Prev Topic
|
Next Topic »
14 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
