RE: [SA-list] SQL Server table check

Thu, 01 Sep 2005 08:24:43 -0700

Title: Message
The other thing to realize is that when the results of your SQL query is examined by the COM check, the ONLY cell in the results table that is considered is the first field of the first record.
 

Michael D. Shook
Technical Analyst
[EMAIL PROTECTED]
863 668 4477 (work)
863 860 4070 (cell)
863 665 1261 (fax)
www.saddlecrk.com

 

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dirk Bulinckx
Sent: Thursday, September 01, 2005 10:50 AM
To: [email protected]
Subject: RE: [SA-list] SQL Server table check

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 check

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.

Reply via email to