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 |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2008-05-05 : 08:47:26
|
| Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]You do not have permission to use the bulk load statement.I am getting this error when running from an asp script and trying to execute my stored procedure that reads an xml file.Please advise? |
|
|
tosscrosby
Aged Yak Warrior
676 Posts |
Posted - 2008-05-05 : 10:51:12
|
| Does the user have the "Bulk Insert Admin" role assigned to it? Right-click on the user and select the "server roles" tab to check.Terry |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2008-05-05 : 11:25:39
|
| role membership is db_ownerwhat should it be? |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-05-05 : 14:35:25
|
| There is a server role called bulkadmin. You will need to add the user to this server role. |
|
|
|
|
|
|
permission error