Use of sp_addlinkedserver

[StevenK]

I am able to link one SQL server to another using the sp_addlinkedserver command.
This creates an additional entry in the 'sysservers' table. Does the entry associated with the currently connected server always maintain the ID value of 0 (with added servers having their ID's incremented accordingly) ?
Thanks in advance.
Steve

 

[TomSark]

You cannot create a local server as a linked server, therefore, the server id will always be non-zero because you always start at 1 for a remote server id and increment from there, and yes, it will incremented like an identity (but it isn't one). Tom Davis
tdavis@sark.com

http://www.sarkdallas.com