Very Computer

by **Ramy Ayou** » Thu, 10 Feb 2000 04:00:00

Hi all,
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
database updates?

Thanks,
Ramy Ayoub

by **Ivan Santhumayo** » Thu, 10 Feb 2000 04:00:00

Triggers can call extended stored procs such as xp_cmdshell which can run a
NT command.

exec master..xp_cmdshell "<NT command or program>"

Note, however this will run as the account which sqlserver is configured
to.
Another option is to setup a sqlagent job and call sp_start_job <jobname>
from the trigger.

> Hi all,
> 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
> database updates?

> Thanks,
> Ramy Ayoub

--
Ivan Santhumayor
Firmwide Database Support
Goldman Sachs & Co

Note: These are my own views and not that of Goldman Sachs

Very Computer

SQL Server to NT App.

SQL Server to NT App.

SQL Server to NT App.