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

  • <LOL>

    And my way is wrong! I [just] realized dblist.txt will be [overwritten] for each server. My bad. Here's a corrected batch file:

    [font="Courier New"]

    @ECHO OFF

    SQLCMD -Lc > serverlist.txt

    FOR /F %%i IN (serverlist.txt) DO (

    SQLCMD /S %%i /E /d master /Q"SET NOCOUNT ON SELECT SUBSTRING(@@SERVERNAME, 1, 30) AS ServerName, SUBSTRING([name],1,40) AS DBName FROM sysdatabases ORDER BY NAME SET NOCOUNT OFF;" >>dblist.txt

    )

    [/font]