SQL server 2008 r2 - linked server limitation

Question

Hi,

is there a limited number of linked server you can configure on a MSSQL SERVER 2008 R2?

thanks in advance,

A

Answer 1

Hello,

How many do you plan to add?

Everything is limited, I think here it's limited by the count of objects SQL Server can handle = 2,147,483,647

---

Olaf Helper
* cogito ergo sum * errare humanum est * quote erat demonstrandum *
Wenn ich denke, ist das ein Fehler und das beweise ich täglich
Blog Xing

Answer 2

about a hundred +..
if that is the case than i guess i can stay calm :_)
thank you for the quick response