hi, I am running bcp to back up a table, I want to view a log after the bcp process end. HOw can I create a log file to see the number of rows being copied
ali
Printable View
hi, I am running bcp to back up a table, I want to view a log after the bcp process end. HOw can I create a log file to see the number of rows being copied
ali
Ali,
You would add -o then a path/file name following in order to log the results to a file. Here is an example:
bcp "SQL Code here.." queryout export.txt -c -S ServerName -U UserId -P password -o c:cpsqlloglog.txt
-Adam Fortney
------------
Ali Alhussein at 1/4/00 1:22:41 PM
hi, I am running bcp to back up a table, I want to view a log after the bcp process end. HOw can I create a log file to see the number of rows being copied
ali