COMs for other db?
There is an ODBC COM check that will do what you
want
Dirk.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gibson, Richard (IHG)
Sent: Wednesday, August 31, 2005 4:42 PM
To: '[email protected]'
Subject: [SA-list] SQL Server table check
We have a number of MS SQL 2000 databases that write back maintenance plan history to a table on a central database. I am looking for a check in SA which checks the Status column in this central database table and alerts back as necessary. I have looked on the standard SQL Database checks and it appears it will only check if individual databases are online or not, not the contents of cells within columns within tables within databases(!). I have also found various COM's which have been written for other databases, but not for MS SQL.
Has anyone got any ideas on how to do this, or knows of an external COM which might do the job?
Thanks in advance.
Richard Gibson.
