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 |
|
shajimanjeri
Posting Yak Master
179 Posts |
 Posted - 2009-03-18 : 15:06:05
|
| I have a problem when I execute Stored Procedure. It shows "You do not have permission to use the BULK INSERT statement".I run the same SP from my ASP page then it shows Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Could not find stored procedure 'addContactMobilesOnly'. and then I tried to run it from SQL query analyzer then it shows "You do not have permission to use the BULK INSERT statement".Please help me on this? How to solve?regardsShaji |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-03-18 : 16:07:44
|
| clearly, you don't have permissions. You'll have grant the user bulk insert permissions. |
 |
|
|
sakets_2000
Master Smack Fu Yak Hacker
1472 Posts |
Posted - 2009-03-18 : 16:12:56
|
| how are you running the sp ? Can you post the syntax of how you are calling it. Is 'addContactMobilesOnly' the name of the sp ? |
|
|
|
|
|
|
Bulk Insert permission