>-----Original Message-----
>-- I connect to server with:
>exec sp_addlinkedserver '172.30.170.16'
>go
>exec sp_addlinkedsrvlogin '172.30.170.16', 'false',
>NULL, 'sa', 'password'
>-- Select statments like below work fine:
>select * from [172.30.170.16].db_dibrs.dbo.rmt_db_table
>-- HOWEVER, the following statements generate errors:
>insert into [172.30.170.16].db_dibrs.dbo.rmt_db_table
>select * from local_table
>
>Server: Msg 7344, Level 16, State 1, Line 1
>OLE DB provider 'SQLOLEDB' could not INSERT INTO
>table '[]' because of column 'rmt_col'. The user did not
>have permission to write to the column.
>[OLE/DB provider returned message: Errors occurred]
>.