Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
avmreddy17
Posting Yak Master
180 Posts |
 Posted - 2007-09-12 : 18:39:47
|
| I have a SQL Server Login and I added this User to the BULK Insert Administrators Server Role , but still I get the following errorServer: Msg 4834, Level 16, State 1, Line 1You do not have permission to use the BULK INSERT statement.Any thoughtsThxReddy |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-12 : 18:52:07
|
From SQL Server 2005 BOL:quote:
PermissionsRequires INSERT and ADMINISTER BULK OPERATIONS permissions. Additionally, ALTER TABLE permission is required if one or more of the following is true:Constraints exist and the CHECK_CONSTRAINTS option is not specified. Note: Disabling constraints is the default behavior. To check constraints explicitly, use the CHECK_CONSTRAINTS option. Triggers exist and the FIRE_TRIGGER option is not specified. Note: By default, triggers are not fired. To fire triggers explicitly, use the FIRE_TRIGGER option. You use the KEEPIDENTITY option to import identity value from data file.
Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
BULK INSERT