claytonniki
asked on
bulk copy error
When I try to upload a tab delimited file into an existing table in my sql server I get an error:
Msg 4806 level 16, State 1:
You cannot run the non-logged version of bulk copy in this database. Please check iwht the DBO.
I am the dbo :) I don't know what causes this. I am copying by logging in as administrator, and administrator has update priveleges.
Msg 4806 level 16, State 1:
You cannot run the non-logged version of bulk copy in this database. Please check iwht the DBO.
I am the dbo :) I don't know what causes this. I am copying by logging in as administrator, and administrator has update priveleges.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try the following from isql:
use master
go
sp_dboption "your_db_name", "select into/bulkcopy", true
go
use your_db_name
go
checkpoint
go
use master
go
sp_dboption "your_db_name", "select into/bulkcopy", true
go
use your_db_name
go
checkpoint
go
hi mthyaga.....
Is there an echo in here.
Is there an echo in here.
drop the second underscore of sp_db_option on line 3 ie....
sp_dboption
sorry!
regards