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.
Declare @BCP_Str varchar(1000) Set @BCP_Str = 'bcp "VasMagnolia.dbo.FRBT_BCP_Out" out "E:\DataFiles_1\FRBT.txt" -c -S"1223-VDMS-02A" -U"*****" -P"******" ' Exec master.dbo.xp_cmdshell @BCP_Str,no_output