<div>
Can you post the SP you are trying to add?
</div>


Can you post the SP you are trying to add?

<div>
what does sp_addlinkedserver does?<br />
<br />

</div>


<div>
you tried looking in the BOL?<br />
<br />
Creates a linked server, which allows access to distributed, heterogeneous queries against OLE DB data sources. After creating a linked server with sp_addlinkedserver, this server can then execute distributed queries. If the linked server is defined as Microsoft® SQL Server™, remote stored procedures can be executed.<br />
<br />
etc... Have a read
</div>


you tried looking in the BOL?

Creates a linked server, which allows access to distributed, heterogeneous queries against OLE DB data sources. After creating a linked server with sp_addlinkedserver, this server can then execute distributed queries. If the linked server is defined as Microsoft® SQL Server™, remote stored procedures can be executed.

etc... Have a read

<div>
Can you post the SQL for the SP that is throwing this error? &nbsp;Are you actually trying to get data from another SQL Server / Oracle / Access / Text File / Excel etc..??<br />
<br />
Dave
</div>


Can you post the SQL for the SP that is throwing this error?  Are you actually trying to get data from another SQL Server / Oracle / Access / Text File / Excel etc..??

Dave

<div>
And how do I link a server?<br />
<br />
Is it just sp_addlinkedserver 'servername' <br />
<br />
?
</div>


And how do I link a server?

Is it just sp_addlinkedserver 'servername'

?

<div>
<a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_8gqa.asp" rel="ugc">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_8gqa.asp</a>
</div>


http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_8gqa.asp [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_adda_8gqa.asp]

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am trying to create a Stored Procedure but it gives me an error <br />
&quot;Could not find &quot;ABCSERVER&quot; in sysservers. Execute sp_addlinkserver to add the server to sysservers&quot;<br />
<br />
How do I add this?<br />
<br />
Thanks<br />

</div>
</div>


Hi,

I am trying to create a Stored Procedure but it gives me an error 
"Could not find "ABCSERVER" in sysservers. Execute sp_addlinkserver to add the server to sysservers"

How do I add this?

Thanks


sysservers

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.