January 17, 2011 at 3:03 am
Hello everyone,
I have the following error:
Could not find server 'Pippo' in sys.servers. Verify the correct server name was specified.
If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.server
I'm newbie in Sql server statement and actually I don'tk know to resolve this problem
Can anyone help me?
January 17, 2011 at 3:15 am
How are you trying to get the data?
Did you write a SQL statement yourself? Or are you using a stored procedure? If the latter, do you have access to the code of that sp?
My first guess is that you are using a four part name somewhere:
myServer.myDatabase.myTable.myColumn
Either myServer is unknown or you made a typo.
Or you could be using a linked server that is also unknown.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply