bcp Limitation

Is there any limitation on the length of the query used? When the query
exceeds 128 characters, I get the error
Server: Msg 103, Level 15, State 7, Line 1
The identifier that starts with 'Select Id,Name,Descrip, Address,
others,
case when len((Select distinct Street from mydb..testw2 where w2' is
too long. Maximum length is 128.
MadhivananYou can use a view and then bcp from it.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com
.
"Madhivanan" <madhivanan2001@.gmail.com> wrote in message
news:1115982145.425540.79910@.o13g2000cwo.googlegroups.com...
Is there any limitation on the length of the query used? When the query
exceeds 128 characters, I get the error
Server: Msg 103, Level 15, State 7, Line 1
The identifier that starts with 'Select Id,Name,Descrip, Address,
others,
case when len((Select distinct Street from mydb..testw2 where w2' is
too long. Maximum length is 128.
Madhivanan|||Can you post the exact command you are excuting?. BCP expects double
quotation marks around the query and single quotation marks around anything
embedded in the query. For some reason, sql server is interpreting the query
as an identifier and the max length for identifiers is 128. Check database
option "quoted identifier" using sp_dboption or use SET QUOTED_IDENTIFIER in
the batch.
AMB
"Madhivanan" wrote:

> Is there any limitation on the length of the query used? When the query
> exceeds 128 characters, I get the error
> Server: Msg 103, Level 15, State 7, Line 1
> The identifier that starts with 'Select Id,Name,Descrip, Address,
> others,
> case when len((Select distinct Street from mydb..testw2 where w2' is
> too long. Maximum length is 128.
>
> Madhivanan
>

BCP Deployment

Hi all,

I am doing a project that involved with the big volume of data to be
uploaded to the SQL server. Due to the limitation at my employer's
site, I couldn't have the bulk admin right. I am looking at the
command BCP and wonder if there is any copyright issues if I were to
use BCP and to deploy the command?

Thanx.Hi

The use of BCP and the other client tools are governed by the EULA. Without
knowing the exact details of what you are trying to do it would not be
possible to say if you are covered or not.

John

"CY Lim" <limcyang@.yahoo.com> wrote in message
news:ea2b1aa7.0310200251.3d96823a@.posting.google.c om...
> Hi all,
> I am doing a project that involved with the big volume of data to be
> uploaded to the SQL server. Due to the limitation at my employer's
> site, I couldn't have the bulk admin right. I am looking at the
> command BCP and wonder if there is any copyright issues if I were to
> use BCP and to deploy the command?
> Thanx.