PCQ,

It's kinda like asking us to fix your car without seeing the car.  Please post the offending code and table structure along with maybe some sample data

I guess BOL doesn't have a really simple explanation of what an INDEX SEEK is nor why it's better than an INDEX SCAN...

Basically, the name of each says it all......

http://download.microsoft.com/download/0/d/f/0dfe488e-a335-4480-8a8a-b405e32f4368/SQL2005_Sys_Views.pdf

But this is an example of what I'm talking about... this was first on the returns for Google when I searched for "CHART OF SYSTEM TABLES FOR SQL SERVER". ...

This is one place where a "control loop" will help... write the code to only update a couple million at a time in a loop until everything has been updated.  You'll be...

This is a great advantage in parameter use...

Why?  Why do you need to pass a table as a...

Yes... that will work but it's not "dynamic" like the Op asked... if the length is a variable, it will not display as expected in the Text Pane.

This is where you ask "What is Books Online"?

"Books Online" is affectionately known simply as "BOL".  In SQL Server 2000, you can find...

I'm thinking that probably won't matter on BCP that uses "QueryOut"

Thanks Carl...

... or... create a partioned view...

Peter... try SUBSTRING with a variable for length or RTRIM in the text mode on a wide column to see what the OP means... displayed column comes out too wide...

Perfect... thanks for the feedback, Scott.

Nah... that wasn't it... set mine to 40 and still worked on Authors table...

Sorry for the bum info

I believe you need an additional batch command...

mode con[:] [cols=c] [lines=n]