Hi there,

I'm using SQL Server 2008 and I wrote

Exec Master..xp_cmdshell 'bcp "Select * from Coronado.dbo.immunization"
queryout "C:\mobiledoc\immunization.txt" -c -b1000 -T -Slocalhost'

and I run it everything was fine

Now when I'm run it without the -b option it still run at the 1000 rows
Exec Master..xp_cmdshell 'bcp "Select * from Coronado.dbo.immunization"
queryout "C:\mobiledoc\immunization.txt" -c -T -Slocalhost'

no matter wich database or table i want to export the bcp still export it at
1000 and I want all rows at once

how do I reset the bcp utility to reset the -b option

Thanks,
Oded Dror

odeddror (odeddror (AT) cox (DOT) net) writes:
When you export data, BCP always prints a message for each 1000 rows
it copies to the output file, no matter the setting of -b.

-b is only useful on input, where it controls how often BCP commits.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx