thegunner thegunner - 1 month ago 11
ASP.NET (C#) Question

You do not have permission to use the bulk load statement

Hi I'm getting the error


You do not have permission to use the bulk load statement.


when I try to execute a stored procedure.

I've seen some websites mentioning about the
bulkadmin
role, but I don't see it.

I'm using SQL Server 2008.

Any ideas?

Answer
  • Start SQL Server Managament Studio
  • Expand Security->Logins
  • Locate your user, right click on it and take Properties
  • Open Server Roles tab
  • Make sure that bulkadmin is checked.
  • There you can experiment with other roles if bulkadmin doesn't work for you.
  • Click OK :)