List each database's recovery mode for an instance

IF ISNULL(OBJECT_ID('tempdb.dbo.#DBRecovery'), 0) != 0 DROP TABLE #DBRecovery CREATE TABLE #DBRecovery ([dbname] [sysname] NOT NULL PRIMARY KEY CLUSTERED, [RecoveryMode] nvarchar(100) NOT NULL) EXEC sp_MSforeachdb N' INSERT INTO #DBRecovery SELECT ''?'' AS [dbname], CONVERT(nvarchar(100), DATABASEPROPERTYEX(''?'', ''Recovery'')) AS [RecoveryMode] ' SELECT * FROM #DBRecovery