You do not have permission to use the bulk load statement

Question

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 1

• 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 :)