RE: [SA-list] SQL Server table check

[Dirk Bulinckx]

Title: Message

Correct, but you can ofcourse create the SQL statement so that the field you want to check is the first field in the first row/record of the result.

 

Dirk.

 

---

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Michael D. Shook
Sent: Thursday, September 01, 2005 5:16 PM
To: salive@woodstone.nu
Subject: RE: [SA-list] SQL Server table check

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: salive@woodstone.nu
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: 'salive@woodstone.nu'
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: salive@woodstone.nu
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: 'salive@woodstone.nu'
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.