Hi,
How can I get the databases that are online.
I want to run the following query
SELECT count(*) FROM sys.databases where state=0
and in the match I put the expected number of online Databases, then if it is not correct I get alerted
I want to monitor SQL Server 2005.
I need Help