Tuesday, March 20, 2012

BULK Insert Permissions question

To run a BULK INSERT, Sql BOL says I need to have

"INSERT and ADMINISTER BULK OPERATIONS permissions..."

If I am dbo of a database is that sufficient (rights wise) to bulk insert into that database?

TIA,

Barkingdog

Hey Bill,

If you run this operation under that account then you should have no problems.

Keep us posted with how you are getting on.

pace

No comments:

Post a Comment