Re: Bulkinsert Problem
From: P. Ward (peter_at_online.wardyinc.com)
Date: 04/29/04
- Next message: Doug: "Customising Debugging in Query Analyser"
- Previous message: DBA72: "RE: why drop constraints before truncate"
- In reply to: David N: "Bulkinsert Problem"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 29 Apr 2004 20:36:35 +1000
David
An alternative approach may me to use the SQL Server Bulk Copy Command
(BCP). This is a command line program that performs a very similar function
to Bulk Insert. For more details refer to the "bcp Utility" article in SQL
Server Books Online (BOL).
-- --------------------------------- PETER WARD WARDY Inc. www.wardyinc.com --------------------------------- " David N" <dq.ninh@netiq.com> wrote in message news:%232D94JVLEHA.3664@TK2MSFTNGP10.phx.gbl... > > I got a problem with Bulk Insert lately in one of our clients environment. > Basically, I have a stored procedure that creates a temporary table, and > then use the BULK INSERT INTO.. statement to populate the temp. table with > data records from a text file. > > This simple stored procedure running every where but this client, and he the > one that running the program with a login name that does not have > administrator right. As soon as the stored procedure tries to do the BULK > INSERT, SQL throws an error message "The current user does not the database > or object owner of the table #TMP...." > > What rights does the user need to have in order to do the BULK INSERT? > > Best regards, > > David > >
- Next message: Doug: "Customising Debugging in Query Analyser"
- Previous message: DBA72: "RE: why drop constraints before truncate"
- In reply to: David N: "Bulkinsert Problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
