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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-28 : 11:24:39
|
| ran writes "remote database question========================how can I connect to remote sql server from "query analyzer" andfrom "enterprise manager"?I understand that when I use "use <database name> " command I can only call database on the same server .and how can I use remote tables(meaning tables from remote database on the same server and remote database on other server) in a query .export question================how can I export more than one table at the time .I saw that I can give the exp utility and bcp utility only onetable at the time.can it be done by exp and bcp utilities or do I need a scriptto do it , if I do need a script can you please send it to me?10x in advance" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-08-28 : 11:40:19
|
| look at linked servers in bol.Create a linked server - map a logon - give it permissions thenfrom svrname.dbname.dbo.tblnameDon't expect it to perfrom the same way as a loclal table though.If it's not collation compatible it will probablt get the fields on to the local server to do any joins.You are probably better to call an sp on the remote server to do things.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
remote database and export questions