Michael D. Shook
Technical
Analyst
Saddle Creek
Corporation
Michael.Shook@saddlecrk.com
863 668 4477 (work)
863 860 4070 (cell)
863 665 1261
(fax)
www.saddlecrk.com
From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Mark Perry
Sent: Thursday, June 29, 2006 4:36 AM
To: Servers Alive Discussion List
Subject: RE: [SA-list] Feature request...Apologies I misread your message...Although SQL Enterprise shouldn't take 'several' seconds to return result from 3 million...
From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Michael Shook
Sent: 28 June 2006 15:56
To: Servers Alive Discussion List
Subject: RE: [SA-list] Feature request...I'm not sure where you're going...I use MS SQL Enterprise for the DataBase logging...Michael D. Shook
Technical Analyst
Saddle Creek Corporation
Michael.Shook@saddlecrk.com
863 668 4477 (work)
863 860 4070 (cell)
863 665 1261 (fax)
www.saddlecrk.com
From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Mark Perry
Sent: Wednesday, June 28, 2006 10:36 AM
To: Servers Alive Discussion List
Subject: RE: [SA-list] Feature request...Can you not Install MSDE or SQL Server Express 2005.By Default you get 2GB on MSDE (not sure about Express as I haven't used it)...
From: Servers Alive Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Michael Shook
Sent: 28 June 2006 14:56
To: Servers Alive Discussion List
Subject: [SA-list] Feature request...I currently use a template to extract summary information from each cycle to a .asp page that I can include in my other web lookup pages.
------------------------------------------------------------
<%strSAID = "<sa_said>"
strCycleStart = "<sa_cyclestart>"
strCycleTime = "<sa_cycletime>"
strSAStart = "<sa_startshortdate> <sa_startlongtime>"
strSAVersion = "<sa_version>"
strEntriesTotal = "<sa_nr_entries>"
strEntriesUnavailable = "<sa_nr_unavailable>"
strEntriesUnchecked = "<sa_nr_unchecked>"
strEntriesUp = "<sa_nr_up>"
strEntriesDown = "<sa_nr_down>"
strEntriesMaintenace = "<sa_nr_maintenance>"
%>
<!--
This space intentionally left blank
<sa_report>
</sa_report>
-->
---------------------------------------------------------------------Due to reporting requirements, I need this data from the SQL Server. I can query the interchange db for this info, but due to the large number of records, (3 millionish), it takes several seconds to run.
So, my request is for a new db output alongside of the interchange and status dbs for this 'recap' information. Since this is a recap, it would have to be smart enough to delete any previous records from a SAID, then add the current ones. That way I have a record for each of my ServersAlive servers.
Please?
Michael D. Shook
Technical Analyst
Saddle Creek Corporation
Michael.Shook@saddlecrk.com
863 668 4477 (work)
863 860 4070 (cell)
863 665 1261 (fax)
www.saddlecrk.com--------------------------------------
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.--------------------------------------
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.
--------------------------------------
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.
