SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Single hop vs Double hop
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Peace2007
Posting Yak Master

239 Posts

Posted - 10/22/2008 :  03:28:12  Show Profile  Reply with Quote
Could anyone explain the difference between single hop and double hop?

SwePeso
Patron Saint of Lost Yaks

Sweden
30114 Posts

Posted - 10/22/2008 :  03:44:19  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Single hop is jumping on one leg, and double hop is jumping in two legs.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

Peace2007
Posting Yak Master

239 Posts

Posted - 10/22/2008 :  03:53:32  Show Profile  Reply with Quote
Thanks for the reply Peso but could you please explain more? :)
So far as I know, double hop is when a client wants to read data from a server through another server. And I know that single hop is also involved with a client and two servers (http://sql-articles.com/index.php?page=articles/linked_server_part2.html) but can't understand the difference.
Go to Top of Page

afrika
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 10/22/2008 :  04:07:00  Show Profile  Reply with Quote
quote:
Originally posted by Peso

Single hop is jumping on one leg, and double hop is jumping in two legs.



E 12°55'05.63"
N 56°04'39.26"




Well, I agree fully with Peso. As thats what we were taught as kids

However, in TCP/IP networking. When you send a message, ie from your browse to a website ie sqlteam. It goes through your ISP, whose router uses the shortest gateway to get to its destination. Each gateway is a hop, and the total number of gateways is known as the hop count.

To see how many hop counts, go to command prompt and type tracert "your destination"

e.g. tracert www.sqlteam.com

Go to Top of Page

afrika
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 10/22/2008 :  04:09:15  Show Profile  Reply with Quote
But if in doubt, refer to Peso's definition. As more people believe in the earlier defnition
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30114 Posts

Posted - 10/22/2008 :  04:24:39  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Oh, you mean hop in network context.
I am so sorry I wasn't aware of that.



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page

Peace2007
Posting Yak Master

239 Posts

Posted - 10/22/2008 :  04:27:10  Show Profile  Reply with Quote
Thx Afrika
would you tell me the difference between row 3 and row 6 of the table in article: (http://sql-articles.com/index.php?page=articles/linked_server_part2.html) to more clarify me about that?

Edited by - Peace2007 on 10/22/2008 04:27:44
Go to Top of Page

Peace2007
Posting Yak Master

239 Posts

Posted - 10/22/2008 :  04:43:12  Show Profile  Reply with Quote
No problem Peso :) every comment opens a door to a new world to me
Now I got that hop in network context differs from SQL context. Is that true?
Go to Top of Page

afrika
Flowing Fount of Yak Knowledge

Nigeria
2706 Posts

Posted - 10/22/2008 :  05:44:00  Show Profile  Reply with Quote
quote:
Originally posted by Peace2007

Thx Afrika
would you tell me the difference between row 3 and row 6 of the table in article: (http://sql-articles.com/index.php?page=articles/linked_server_part2.html) to more clarify me about that?



Double ? single ? Honestly, I dont know
Go to Top of Page

Peace2007
Posting Yak Master

239 Posts

Posted - 10/22/2008 :  05:52:01  Show Profile  Reply with Quote
quote:
Originally posted by afrika

quote:
Originally posted by Peace2007

Thx Afrika
would you tell me the difference between row 3 and row 6 of the table in article: (http://sql-articles.com/index.php?page=articles/linked_server_part2.html) to more clarify me about that?



Double ? single ? Honestly, I dont know



Thx anyway
Here's an article, in which I think I came to an answer:
http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx
Go to Top of Page

Arnold Fribble
Yak-finder General

United Kingdom
1961 Posts

Posted - 10/22/2008 :  08:55:17  Show Profile  Reply with Quote
quote:
Originally posted by Peace2007

Here's an article, in which I think I came to an answer:
http://blogs.msdn.com/sql_protocols/archive/2006/08/10/694657.aspx



What an excellent explanation of why no-one ever gets this working!
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30114 Posts

Posted - 10/22/2008 :  10:26:36  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Oh, the original question was about authentication?



E 12°55'05.63"
N 56°04'39.26"
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000