Make sure that SQL DMO libs are installed in such way that the usr running SA
can see them.
Also in some cases the SQL installer does NOT registered the DLLs correctly.
There are 2 options that sometimes helps:
do a
REGSVR32 SQLDMO.DLL from within the directory
were you have that DLL
OR
run the serversalive.exe from within the same
directory as the SQLDMO.DLL file
Dirk Bulinckx.
From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of
Ronald Stamper
Sent: Thursday, September 13, 2007 5:06 PM
To: Servers Alive Discussion List
Subject: RE: [SA-list] Enabeling SQL checks in Servers Alive...
Aye I have you on the count, but I am trying to use the SQL Check that is in
Servers Alive but it keep saying that the SQL MO library’s are not
installed.. but I have installed Microsoft Management Studio on it and
registered SQLMO.DLL with regserv to no avail.
Cordially,
Ronald A. Stamper
Database Administrator
Operations
"If you do everything right, nobody will realize you've done anything at all."
From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of
Michael Shook
Sent: Thursday, September 13, 2007 12:31 PM
To: Servers Alive Discussion List
Subject: RE: [SA-list] Enabeling SQL checks in Servers Alive...
Sorry, I meant top, LEFT cell
Michael D. Shook
Systems Analyst - Data Integration
Saddle Creek Corporation
863 668 4477 (work)
863 665 1261 (fax)
My time zone: UTC -0400 (Eastern Daylight Time)
--------------------------------------------------------------------------------
From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of
Michael Shook
Sent: Thursday, September 13, 2007 8:06 AM
To: Servers Alive Discussion List
Subject: RE: [SA-list] Enabeling SQL checks in Servers Alive...
If you do a count(*), then you can ask SA to error if the count is wrong. SA
will only get a result from the top right cell of the result set.
Michael D. Shook
Systems Analyst - Data Integration
Saddle Creek Corporation
863 668 4477 (work)
863 665 1261 (fax)
My time zone: UTC -0400 (Eastern Daylight Time)
--------------------------------------------------------------------------------
From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of
Ronald Stamper
Sent: Wednesday, September 12, 2007 4:31 PM
To: Servers Alive Discussion List
Subject: [SA-list] Enabeling SQL checks in Servers Alive...
Hello I am trying to implement an SQL check in Servers alive that will monitor
a result set…
I am wondering if somehow using external com checks or DB checks if its
possible to have servers alive monitor if the following line of SQL:
select * from sys.dm_tran_locks where request_type='LOCK' and
request_status<>'GRANT'
Returns say more then 5 rows of data… is this possible? I imagine for the
guru’s it is.
Any help on this would be greatly appreciated.
Cordially,
Ronald A. Stamper
Database Administrator
Operations
"If you do everything right, nobody will realize you've done anything at all."
To unsubscribe send a message with UNSUBSCRIBE as subject to [email protected]
If you use auto-responders (like out-of-the-office messages), then make sure
that they are not send to the list nor to the individual members of the list
that send a message. Doing this will get you removed from the list.
--------------------------------------
The information contained in this message is intended only for the use of the
addressee. If the reader of this message is not the intended recipient or agent
of the intended recipient, you are hereby notified that any dissemination,
distribution, or copying of the message is strictly prohibited.
To unsubscribe send a message with UNSUBSCRIBE as subject to [email protected]
If you use auto-responders (like out-of-the-office messages), then make sure
that they are not send to the list nor to the individual members of the list
that send a message. Doing this will get you removed from the list.
--------------------------------------
The information contained in this message is intended only for the use of the
addressee. If the reader of this message is not the intended recipient or agent
of the intended recipient, you are hereby notified that any dissemination,
distribution, or copying of the message is strictly prohibited.
To unsubscribe send a message with UNSUBSCRIBE as subject to [email protected]
If you use auto-responders (like out-of-the-office messages), then make sure
that they are not send to the list nor to the individual members of the list
that send a message. Doing this will get you removed from the list.
To unsubscribe send a message with UNSUBSCRIBE as subject to [email protected]
If you use auto-responders (like out-of-the-office messages), then make sure
that they are not send to the list nor to the individual members of the list
that send a message. Doing this will get you removed from the list.
To unsubscribe send a message with UNSUBSCRIBE as subject to [email protected]
If you use auto-responders (like out-of-the-office messages), then make sure
that they are not send to the list nor to the individual members of the list
that send a message. Doing this will get you removed from the list.
