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 |
|
sanjnep
Posting Yak Master
191 Posts |
 Posted - 2008-12-12 : 14:21:39
|
| Is there any function or system store procedures to find out the databases under linked server? I can see it through Management studio by clicking linked server under catalog but I want to run it on query analyzer.ThanksSSSanjeev Shrestha12/17/1971 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-12 : 14:34:09
|
| sp_linkedservers |
 |
|
|
sanjnep
Posting Yak Master
191 Posts |
Posted - 2008-12-12 : 14:59:19
|
| No I mean I want to see all the databases name under linked server like if I have linked server CALI700 and it has 3 database Northwind,pubs and test I want to see that.sp_helpservers will show onlt the list of linked server.ThanksSS |
|
|
|
|
|
|
Finding linked server databases