I am testing a simple syntax for Bulk Copy export - Output file is a Flat File with tab delimiter (either in SQL Server 2008 or 2012).
Somehow my command is throwing a syntax error on queryout
:
bcp "SELECT * FROM DatabaseLog" queryout "C:\Test\TestingBulkCopy.txt" -t\t -c -T
BCP is a command-line utility. You need to run it for an OS command prompt rather than from a T-SQL session.