Hi,

try this

DECLARE AllDatabases CURSOR FOR

SELECT name FROM master.dbo.sysdatabases WHERE dbid > 4

OPEN AllDatabases

DECLARE @DBNameVar NVARCHAR(128),@Statement NVARCHAR(300)

FETCH NEXT FROM AllDatabases INTO @DBNameVar

WHILE (@@FETCH_STATUS = 0)

BEGIN

PRINT N'CHECKING DATABASE ' + @DBNameVar

SET @Statement = N'USE ' + @DBNameVar + CHAR(13)

+ N'SELECT COUNT(*) FROM MyLeads WHERE active = 1'

EXEC sp_executesql @Statement

PRINT CHAR(13) + CHAR(13)

FETCH NEXT FROM AllDatabases INTO @DBNameVar

END

CLOSE AllDatabases

DEALLOCATE AllDatabases

ARUN SAS