--Step 1: exec sp_configure 'show advanced options',1 reconfigure exec sp_configure 'Ad Hoc Distributed Queries',1 reconfigure --Step 2:INSERT INTO [***].[dbo].[Gen_Product] ([Insure_ID] ,[ProductType] ,[SubType] ,[MaxDay] ,[Prefix] ,[BasicInd]) select [Insure_ID] ,[ProductType] ,[SubType] ,[MaxDay] ,[Prefix] ,[BasicInd] from OPENDATASOURCE('SQLOLEDB','Data Source=192.168.203.110;User ID=sa;Password=123').[123_DEV].dbo.[Gen_Product]GO