Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

BCP error: Msg4806

3 posts in Windows NT Last posting was on 2000-02-13 23:07:43.0Z
Pushpinder Singh Posted on 2000-02-11 03:44:10.0Z
Message-ID: <38A3858A.475B6637@aia.co.nz>
Date: Fri, 11 Feb 2000 16:44:10 +1300
From: Pushpinder Singh <Puspinder.Singh@aia.co.nz>
X-Mailer: Mozilla 4.5 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: BCP error: Msg4806
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 9
NNTP-Posting-Host: mail.aia.co.nz 203.97.192.38
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2556
Article PK: 1090009

Hi,

I am getting following error on calling

bcp NZAC..P4Ext in c:\temp\p4ext.txt -Usa --SmyServer

Server Message : Msg4806,Level 16,State 1:
You can't run non-logged version of bulk copy in this database.Please
check with the DBO.


Does anybody know the solution?

Thanks in Advance.

Pushpinder Singh


Mark A. Parsons Posted on 2000-02-11 05:53:24.0Z
Message-ID: <38A3A3D4.7AA50A86@compuserve.com>
Date: Fri, 11 Feb 2000 18:53:24 +1300
From: "Mark A. Parsons" <iron_horse@compuserve.com>
Organization: Pegasys Ltd
X-Mailer: Mozilla 4.61 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: BCP error: Msg4806
References: <38A3858A.475B6637@aia.co.nz>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 17
NNTP-Posting-Host: p449.ipa1-n8-16.iconz.net.nz 210.48.25.193
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2553
Article PK: 1090004


Pushpinder Singh wrote:
>
> Hi,
>
> I am getting following error on calling
>
> bcp NZAC..P4Ext in c:\temp\p4ext.txt -Usa --SmyServer
>
> Server Message : Msg4806,Level 16,State 1:
> You can't run non-logged version of bulk copy in this database.Please
> check with the DBO.
>
> Does anybody know the solution?

Put an index on P4Ext or set the database option 'select into/bulkcopy'
(via the sp_dboption stored proc).

NOTE: Setting the 'select into/bulkcopy' option on will have an adverse
effect on the recoverability of your database, i.e., you won't be able
to recover non-/minimally-logged activity.

--
Mark Parsons
Pegasys Ltd


Pushpinder Singh Posted on 2000-02-13 23:07:43.0Z
Message-ID: <38A7393F.D8CAA45B@aia.co.nz>
Date: Mon, 14 Feb 2000 12:07:43 +1300
From: Pushpinder Singh <Puspinder.Singh@aia.co.nz>
X-Mailer: Mozilla 4.5 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: BCP error: Msg4806
References: <38A3858A.475B6637@aia.co.nz> <38A3A3D4.7AA50A86@compuserve.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 20
NNTP-Posting-Host: mail.aia.co.nz 203.97.192.38
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2545
Article PK: 1089999

Thanks Mark.
Using indexing solved my problems.

"Mark A. Parsons" wrote:

> Pushpinder Singh wrote:
> >
> > Hi,
> >
> > I am getting following error on calling
> >
> > bcp NZAC..P4Ext in c:\temp\p4ext.txt -Usa --SmyServer
> >
> > Server Message : Msg4806,Level 16,State 1:
> > You can't run non-logged version of bulk copy in this database.Please
> > check with the DBO.
> >
> > Does anybody know the solution?
>
> Put an index on P4Ext or set the database option 'select into/bulkcopy'
> (via the sp_dboption stored proc).
>
> NOTE: Setting the 'select into/bulkcopy' option on will have an adverse
> effect on the recoverability of your database, i.e., you won't be able
> to recover non-/minimally-logged activity.
>
> --
> Mark Parsons
> Pegasys Ltd