title: Sqlbulkcopyoptions.firetriggers does not fire trigger in the table
body: <p>I have a table with a trigger newly added to it. </p>
  
  <p>When I try to run a batch file and upload the file using SqlBulkCopy it did not work. </p>
  
  <p>After reading that adding SqlBulkCopyOptions.FireTriggers will fire the triggers that are set to the table, I added it. </p>
  
  <p>But still I get the same error - 'Bulk copy failed. User does not have ALTER TABLE permission on table. ALTER TABLE permission is required on the target table of a bulk copy operation if the table has triggers or check constraints, but 'FIRE_TRIGGERS' or 'CHECK_CONSTRAINTS' bulk hints are not specified as options to the bulk copy command.
  '</p>
  
  <p>Any idea what is to be done? Any help would be appreciated</p>