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.
| Author |
Topic |
|
priyaram
Yak Posting Veteran
82 Posts |
 Posted - 2005-10-18 : 10:05:45
|
| In the Command line , with BCP.exe for the Openquery Shall i use linked servers.will BCP accept the linked server.B'cos in the systax for BCP , there is no option to speceify the Linked server.Thanks in advance |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2005-10-18 : 11:48:40
|
| I'm not sure that you understand the concept of BCP. BCP works from the command line (DOS or xp_cmdshell or whatever). You connect to a specific server not multiple servers. If you want to BCP out a query then you specify the query and use the queryout option. In that query you can use linked servers as long as they are setup on the specific server that you connected to. If you want to BCP in data to a linked server then why not just connect to that server rather than to the wrong one?Have fun,DanielSQL Server DBAwww.dallasteam.com |
 |
|
|
|
|
|
Linked Servers and BCP Utility