July 14, 2005 at 9:32 pm
Hi,
To import data from server to my local machine i used a linked server query. it run fine.
But if i create a procedure using the linked query it doesnt import data from the server to my local machine.
can any one tell me why it is so.
from
doller
July 14, 2005 at 10:03 pm
You haven't said what syntax you are using and what error msg. you see...
here's another post that discussed the exact same issue - maybe it'll help:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=200830
**ASCII stupid question, get a stupid ANSI !!!**
July 15, 2005 at 1:26 am
HI,
I use this query
insert into dbo.inventsum select *
from [172.16.0.16].aicnav.dbo.INVENTSUM h
WHERE h.recid NOT IN
(SELECT d.recid
FROM dbo.INVENTsum d
)
there is not error when i execute the procedure but from the procedure data is not transfered.
from
doller
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply