Solved

bulk copy error

Posted on 1998-09-11
4
2,424 Views
Last Modified: 2012-08-14
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
Comment
Question by:claytonniki
  • 3
4 Comments
 
LVL 3

Accepted Solution

by:
rickyr earned 50 total points
ID: 1098280
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
 
LVL 3

Expert Comment

by:rickyr
ID: 1098281
typo................
drop the second underscore of sp_db_option on line 3 ie....
sp_dboption
sorry!
regards
0
 

Expert Comment

by:mthyaga
ID: 1098282
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
 
LVL 3

Expert Comment

by:rickyr
ID: 1098283
hi mthyaga.....
Is there an echo in here.

0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

ConnectWise and their customers need to ensure critical alerts automatically reach the right person at the right time. MSP superheros efficiently respond to these alerts key is providing automatic, intelligent alerting that generates a complete audi…
Read about why it is more lucrative for an IT company to participate in government projects.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

837 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question