Bulk insert without sysadmin or bulk admin role????possible???

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Loner SSC-Insane Points: 21279 More actions · Answer 1

How are you going to run the bulk insert? Do you put the bulk insert in a procedure or use DTS package?

Amu SSCommitted Points: 1691 More actions · Answer 2

procedure but if it is possible with DTS we can use that too.

Loner SSC-Insane Points: 21279 More actions · Answer 3

It is not necessary to have server admin role. Can your DBA give you bulkadmin sever role so you have to have the right to do bulk insert?

Loner SSC-Insane Points: 21279 More actions · Answer 4

Can you use a job to run the procedure? I know it is a pain but then you don't need the sysadmin or bulk insert role.