Well, a wise man once said: if you´re feeling lost in complexity, step back, take a look at the bigger picture and simplify your stuff...

Sometimes this really works.

Obviously SQL Server interprets multiple JOINs to same table as a SELF JOIN. Interesting - but for my purpose not really usefull :crazy:

After playing around a bit with different approaches...

That showed me the right direction. I solved this with the usage of sp_MSforeachdb.

This is the code that works fine for me:

CREATE PROCEDURE [dbo].[CHECK_DATABASES]

AS

BEGIN

SET NOCOUNT ON;

declare@sqlstatement varchar(max)

declare @dbname varchar(100)

IF...