procedure

Question

procedure

eboucicaut

Old Hand

Points: 322
More actions
August 13, 2012 at 9:17 am

#104165

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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

You're referencing a linked server that doesn't exist. Either modify your code and fix the linked server reference or add the linked server.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Lowell SSC Guru Points: 323518 More actions · Answer 2

well the error implies you used a four part naming convention to reference a table/stored proc/view.

something like

SELECT * FROM SGEXP01.DatabaseName.dbo.TableName.

if SGEXP01 is a database name, then you have a syntax issue in your query.

if it really is a server name, you ahve to add a linked server.

books online can help, but if it is a SQL server, the syntax is REALLY simple:

this example is adding a linked server to a named isntance:

EXEC master.dbo.sp_addlinkedserver @server = N'MyLinkedServer', @provider=N'SQLNCLI', @datasrc=N'D223\SQLEXPRESS'

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!