• Nice script - Thank you.

    One more problem: how to exclude OffLine databases? I've added

    AND ISNULL(version, 0) > 0

    and it seem to work with 2005 but not sure about other SQL Server versions.

    SELECT * from Master..SysDatabases

    WHERE name NOT IN ('master','msdb','model','tempdb') AND ISNULL(version, 0) > 0

    --Vadim R.