this is my string query

declare @cmd nvarchar(1000)

set @cmd = 'bcp "select * from northwind..customers" queryout d:\w3root\test\atest.txt -S"testserver" -T -w'

exec master..xp_cmdshell @cmd

when excute it at first time ,...

declare @cmd nvarchar(1000)

set @cmd = 'bcp Northwind..customers out d:\w3root\test\atest.txt -T -w '

exec master..xp_cmdshell @cmd

I run the above query in sqlserver 2005 , i can be run at the first...

yes, i have full control in this folder and I am running the query in a sql 2005

it only can run it once and create the output file,...

use my domain account , it has the administrator's right

but I found the answer, I missed the parameter -T -c at the end of the statement ,

but there is...

yes, it does exist