Querying SQL Server Online Database Information

/*Fetch SQL Server Online Database Details

Created By: Adarsh Agrawal

Created Date: 04/30/2015

*/

DECLARE @Name VARCHAR(MAX) = ''

DECLARE @Table TABLE(Name VARCHAR(500))

INSERT INTO @Table

Select Name as [Online Database] FROM sys.databases (Nolock)

Where state_desc = 'ONLINE'

Order by name asc;

Select @Name = @Name + [Name] + ', '

FROM  @Table

SELECT @@SERVERNAME as [Server Name],

CASE WHEN LEN(@Name) = 0 THEN ''

ELSE SUBSTRING(@Name,1,LEN(@Name)-1) END [Online Database]