BCP Table Name Limit

does anyone know if there is a limit on a table name length in SQL
server 2000 when you want to BCP into the table?Did you try with more than 256 characters?
--
Current location: Alicante (ES)
"BrianGButterfield@.gmail.com" wrote:

> does anyone know if there is a limit on a table name length in SQL
> server 2000 when you want to BCP into the table?
>|||(BrianGButterfield@.gmail.com) writes:
> does anyone know if there is a limit on a table name length in SQL
> server 2000 when you want to BCP into the table?
Not heard of any, and if it does not work with long names, I would call
it a bug.
(Actually, I have run into problems, but only when connecting to SQL 6.5,
and that was looog ago.)
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx