Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
ferpsql
Starting Member
4 Posts |
Posted - 2008-09-11 : 07:41:45
|
Hi all,I'm trying to use from WinSQL the BULK INSERT statementBULK INSERT ... FROM '...' WITH ( FIELDTERMINATOR =',', ROWTERMINATOR =' |\n' )with my user but I get the error:"Error: you do not have permission to use the bulk load statement."I'm quite new to SQL server, how could I give the right GRANT to my user ?Thanks in advanceferpsql |
|
james_wells
Yak Posting Veteran
55 Posts |
Posted - 2008-09-17 : 07:23:14
|
First Check Server Role Permissions for the login you are using.You Need SYSADMIN or BULKADMINif you do not know thenConnect onto the sql server/ instance using an administrator account.expand sql server instance you are connecting toexpand securityexpand loginshighlight login that needs to be changedright click - propertiesin the pane select server propertiesshould see all server roles associated with instanceBULKADMIN or SYSADMIN need to be checked.SYSADMIN lets you do anythingBULKADMIN is associated with BULK operations |
|
|
|
|
|