Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 can anybody help me to solve this issue

Author  Topic 

DURGESH
Posting Yak Master

105 Posts

Posted - 2008-07-28 : 07:37:59
hi all,
i had get the following error when using bcp

bcp "SELECT * FROM employees FOR XML RAW" queryout c:\myfile.xml -catserver -mcams -hipl -c -r -t

error:

Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'queryout'.

thanks in advance

regards
durgesh j

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-07-28 : 08:14:42
Are you sure BCP supports XML?



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

DURGESH
Posting Yak Master

105 Posts

Posted - 2008-07-28 : 21:39:05
yes,
i read in a article
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-28 : 22:45:40
>> -catserver -mcams -hipl -c -r -t

What are those? Why didn't specify server name and logon info?
Go to Top of Page

DURGESH
Posting Yak Master

105 Posts

Posted - 2008-07-28 : 22:50:38
its catserver is servername,username,password
Go to Top of Page
   

- Advertisement -