export results to text file sql server 2005
Posted on 2008-06-20
could someone walk me through the process of getting this script out to a text file in sql server 2005?
i thought i could just do SQLCMD mode ... but that doens't work. its just the adventure works db ....
here's the syntax i have... feel ffree to edit it as you wish. again... i would like instructions on what to do... where to go... what to click... etc.
bcp "SELECT top 10 * from dbo.databaselog" queryout c:\test.txt