执行过没有?sp_configure 'show advanced options', 1
GO
RECONFIGURE
GO
sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO
GO
RECONFIGURE
GO
sp_configure 'Ad Hoc Distributed Queries', 1
GO
RECONFIGURE
GO
insert into 服务器B.testdb.dbo.testdb([dbname],[TSQLCommand],[PostTime],[LoginName],[hostname])
values(@dbname,@Tsql,@PostTime,@LoginName,@hostname)改成这样试试:insert into 服务器B.testdb.dbo.testdb([dbname],[TSQLCommand],[PostTime],[LoginName],[hostname])
select [dbname],[TSQLCommand],[PostTime],[LoginName],[hostname]
from inserted