SQLserver错误消息7312，级别 16，状态 1，第 1 行

Question

sqlserver 错误消息 7312sqlserverselectsql

Answer 1

試試以下：
SELECT [id]
      ,[centerno]
      ,[centername]
      ,[wireip]
      ,[wireport]
      ,[wireusing]
      ,[wirelessip]
      ,[wirelessport]
      ,[wirelessusing]
      ,[pri]
      ,[centertype]
      ,[setsendport]
      ,[wiresendport1]
      ,[wiresendport2]
      ,[wirelesssendport1]
      ,[wirelesssendport2]
  FROM [DB_DBIAdapter].[dbo].[t_center_def]

Answer 2

或者試試以下：
exec sp_addlinkedserver 'abc','','SQLOLEDB','10.32.225.24'
exec sp_addlinkedsrvlogin 'abc','false',null,'用戶名','密碼'SELECT [id]
      ,[centerno]
      ,[centername]
      ,[wireip]
      ,[wireport]
      ,[wireusing]
      ,[wirelessip]
      ,[wirelessport]
      ,[wirelessusing]
      ,[pri]
      ,[centertype]
      ,[setsendport]
      ,[wiresendport1]
      ,[wiresendport2]
      ,[wirelesssendport1]
      ,[wirelesssendport2]
  FROM [abc].[DB_DBIAdapter].[dbo].[t_center_def] 

Answer 3

本帖最后由 DBA_Huangzj 于 2014-08-22 08:27:57 编辑