You need to create the ODBC datasources
first.
control panel - administratatieve tools -
datasources
Dirk.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gibson, Richard (IHG)
Sent: Thursday, September 01, 2005 4:36 PM
To: '[email protected]'
Subject: RE: [SA-list] SQL Server table check
I had
a look at that COM check, but when I go to select ODBC data source there is
nothing listed in the box, even though I have SQL Server with its various client
tools already installed on the SA server. Am I missing
something?
Cheers,
Richard
Gibson
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dirk Bulinckx
Sent: 31 August 2005 19:40
To: [email protected]
Subject: RE: [SA-list] SQL Server table checkCOMs for other db?There is an ODBC COM check that will do what you wantDirk.
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 checkWe 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.
