Wednesday, October 22, 2008

Bulk Load Permisions in SQL Server

Managing permissions is alway a tight wire act. Recently after cleaning up some permissions on an investigation box I had a developer emailed me this error.


Msg 4834, Level 16, State 4, Line 7
You do not have permission to use the bulk load statement


This is a pretty easy fix just add the user to the bulkadmin server role

No comments: