select name, state_desc from sys.databases where 1=1 and name not in ('master','msdb','tempdb','model') and state_desc not in ('OFFLINE','SUSPECT') order by name
ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.