You can use Export/Wizard instead.

try this syntax:

bcp "select * from whatever" queryout c:\authors.txt -c -T

basically i think you need the quotes around your query and not your export file... let me know if that helped

try this syntax:

bcp "select * from whatever" queryout c:\authors.txt -c -T

basically i think you need the quotes around your query and not your export file... let me know if that helped

I am copying my query result into a temp table and trying to write the contents of the temp table into a flat file..

When I do:

BCP "#temp_NS_events" queryout c:\abc.txt -c -T

I get the error:

Incorrect syntax error near 'BCP'

if you just need to export query result in to text file then just run query as result to file

Query->Result to->reuslt to file

all the best ,

have good weekend

use tempdb

create table playertemp

( playerID varchar(25),

playerFname varchar(25),

playerLname varchar(25),

email varchar(25))

insert into playertemp

select * from test.dbo.player  //just use your query over here

and then

bcp tempdb.dbo.playertemp out "c:\playertemp.txt" -c -T -SKalopoolbasi

note Kalopoolbasi is the server name

This should work.

Thanks Chintamani...I will let you know how it went after I try this.

Thank you very much.

Why do you have to put  the results in Temp table taking TEMPDB resources. Remember SQL server 2005 uses lot of TempDB resources than SQL 2000. Just use Export/Import wizard and schedule it if you like to.