Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
How OPENQUERY update and delete tables on linked server.
600 views
Skip to first unread message
openquery
Jul 5, 2006, 3:02:01 AM7/5/06
to
Hi,
How I can update and delete tables (T-SQL) on linked server with OPENQUERY
or another way?
I catch error :
Server: Msg 7333, Level 16, State 2, Line 1
Could not fetch a row using a bookmark from OLE DB provider 'SQLOLEDB'.
How I can update and delete tables (T-SQL) on linked server with OPENQUERY
or another way?
I catch error :
Server: Msg 7333, Level 16, State 2, Line 1
Could not fetch a row using a bookmark from OLE DB provider 'SQLOLEDB'.
Uri Dimant
Jul 5, 2006, 3:08:58 AM7/5/06
to
Hi
UPDATE OPENQUERY(Server, 'SELECT col1, col3 FROM tbl..')
SET col1 = @param1
WHERE col2 = param2
UPDATE OPENQUERY(Server, 'SELECT col1, col3 FROM tbl..')
SET col1 = @param1
WHERE col2 = param2
"openquery" <open...@discussions.microsoft.com> wrote in message
news:FAFCB222-F98E-427A...@microsoft.com...
openquery
Jul 5, 2006, 3:22:01 AM7/5/06
to
I want update multi records of table on linked server by join with another
table on local server.
I catch thid error :
Server: Msg 7333, Level 16, State 2, Line 1
Could not fetch a row using a bookmark from OLE DB provider 'SQLOLEDB'.
table on local server.
I catch thid error :
Server: Msg 7333, Level 16, State 2, Line 1
Could not fetch a row using a bookmark from OLE DB provider 'SQLOLEDB'.
Uri Dimant
Jul 5, 2006, 3:31:35 AM7/5/06
to
Take a look at this
http://www.mcse.ms/archive81-2005-8-1821061.html
http://www.mcse.ms/archive81-2005-8-1821061.html
"openquery" <open...@discussions.microsoft.com> wrote in message
news:64F35894-F6E3-42DE...@microsoft.com...
oj
Jul 7, 2006, 2:20:36 AM7/7/06
to
Create a unique index or a primary key on the remote table and you're set.
Basically, sqlserver needs a key to locate the row in the remote table to
join/compare.
Basically, sqlserver needs a key to locate the row in the remote table to
join/compare.
--
-oj
"openquery" <open...@discussions.microsoft.com> wrote in message
news:64F35894-F6E3-42DE...@microsoft.com...
0 new messages