I got it done through following query:
SELECT name
FROM sys.databases
WHERE CASE WHEN state_desc="ONLINE"
THEN OBJECT_ID(QUOTENAME(name) + '.[dbo].[heartbit]', 'U')
END IS NOT NULL
I got it done through following query:
SELECT name
FROM sys.databases
WHERE CASE WHEN state_desc="ONLINE"
THEN OBJECT_ID(QUOTENAME(name) + '.[dbo].[heartbit]', 'U')
END IS NOT NULL