In a Stored Procedure, I'm trying to export MS SQL table (with 1000 records) to a text file using 'bcp' command.
But, It does not export all the rows, the number of rows exported vary on each execution of the stored procedure and it's always less than 1000.
Please help me on this. This is my piece of code.
you could add -eErrorFile.txt to your cmd line and see what errors are logged.
answered Oct 23 '09 at 01:51 AM