SQL Server Performance Forum – Threads Archive

BCP Output File Problem

Hi All, I am running the following BCP process in all SQL Servers at my client place.
BCP "SELECT * from Northwind..Customers" queryout C:Test.txt -c -U XXX -P XXX -S XXX Everywhere it is putting records in the text file except one server. In that server it is always putting 0 records in the text file. The server has SQL Server Developer Edition with SP3. (Product version: 8.00.760(SP3) under Operating System Windows NT 5.0(2195). Could you please let me know why it is not putting records in the output file? Do I need to change any setup in the server or we have to add any other condition in the BCP. Thanks a lot.
prem…

1. Verify that data exist in the table on that server <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> 2. Add "-e C:errors.txt" to the line and see if you get any output in that file. 3. Verify file rights on the disk for the sql account

<blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by Argyle 1. Verify that data exist in the table on that server <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> 2. Add "-e C:errors.txt" to the line and see if you get any output in that file. 3. Verify file rights on the disk for the sql account <hr height="1" noshade id="quote"></blockquote id="quote"> Thanks for your reply. Data is exist in the system. I have added -e C:errors.txt , but errors.txt also generated as blank. Then i have checked this BCP in my local machine command prompt to avoid sql account rights problem. Still i got 0 records in the file.Could you pls give me your suggestion to solve this problem. prem…

Do you get any errors in the NT event logs? Is the servers set up for mixed authentication so that you actually can login with a sql user and password and not just an NT account?

]]>