Home Forums SQL Server 2005 Administering Database list from multiple SQL servers and instances??? RE: Database list from multiple SQL servers and instances???

  • [font="Courier New"]SELECT name FROM sys.databases[/font] will solve the problem you describe, although I can't help suspecting that your requirement is somewhat more complex than that. You can use a Central Management Server to run it on all servers at once, or use SSIS to loop through your servers one at a time, or you can set up each server as a linked server and run the query like that.

    John