Microsoft KB Archive/928964: Difference between revisions

From BetaArchive Wiki
(importing KB archive)
 
m (Text replacement - "<" to "<")
Line 52: Line 52:


To work around this problem, create a linked server on the design database. The design database is a local instance of Microsoft SQL Server that is used to perform design-time validation of the database project. To create a linked server, run the following command:
To work around this problem, create a linked server on the design database. The design database is a local instance of Microsoft SQL Server that is used to perform design-time validation of the database project. To create a linked server, run the following command:
<pre class="codesample">exec sp_addlinkedserver '&lt;ServerName&gt;', 'sql server'</pre>
<pre class="codesample">exec sp_addlinkedserver '<ServerName&gt;', 'sql server'</pre>
After you run this command, you do not receive this error message. However, the warning remains because the linked server is not supported in Visual Studio 2005 Team Edition for Database Professionals. You can still build, validate, and deploy the rest of the project.
After you run this command, you do not receive this error message. However, the warning remains because the linked server is not supported in Visual Studio 2005 Team Edition for Database Professionals. You can still build, validate, and deploy the rest of the project.



Revision as of 08:32, 21 July 2020

Knowledge Base


Error message when you try to import an object schema that references a linked server in Visual Studio 2005 Team Edition for Database Professionals: "Could not find server 'ServerName' in sysservers. Execute sp_addlinkedserver to add the server to sysserv

Article ID: 928964

Article Last Modified on 12/13/2006



APPLIES TO

  • Microsoft Visual Studio 2005 Team Edition for Database Professionals



SYMPTOMS

When you try to import an object schema that references a linked server in Microsoft Visual Studio 2005 Team Edition for Database Professionals, you may receive an error message that resembles the following:

Could not find server 'ServerName' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

WORKAROUND

To work around this problem, create a linked server on the design database. The design database is a local instance of Microsoft SQL Server that is used to perform design-time validation of the database project. To create a linked server, run the following command:

exec sp_addlinkedserver '<ServerName>', 'sql server'

After you run this command, you do not receive this error message. However, the warning remains because the linked server is not supported in Visual Studio 2005 Team Edition for Database Professionals. You can still build, validate, and deploy the rest of the project.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Keywords: kbtshoot kbprb KB928964