Allow permission to bulk insert (1 Viewer)

D

danb

Registered User.

Local time

Today, 06:40

Joined

Sep 13, 2003

Messages

98

• Jan 25, 2006

• #1

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

SQL Server DBA

Local time

Today, 06:40

Joined

Dec 4, 2003

Messages

1,360

• Jan 25, 2006

• #2

what permissions error do you get??

 

D

danb

Registered User.

Local time

Today, 06:40

Joined

Sep 13, 2003

Messages

98

• Jan 25, 2006

• #3

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

Registered User.

Local time

Today, 00:40

Joined

Jan 29, 2003

Messages

3,672

• Jan 25, 2006

• #4

So what does line 32 in your Procedure sp_addsrvrolemember say?

 

SQL_Hell

SQL Server DBA

Local time

Today, 06:40

Joined

Dec 4, 2003

Messages

1,360

• Jan 25, 2006

• #5

FoFa said:

So what does line 32 in your Procedure sp_addsrvrolemember say?

Click to expand...

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?