Binaryworld - How to run Select, Insert, Delete statements aginst remote server usin ... [ SQL Server -> Distributed Queries ]

--example : usp_UpdateWorksheet 'tst1.intownsuites.com' --//fully qualified name of Remotemachine
--example : usp_UpdateWorksheet 'tst1' --//only machine name
--example : usp_UpdateWorksheet '<server_ip>'

Alter proc usp_UpdateWorksheet
@PropMCName as varchar(50)=NULL
as

declare @propid varchar(100)
declare @sid varchar(100)
declare @strstartdate varchar(100)
declare @strenddate varchar(100)

--set @propid='AIR'
--set @strStartDate='1/1/03'
--set @strendDate='6/1/03'

--//INSERT INTO OPENROWSET('...', 'SELECT field1, field2 FROM yourtable') VALUES (99, 'Test')

Exec('DELETE FROM OPENROWSET(''SQLOLEDB'',''' + @PropMCName + ''';''sa'';''remoteserverpwd'',
  ''SELECT * FROM NV.dbo.Worksheet'')
')

Exec('INSERT INTO
   OPENROWSET(''SQLOLEDB'',''' + @PropMCName + ''';''sa'';''remoteserverpwd'',''SELECT [wLockNumber], [wControlID], [wControlIndex], [wControlCaption], [wRequire], [wLeft], [wTop], [wHeight], [wWidth], [wTabStop], [wTabOrder] FROM NV.dbo.Worksheet'')
  SELECT   [wLockNumber], [wControlID], [wControlIndex], [wControlCaption], [wRequire], [wLeft], [wTop], [wHeight], [wWidth], [wTabStop], [wTabOrder] from test_worksheet
')

Print 'Updated.....' + left(@PropMCName,3)

go