[CODE]remote svr.에서 create table aaaa ( col1 int identity ) local svr. 에서 insert into remote.pubs.dbo.aaaa (col1) values (0) [/CODE]
위를 실행하면 다음과 같은 OLEDB에러를 낸다.
OLE DB provider 'SQLOLEDB' could not INSERT INTO table '[remote].[pubs].[dbo].[aaaaa]' because of column 'col1'. The user did not have permission to write to the column.
[OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IRowsetChange::InsertRow returned 0x80040e21: Data status sent to the provider:
(이하 생략)
[OLE/DB provider returned message: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.]
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IRowsetChange::InsertRow returned 0x80040e21: Data status sent to the provider:
(이하 생략)
linked server 는 역시 조심해서 사용해야 함.
Posted by maceo
