服务器 消息 208,在MSSQL2000里边 对象名 'sys.servers' 无效 服务器: 消息 208，级别 16，状态 1，行 1...

在MSSQL2000里面 对象名 'sys.servers' 无效 服务器: 消息 208，级别 16，状态 1，行 1

在MSSQL2000里面不支持该  sys.servers查看链接服务器信息

SELECT * FROM  sys.servers

后面查看sys.[sp_helpserver里面的

USE [master]

GO

/****** Object: StoredProcedure [sys].[sp_helpserver] Script Date: 2014/2/17 9:54:31 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER procedure [sys].[sp_helpserver]

@server sysname = NULL, -- server name

@optname varchar(35) = NULL, -- option name to limit results

@show_topology varchar(1) = NULL -- 't' to show topology coordinates

as

-- PRELIMINARY

set nocount on

declare @optbit int,

@bitdesc sysname,

@curbit int

-- CHECK IF REQUESTED SERVER(S) EXIST

if not exists select * from master.dbo.sysservers where

(@server is null or srvname = @server))

begin

if @server is null

raiserror(15205,-1,-1)

else

raiserror(15015,-1,-1,@server)

return (1)

end

-- GET THE BIT VALUE(S) FOR THE OPTION REQUESTED

if @optname is not null

begin

select @optbit = number from master.dbo.spt_values

where type = 'A' and name = @optname

if @optbit is null

begin

raiserror(15206,-1,-1,@optname)

return(1)

end

end

else

select @optbit = -1 -- 0xffffffff

-- MAKE WORK COPY OF RELEVANT PART OF SYSSERVERS

select name = srvname, network = srvnetname, status = convert(varchar(100), ''),

id = srvid, srvstat = srvstatus, topx = topologyx, topy = topologyy,

collation_name = convert(sysname, CollationPropertyFromID(srvcollation, 'name')),

connect_timeout = connecttimeout, query_timeout = querytimeout

into #spt_server

from master.dbo.sysservers

where (@server is null or srvname = @server) and (@optname is null or srvstatus & @optbit <> 0)

-- SET THE STATUS FIELD

select @curbit = 1

while @curbit < 0x10000 -- bit field is a smallint

begin

select @bitdesc = null

select @bitdesc = name from master.dbo.spt_values

where type = 'A' and number = @curbit

if @bitdesc is not null

update #spt_server set status = status + ',' + @bitdesc where srvstat & @curbit <> 0

select @curbit = @curbit * 2

end

-- SHOW THE RESULT SET

if lower(@show_topology) <> 't' or @show_topology is null

select name, network_name = network,

status = isnull(substring(status,2,8000),''),

id = convert(char(4), id),

collation_name, connect_timeout, query_timeout

from #spt_server order by name

else

select name, network_name = network,

status = isnull(substring(status,2,8000),''),

id = convert(char(4), id),

collation_name, connect_timeout, query_timeout,

topx, topy

from #spt_server order by name

-- RETURN SUCCESS

return(0) -- sp_helpserver

发现

select * from master.dbo.sysservers，在sql2000里面是sysservers，而且mssql2008里面是sys.servers