Does anybody knows what is the max number of rows when using BCP and if there
is any way to change it??

Max Number of rows?

I didn't think there was one (Unless constrained by the destination)

This page lists the parameters

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\coprompt.chm::/cp_bcp_61et.htm

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"AAugusto" <AAugusto (AT) discussions (DOT) microsoft.com> wrote

There's a LASTROW parameter available in BCP via the command line. This
example:

bcp mydb.dbo.mytable in x:\dir\file.dat /T /n /L 4000

would load only the first 4000 rows from the file. You can also set a
similar parameter using the "bulk insert" task in DTS (but I have not tried
that myself). Hope this information helps you.

"AAugusto" <AAugusto (AT) discussions (DOT) microsoft.com> wrote

i've done a billion rows i believe without a problem

--
Message posted via http://www.sqlmonster.com