List all the databases with state.

List all the databases with state.

SELECT name,state, state_desc
 FROM sys.databases