Bulk load xml file

DECLARE @xml XML;


--Use OPENROWSET to read an XML file from the file system


SELECT @xml = BulkColumn


FROM OPENROWSET(BULK 'c\test072808.xml', SINGLE_BLOB) TempXML


--View the result


SELECT @xml


Tried to use the above and received the following message.


Msg 4834, Level 16, State 1, Line 8


You do not have permission to use the bulk load statement.


New at this. Any help appreciated. Thanks

 

Hi,
Open a Support ticket from your Control Panel.

I'll take a guess and mention that this can not be allowed on a shared server for security reasons.
Salute,
Mark