December 20, 2006 at 2:20 am
I've written a code as:
bulk insert checkdata from 'E:\hi.txt'
with(ROWTERMINATOR='\n',FIELDTERMINATOR=':')
but , it is giving me the error. Could anyone tell the solution for this. The error is:
-------------------------------------------------------------------
Msg 4834, Level 16, State 4, Line 2
You do not have permission to use the bulk load statement.
---------------------------------------------------------------------
If it is a permission error , then i've done this to:
GRANT ADMINISTER BULK OPERATIONS TO
but still m getting the error as:
Cannot grant, deny, or revoke permissions to sa, dbo, information_schema, sys, or yourself
what should i do now, please tell me the remedy....I'm not able to get the solution for this. This is very exigently required.
in advance thanks......
December 20, 2006 at 2:45 am
If you don't have ADMINISTER BULK OPERATIONS permission then you can't grant it to yourself. You will need to ask somebody who is authorised to grant it (for example a system administrator) to do it for you.
John
December 20, 2006 at 3:11 am
no one is here to guide me for this. If this not too difficult so, could u please tell me how do that. the system admin is also not here.
in advance thanks a lot...
December 20, 2006 at 3:39 am
If your sysadmin isn't there, then I think you're stuck. Unless you can log in as someone with sysadmin rights, that is.
John
December 21, 2006 at 12:50 pm
Yes, if no one is there that is able to grant you the permissions you need, you are out of luck. You can not get the permissions any other way.
December 21, 2006 at 3:08 pm
Then... Create SSIS package and choose FAST LOAD option ....
I don't know they are calling option as FAST LOAD or something else in 2005.
MohammedU
Microsoft SQL Server MVP
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply