MS SQL Alerter
(c) Alex Konshin   3 Jul 2000
    mailto:alexk@mtgroup.ru
    http://www.mtgroup.ru/~alex/

Excuse my english.


Installation:

 - [optional] build dll and sample application by runnig BuildAll.bat or
 DebugProject.bat;
 - copy BIN\xp_acnt.dll to MSSQL\BINN directory;
 - run install.sql in SQL Query Analizer, current database must be "master";

Using:

1. On any Win NT/2000 computer start BIN\sample.exe
   It is console application. You may press Ctrl-C at any time to stop it.

2. In any stored procedure, trigger or query batch insert line like this:

 exec master..xp_send_params_to_pipe '\\COMPUTER\pipe\TestPipeServer', parm1, parm2, ...

where COMPUTER is '.' (local) or name of computer where Sample.exe is running.
If current database is "master" you may use short procedure name notation
without specified database name.


 If you build executables by DebugProject.bat you can see ODS (OutputDebugString)
output in any ODS tracer, I recommend this
 http://www.sysinternals.com/dbgview.htm


Notice:

 Sample.dpr demonstrate how to receive and decode messages from SQL server.
It's implemented as single thread pipe server with overlapped opertions.
In your real application you may use other pipe server technology (multithread
or completion routine), see MSDN for more information about Named Pipes.
I recomend to put PipeControler in separate thread to free main (VCL) thread
for useful work.