Viewing 2 posts - 1 through 2 (of 2 total)
Good thought Zubeyir, I'll make sure that the account that SQL Server is running on has privledges on both servers and try that.
July 23, 2006 at 5:19 pm
#650957
I am having exactly the same issue:
INSERT INTO Xml_Docs_Storage
SELECT 'jmi060630170504ff2_8310', xml_doc
FROM (SELECT * FROM OPENROWSET
(BULK '\\servepath\xmldoc.xml',
...
July 14, 2006 at 3:38 pm
#649385