SQLEngine (10/13/2008)

---

Marios,
Very useful article, thanks. This opens up other posibilities with SCOM.

Grant Fritchey (10/14/2008)

---

Excellent. Well done. I'll have to see if we can use this one on our servers.

Harold Buckner (11/7/2008)

---

Hi Marios

I like the way you handled this task and the great information it provides. However, I had some errors on the 2000 script thats making me do a lot of head scratching. These our all older 2000 instances on either Windows Server 2000 or 2003

Does any of these make any since to you:

Event Type: Warning
Event Source: Health Service Modules
Event Category: None
Event ID: 21413
Date: 11/7/2008
Time: 1:03:57 PM
User: N/A
Computer: GIS
Description:
The Event Policy for the process started at 1:03:56 PM has detected errors in the output. The 'StdErr' policy expression:
\a+
matched the following output:
C:\Program Files\System Center Operations Manager 2007\Health Service State\Monitoring Host Temporary Files 1\55987\Custom_SQL2000_Blocking.vbs(153, 9) ADODB.Command: Item cannot be found in the collection corresponding to the requested name or ordinal.



Command executed: "C:\WINDOWS\system32\cscript.exe" /nologo "Custom_SQL2000_Blocking.vbs" gis
Working Directory: C:\Program Files\System Center Operations Manager 2007\Health Service State\Monitoring Host Temporary Files 1\55987\

One or more workflows were affected by this.

Workflow name: MomUIGeneratedRule81b439253e464a408ab1d0402a91aad1
Instance name: MSSQLSERVER
Instance ID: {6BEBE62A-DEE0-BEB3-8822-FD9B7941FD43}
Management group: SCOM

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.


Event Type: Warning
Event Source: Health Service Modules
Event Category: None
Event ID: 21413
Date: 11/7/2008
Time: 3:43:07 PM
User: N/A
Computer: GIS
Description:
The Event Policy for the process started at 3:43:06 PM has detected errors in the output. The 'StdErr' policy expression:
\a+
matched the following output:
C:\Program Files\System Center Operations Manager 2007\Health Service State\Monitoring Host Temporary Files 1\56373\SQL2000Blocking.vbs(100, 1) Microsoft OLE DB Provider for SQL Server: String or binary data would be truncated.



Command executed: "C:\WINDOWS\system32\cscript.exe" /nologo "SQL2000Blocking.vbs" gis
Working Directory: C:\Program Files\System Center Operations Manager 2007\Health Service State\Monitoring Host Temporary Files 1\56373\

One or more workflows were affected by this.

Workflow name: MomUIGeneratedRule624f6f0c92d14efc8c6798ca7787892d
Instance name: MSSQLSERVER
Instance ID: {6BEBE62A-DEE0-BEB3-8822-FD9B7941FD43}
Management group: SCOM

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.