Post reply

problem in bulk insert in SQL 2005

  • December 19, 2006 at 3:53 am

    #175298

         I've written a code as:

       

          bulk insert checkdata from 'E:\hi.txt'

         with

    (ROWTERMINATOR='\n',FIELDTERMINATOR=':')

     

          but , it is giving me the error. Could anyone tell the solution for this. The error is:

     

           Msg 4834, Level 16, State 4, Line 2

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

  • December 19, 2006 at 4:43 am

    #678882

    As the error states, the account does not have permission to perform bulk insert operations.

    GRANT ADMINISTER BULK OPERATIONS TO [domain\user] or [sqluser]

  • December 19, 2006 at 11:47 pm

    #679053

    thanks,

              but i do the same what u told that is:

    GRANT

    ADMINISTER BULK OPERATIONS TO

        but still m getting the error as:

    Cannot grant, deny, or revoke permissions to sa, dbo, information_schema, sys, or yourself

        

        what should i do now, please tell me the remedy....

       in advance thanks......

     

     

  • June 2, 2008 at 4:14 am

    #822824

    login as sa and try again

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply