sql server 2005

• ram.shegokar-914393

  Newbie

  Points: 7

  More actions

  October 23, 2008 at 11:40 pm

  #195061

  Hi

  I m granting EXECUTE on a PROCEDURE for one of the USER , but sql server 2005 does'nt allow me execute that procedure n givin the below error

  Msg 4834, Level 16, State 4, Line 1

  You do not have permission to use the bulk load statement

  Please if any one can help. thanks

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  October 24, 2008 at 8:13 am

  #889246

  From BOL:

  To execute INSERT with the OPENROWSET function BULK option, you must be a member of the sysadmin fixed server role or of the bulkadmin fixed server role.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question