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 |
|
danyeung
Posting Yak Master
102 Posts |
 Posted - 2006-07-25 : 11:43:01
|
| When I right clicked on Security - Linked Servers and select New Link Server, I can only link to a particular database in that server. How can I just link to the server, so I can get data from any database in that server from sharing with one linked server name?Thanks.DanYeungThanks.DanYeung |
|
|
airjrdn
Starting Member
35 Posts |
Posted - 2006-07-25 : 13:37:20
|
| I'm not sure, but I don't think you can. It may be possible in SQL 2005, I haven't setup any linked servers since SQL 2000. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-07-25 : 19:34:07
|
Yes you can.when accessing the database use[srv1].db1.dbo.tableor[svr1].db2.dbo.table
KH |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-07-25 : 19:51:25
|
| to add to Khtan's message, you need to also make sure that the user you connect as (to your linked server) also has permissions in the other databases you want to query.-ec |
|
|
|
danyeung
Posting Yak Master
102 Posts |
Posted - 2006-07-26 : 11:22:01
|
| I could only link to one database in the server. How do I giver permissions to other database. Can you please give me an example?Thanks.DanYeung |
|
|
|
|
|
|
SQL Server - Security - Linked Servers Feature