?
Solved

bulk copy error

Posted on 1998-09-11
4
Medium Priority
?
2,481 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 3

Accepted Solution

by:
rickyr earned 100 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
I don't pretend to be an expert at this, but I have found a few things that are useful. I hope that sharing them here will help others, so they will not have to face some rather hard choices. Since I felt this to be a topic of enough importance and…
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…
Suggested Courses

764 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