Allow permission to bulk insert

[danb]

Hi,

I'm trying to run a procedure which does a bulk insert, but am getting a permissions error.

As a total novice to SQL Server, could someone explain how to allow myself permission to do this?

Thanks!

 

[SQL_Hell]

what permissions error do you get??

 

[danb]

Server: Msg 15247, Level 16, State 1, Procedure sp_addsrvrolemember, Line 32
User does not have permission to perform this action.


It's a bulk insert permission I think. I'm on a shared SQL server, so I'm having trouble allowing permissions.

 

[FoFa]

So what does line 32 in your Procedure sp_addsrvrolemember say?

 

[SQL_Hell]

So what does line 32 in your Procedure sp_addsrvrolemember say?

LOL is that a joke?


Ok what you need to do is add your login to the following SQL Server role:

Bulk Insert Administrators

This can be done in SQL server enterpise manager using a system admin role.
Do you have a DBA that can do this for you?