|
Home > Archive > MS SQL XML > November 2006 > BCP Usage with SQL Server 2005 Clustered Server
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
BCP Usage with SQL Server 2005 Clustered Server
|
|
|
| How can I use BCP to create an XML format file on a SQL Server 2005
cluster that has multiple instances of SQL Server running? Is there
some sample syntax, etc.?
Thx.
-ak
| |
|
| This syntax "appears" to work...
bcp & #91;sqlcls1dev\inst2
005dev].& #91;BusinessContacts
].[Branch] format -x -T
-fc:\temp\myfile.xml
However, I get a connection timeout error that also states that the SQL
Server 2005 by default doesn't allow remote connections. But, I see
that this server does allow remote connections in the options. I am
logged into the box using Win authent and my Win acct has sysadmin
privileges on the sql server instance. Any information would be
appreciated.
-ak
Ayron wrote:
> How can I use BCP to create an XML format file on a SQL Server 2005
> cluster that has multiple instances of SQL Server running? Is there
> some sample syntax, etc.?
>
> Thx.
>
> -ak
|
|
|
|
|