I would appreciate some advice on communicating from SQL Server to an
NT application. Basically, I would like the creation of a record in a
SQL Server database by one application to be detected by another NT
application. I was told:
1. SQL Server triggers may be used to notify the other NT application.
Reading up on Triggers, I am not convinced that this may be done, since
they comprise mostly of Transact-SQL statements.
2. SQL Server DBMS may generate an event that may be detected by an
application when a certain record is created. I was unable to find an
example of this in my SQL Server literature.
Is there a recommended mechanism for alerting NT applications as to