CODEWITHSUNDEEP
sql-serverlinked-server
TechTalk
TechTalk

Reputation: 51

How to get all database names in one linked server?

We have created one linked server with name

'server_linked_090215'

How do we get all database names which this linked server can access?

Upvotes: 1

Views: 6758

Answers (2)

Biswabid
Biswabid

Reputation: 1411

you can use to get all DBs in SQL Server instance 

SELECT name
FROM master..sysdatabases

for linked servers:

select * from server_linked_090215.master.sys.databases

Upvotes: 1

Munahil
Munahil

Reputation: 2419

You can do something like this :

select * from server_linked_090215.master.sys.databases

Upvotes: 0

Related Questions