SQL Server Home
bcp row count limit 4-byte integer
2/6/2009 2:21:55 PM
User(s) can reproduce this bug
Given that tables are growing larger and larger can this limitation be removed?
SQL Server 2005 SP2 - Enterprise Edition
Tools (SSMS, Agent, Profiler, etc.)
Win2003 Enterprise Server (SP2)
Operating System Language
Steps to Reproduce
Attempt to bcp in more than 2^31 rows and the row counter overflows causing an error.
Error occurs after 2^31 rows
bcp should continue
to post a comment.
Please enter a comment.
on 3/16/2009 at 2:19 PM
We have identified that this issue has been fixed in the SQL Server 2008 BCP tool. If you feel that this bug has been resolved incorrectly, please let us know.
on 2/17/2009 at 6:03 PM
Thank-you for your continuing support of Microsoft SQL Server product. We have resolved your reported issue with the BCP tool that is part of SQL Server 2008. You can download the command line utilities that are part of the SQL Server 2008 Feature Pack at http://www.microsoft.com/downloads/details.aspx?FamilyId=C6C3E9EF-BA29-4A43-8D69-A2BED18FE73C&displaylang=en
to post a workaround.
Please enter a workaround.
© 2014 Microsoft