Hi all, I prefer not to install SQL DMO (or SQL SMO since version SQL 2008r2) on the SQL servers because - have to get an agreement of the SQL administrators - have to do that on multiple SQL servers - have to upgrade that on multiple SQL servers
That's why I installed the Native SQL Client and the SQL Command Line Utilities (sqlcmd.exe) on the Servers Alive server. Both are part of the SQL server (2012) feature Pack. See http://www.microsoft.com/en-us/download/details.aspx?id=29065, look for sqlncli.msi and SqlCmdLnUtils.msi. Now I can use an "External (errorlevel)" check that triggers a CMD-job with an sqlcmd.exe syntax in it. Example: sqlcmd.exe -S TCP:SQL_Server,Instance_Port_Number -d SQL_Database -i file.txt file.txt contains the SQL query Kind regards, Pieter -----Original Message----- From: Servers Alive Discussion List [mailto:salive@woodstone.nu] On Behalf Of dirk Sent: dinsdag 5 mei 2015 15:05 To: Servers Alive Discussion List Subject: RE: [SA-list] SQL server checks So not only give the status on the db, but also the ability to execute a SQL statement and/or stored-procedure? Not sure if SQL SMO is able to do that. dirk On 2015-05-05 14:50, Lau Daniels wrote: > Dirk, > >> From my experience with external check, I prefer this type of checks >> to be external. > If the check takes a "long time" to complete it's not interfering with > the other checks of SA. > > It would be nice if the check can work with different custom sql > checks, eg. to see the results of some stored views. > > Lau > > -----Original Message----- > From: Servers Alive Discussion List [mailto:salive@woodstone.nu] On > Behalf Of dirk > Sent: dinsdag 5 mei 2015 13:40 > To: Servers Alive Discussion List > Subject: RE: [SA-list] SQL server checks > > What do you mean with "custom SQL"? > And why external and not internal? > > dirk. > > On 2015-05-05 11:15, Lau Daniels wrote: >> Dirk, >> >> It no problem for me to remove the old checks, we use sql 2008/2014 An >> external com is preferable, with some configurable settings >> (database/username/passwd/custom sql check). >> >> Regards, >> Lau >> >> -----Original Message----- >> From: Servers Alive Discussion List [mailto:salive@woodstone.nu] On >> Behalf Of dirk >> Sent: dinsdag 5 mei 2015 10:35 >> To: Servers Alive Discussion List >> Subject: [SA-list] SQL server checks >> >> For some time we have a SQL server check in Servers Alive. This check >> is based on SQL DMO, and only works with realy old version of SQL. >> For newer versions of SQL we have the add-on, however not for the >> newest version of SQL. >> >> There are some questions surrounding that. >> * what version(s) of SQL are you using (and want to check) >> * do you see it as a problem if the 'support' for those old versions >> of SQL (upto SQL2000) would be removed from Servers Alive >> * do you prefer it to be a build-in check (like the current SQL DMO >> based one) or do you prefer an external COM check for it >> >> >> >> >> -- >> Dirk Bulinckx >> Servers Alive - http://www.woodstone.nu DNS Hosting on StellarDNS - >> http://www.stellardns.com >> >> To unsubscribe send a message with UNSUBSCRIBE in the subject line to >> salive@woodstone.nu If you use auto-responders (like out-of-the-office >> messages), make sure that they are not sent to the list nor to >> individual members. Doing so will cause you to be automatically >> removed from the list. >> >> ************************************************** >> This email and any files transmitted with it are confidential and >> intended solely for the use of the individual or entity to whom they >> are addressed. If you have received this email in error please notify >> the sender. >> Any views or opinions presented in this email are solely those of the >> author and do not necessarily represent those of the company. >> >> This footnote also confirms that this email message has been swept by >> MIMEsweeper for the presence of computer viruses but we cannot accept >> responsibility for any loss or damage arising from the use of this >> email and/or attachment(s). >> >> To unsubscribe send a message with UNSUBSCRIBE in the subject line to >> salive@woodstone.nu If you use auto-responders (like out-of-the-office >> messages), make sure that they are not sent to the list nor to >> individual members. >> Doing so will cause you to be automatically removed from the list. > > -- > Dirk Bulinckx > Servers Alive - http://www.woodstone.nu > DNS Hosting on StellarDNS - http://www.stellardns.com > > To unsubscribe send a message with UNSUBSCRIBE in the subject line to > salive@woodstone.nu If you use auto-responders (like out-of-the-office > messages), make sure that they are not sent to the list nor to > individual members. Doing so will cause you to be automatically > removed from the list. > > To unsubscribe send a message with UNSUBSCRIBE in the subject line to > salive@woodstone.nu > If you use auto-responders (like out-of-the-office messages), make > sure that they are not sent to the list nor to individual members. > Doing so will cause you to be automatically removed from the list. -- Dirk Bulinckx Servers Alive - http://www.woodstone.nu DNS Hosting on StellarDNS - http://www.stellardns.com To unsubscribe send a message with UNSUBSCRIBE in the subject line to salive@woodstone.nu If you use auto-responders (like out-of-the-office messages), make sure that they are not sent to the list nor to individual members. Doing so will cause you to be automatically removed from the list. To unsubscribe send a message with UNSUBSCRIBE in the subject line to salive@woodstone.nu If you use auto-responders (like out-of-the-office messages), make sure that they are not sent to the list nor to individual members. Doing so will cause you to be automatically removed from the list.
