by We are using SQL Server 7 EE sp3 on Windows NT 4.0 EE sp6a. We do a lot of
work with linked servers for data synchronization. We started getting the
following error a while back after applying sp2.
Limit exceeded for number of servers..
Error: 15430, Severity: 19, State: 1
I am not sure what this error means and we only get it occasionally. I
assume that it means there is some limit to the number of linked servers but
I have not been able to reproduce the problem. I have added up to 1000
linked servers (all pointing to the same actual machine) and run a query
against without any problems. 1000 far exceeds the number of linked servers
we ever seen at one time during normal operation. I can't find any
information about this error in BOL or MS KB. Can anyone provide some more
information? Thanks
Michael Carroll