Could not find server 'dbo' in sys.servers

sql-server-2008 stored-procedures subsonic
Lieven Cardoen picture Lieven Cardoen · Mar 20, 2009 · Viewed 61.2k times · Source

I have a lot of services which query the database. All of them work fine but one service calling a stored procedure gives me following error:

Could not find server 'dbo' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.

I have not idea why all the other stored procedures work fine and this one not...

By the way, I use SubSonic as data access layer.

Answer

prasad picture prasad · Apr 26, 2012

Please run select name from sys.servers from the server which you mentioned as default server in configuration file.

Here in name column values should match with your server names used in the report query.

e.g serverXXX.databasename.schema.tablename

serverXXX should be there in the result of select name from sys.servers otherwise it gives error as got.

Related questions

How do I find a stored procedure containing <text>?

I need to search a SQL server 2008 for stored procedures containing where maybe the name of a database field or variable name.

Read More
SQL Server Insert if not exists

I want to insert data into my table, but insert only data that doesn't already exist in my database. Here is my code: ALTER PROCEDURE [dbo].[EmailsRecebidosInsert] (@_DE nvarchar(50), @_ASSUNTO nvarchar(50), @_DATA nvarchar(30) ) AS BEGIN INSERT INTO EmailsRecebidos (De, Assunto, …

Read More
How to declare an array inside MS SQL Server Stored Procedure?

I need to declare 12 decimal variables, corresponding to each month's year, with a cursor I sum values to this variables, then later I Update some sales information. I don't know if sql server has this syntax Declare MonthsSale(1 to 12) as …

Read More