Could not find server "DB" name in sys.servers (no dbo problem)

Question

Today I ran into a problem saying that my "server" was not found in sys.servers. Error:

Could not find server 'DB name' in sys.servers

This is not a problem using a prefix in some cases, but not others, as with the "dbo" problems that others have.

Answer 1

There are many situations where you can get this error, and many of them are covered by StackOverflow. However, one case that may especially occur on shared servers is simply that the database name has a period (period) in it. For example, if his name mysite.com_DB. This will automatically cause a problem.

, , , , :

mysite.com_DB.Table_name

:

[mysite.com_DB].Table_name

Answer 2

, , . (sp_addlinkedserver)

, , .    * sys.sysservers