November 22, 2011 at 3:52 am
I am getting following error while running bcp command for SQL Server 2008:
Starting copy...
SQLState = 37000, NativeError = 5304
Error = [Microsoft][SQL Server Native Client 10.0][SQL Server]Bulk copy failed.
User does not have ALTER TABLE permission on table 'Adventureworks.Sales.Table1'.
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
Kindly check and let me know how should I resolve this error. I cannot provide ALTER permissions ot the user as ALTER is DDl permission.
November 22, 2011 at 4:38 am
This was removed by the editor as SPAM
November 22, 2011 at 6:12 am
Great. It worked with the hint FIRE_TRIGGERS. It resolved the blockage.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply