469,366 Members | 2,254 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,366 developers. It's quick & easy.

Linked Server Limit in SQL Server 2000

I am about to start working on a project where I would be required to
dynamically create linked servers during the execution of an
application. One of the requirements is for the Link Servers to be
created and dropped before and after the retrieval of the data. My
question is about any type of cap on the number of linked servers SQL
Server 2000 can have registered at any single time. If I find out that
there is some type of cap, I would need to look into another way to
deal with my linked server needs. Thanks for any help/information you
might be able to provide.

Jul 23 '05 #1
1 2119
TBlair (tb*********@yahoo.com) writes:
I am about to start working on a project where I would be required to
dynamically create linked servers during the execution of an
application. One of the requirements is for the Link Servers to be
created and dropped before and after the retrieval of the data. My
question is about any type of cap on the number of linked servers SQL
Server 2000 can have registered at any single time. If I find out that
there is some type of cap, I would need to look into another way to
deal with my linked server needs. Thanks for any help/information you
might be able to provide.


I have no idea whether there are any restriction, but since a linked
server is really just an alias which is being looked up in sysservers
at run time, it is not likely that there should be an issue.

But, hm, what is there is a numeric id in sysservers? Ah, there is,
and it's smallint. So that gives you an upper limit of 32767 linked
servers. Hm, if you add and remove servers constantly, could you still
run out of ids? I tested by dropping a server with id = 5 (I have 19
linked servers), and adding a new. The new server got id = 5, so gaps
are being filled.

Looks like you will be able to sleep well at night.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by David Gray | last post: by
5 posts views Thread by Ervs Sevilla via SQLMonster.com | last post: by
10 posts views Thread by Jim Devenish | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.