Re: Monitoring MS SQL

Up until SQL Server 7, Microsoft officially supported Sybase client
software. So you could download the Sybase client, and connect to MS
SQL. With TDS version 8.0 (and legacy support for version 7.0) in SQL
2000, compatibility with Sybase client was broken. However, you can
use the Freetds libraries instead. 

So here's what I've done to have a way to connect to both SQL 7 and
SQL 2000: 

1) Download and install freetds from http://www.freetds.org. 
2) Download and install sqsh from http://www.sqsh.org. 
3) export SYBASE=/usr/local/freetds (or where ever your freetds is
installed) 

Now you can use sqsh to connect to your MS SQL: 

sqsh -S servername -U username 

You're now reasy to script your own plugins based on the output you
get from your queries. Works great.


Warrick FitzGerald wrote:
> 
> Hi All,
> 
> Can anyone tell me if there is a module for NetSaint that will allow me
> to monitor MS SQL server. I would live to be able to execute a SQL query
> on the Database, via an ODBC driver of some kind and tie this into my
> monitoring system.
> 
> Thanks
> Warrick
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Get the new Palm Tungsten T
> handheld. Power & Color in a compact size!
> http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0002en
> _______________________________________________
> Netsaint-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/netsaint-users


-------------------------------------------------------
This SF.net email is sponsored by: Get the new Palm Tungsten T 
handheld. Power & Color in a compact size! 
http://ads.sourceforge.net/cgi-bin/redirect.pl?palm0002en