Query all databases on server

[code lang=”sql”]
DECLARE @DbName VARCHAR(100)
— Sql Query that you want to execute
DECLARE @Sql VARCHAR(MAX) = ‘SELECT * FROM t_alm_lot’

DECLARE ForEachDB CURSOR FOR
SELECT name
FROM sys.databases
OPEN ForEachDB

FETCH NEXT FROM ForEachDB
INTO @DbName

WHILE @@FETCH_STATUS = 0
BEGIN
BEGIN TRY
EXEC(‘USE ‘ + @DbName + ‘;’ + @Sql)
END TRY
BEGIN CATCH
END CATCH

FETCH NEXT FROM ForEachDB
INTO @DbName
END

CLOSE ForEachDB
DEALLOCATE ForEachDB
[/code]