July 14, 2011 at 4:10 am
HOW TO update/delete record in sql server 2000 from sql server 2008 USING LINK SERVER...
July 14, 2011 at 4:29 am
This thread should point you to the right direction:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 14, 2011 at 6:06 am
thaks yar but i can't delete any record or updated.. when i try i got error
"Server: Msg 16955, Level 16, State 2, Line 1
Could not create an acceptable cursor.
OLE DB provider "SQLNCLI10" for linked server "linkservername" returned message "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
July 14, 2011 at 6:42 am
Is it possible to post the query?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 14, 2011 at 6:45 am
delete from [192.21.10.34].test_DB.dbo.emp_check1 where eid in (select eid from emp_check_loc where eid=12345)
but i have using linkserver from sql server 2008 64 bit to sql server 2000 32 bit
July 14, 2011 at 6:58 am
Coolroof (7/14/2011)
delete from [192.21.10.34].test_DB.dbo.emp_check1 where eid in (select eid from emp_check_loc where eid=12345)
Maybe I'm missing something, but isn't your query the same as saying:
delete from [192.21.10.34].test_DB.dbo.emp_check1 where eid = 12345
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 14, 2011 at 7:00 am
ITS RIGHTS..THIS IS MY QUERY
July 14, 2011 at 7:11 am
Coolroof (7/14/2011)
ITS RIGHTS..THIS IS MY QUERY
And this is you solving your problem on your own...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 14, 2011 at 7:12 am
I THINK U MISUNDERSTAND NO PROBS
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply