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
BULK Insert Permissions question
Hot Topic
- Missing Data Mining provider in Management Studio Linked Server definition
- matrix: more than 1 column in static rowgroups ?
- Finding dependency of Objects in SQL Server 2000
- Profiler Error data column
- single parameter multi-select scrunched
- checking report expression syntax
- getting row before in table
- Chart in Reporting Services
- SQL 2005 ENDPOINT ACCESS USING IE
- unable to choose server type as 'SQL mobile server'
SQL Server
- The password of the account must be changed
- Question about "Connect to the sql server 2000 installed on windows xp sp2"
- Calendar is only one.
- Semi-Additive Function not aggregrating on non-time dimension
- Use Aggregate or lookup?
- Should I keep using MS Access 2000 or upgrade it to SQL server?
- Is lineage more trouble than it's worth?
- Using Stored Procedures with Report Builder
- TOP 2 in a Cross Join (Matrix)
- How to stop running DTS package if my view return zero record?
BULK Insert Permissions question
mimi_farah
If you run this operation under that account then you should have no problems.
Keep us posted with how you are getting on.
pace