Re: xml bulk load problem

anonymous_at_discussions.microsoft.com
Date: 04/20/04


Date: Tue, 20 Apr 2004 12:35:46 -0700

I have tried both transactional and non transactional
mode . I get the same error each time ie create table
permission denied ( as i dont have table creation
permission on the database)

>-----Original Message-----
>What options are set on Bulkload? Can you try in
transctional mode?
>
>Thanks,
>Irwin
>
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>"Mathew" <anonymous@discussions.microsoft.com> wrote in
message
>news:1adb01c426f0$0cb2d6b0$a301280a@phx.gbl...
>> HI
>>
>> I am trying to load xml data into 2 related tables using
>> sqlxmlbulkload component . the tables already exists.
THe
>> problem i am running into is that some intermediate
tables
>> are being created and dropped during the proess. i ran
the
>> profiler and found that it is creating intermediate
>> tables during the load process. I dont have a table
>> creation permission in the prod database. Pls tell me
>> whether a work around is possible or whether data load
is
>> not possible if you dont have create and drop table
>> permissions
>> Any help is much appreciated
>
>
>.
>



Relevant Pages

  • Re: SBS 2003 XP Client SP2 add new user with user rights cant use
    ... This will work im sure just tried similar setup seamed ok - What I dont ... loacal admin privileges even though she was assigned USER privilages from the ... Sometimes you need to contact the app vendor ... >> permission to open database file - Its something to do with not having ...
    (microsoft.public.windows.server.sbs)
  • Re: Cannot open a Attachment in Entorage
    ... you dont have the permission or the File ist alredy open" ... I can see pictures in the Preview Window, but dont open them with a double Klick. ... Go into the /Applications/Utilities folder and double-click the Disk Utility to open it. ... Entourage Help Blog ...
    (microsoft.public.mac.office.entourage)
  • exchange 5.5 to exchange 2003 migration
    ... says I dont have permission to view hidden objects, so returned info may be ...
    (microsoft.public.exchange.setup)
  • Re: All permissions all access ! .NET drives me crazy
    ... Demanddoes not grant you the permission. ... to execute, ... > If I ran the app locally, ... > I dont want to use client app like caspol.exe or mscorcfg.msc...(because I ...
    (microsoft.public.dotnet.security)
  • Re: Help with my perl script
    ... install_driverfailed: Can't load ... Perhaps a required shared library or dll isn't installed where expected ... permission 0755 ... and i dont find nothing to help me... ...
    (perl.dbi.users)