没什么好想的，但您不能做类似的事情

Nothing fancy but couldn't you do something like

DROP TABLE dbo.Merged

INSERT INTO dbo.Merged
SELECT  [DatabaseID] = "Database1", * FROM ServerA.dbo.Table
UNION ALL SELECT  [DatabaseID] = "Database2", * FROM ServerB.dbo.Table
...
UNION ALL SELECT  [DatabaseID] = "DatabaseX", * FROM ServerX.dbo.Table

优势

• 易于设置
• 易于维护
• 易于调整
• 易于添加更多表

缺点

• 性能
• 可靠的日志记录