• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2527
  • Last Modified:

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.

0
claytonniki
Asked:
claytonniki
  • 3
1 Solution
 
rickyrCommented:
Hi......
It sounds like you have not set the db_option for selectinto/bulkcopy on your database.
do......

1> use master
2> go
1> sp_db_option "your_db", "select into", true
2> go
1> use your_db
2> go
1> checkpoint
2> go

Hope this helps!
regards
0
 
rickyrCommented:
typo................
drop the second underscore of sp_db_option on line 3 ie....
sp_dboption
sorry!
regards
0
 
mthyagaCommented:
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

0
 
rickyrCommented:
hi mthyaga.....
Is there an echo in here.

0

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now