Database names from multiple SQL Servers

Question

I am stuck with a SQL query. How do I get all the databases names from multiple SQL Servers at a time? I have the server IP's in a table.

Answer 1

You can get the database informations using.

SELECT * from sys.databases

If you want to know this from other servers, in pure t-sql, you need to link the server.

More Information

• MSDN - Linking Servers
• MSDN - sp_addlinkedserver (Transact-SQL)

Update after a comment

You say that you cant link the servers. Another alternative is to create a .NET CLR Object and embed them to the server.

Than you can connect to other servers, without linking them together, and execute sql statements.

More Information

• MSDN - Using CLR Integration in SQL Server 2005