trigger a process through sql server

[maxpower1]

I'm new to sql server but here is my question.

In Oracle, there is a utility call dbms_alert that can alert a running process
invoked through a trigger. Running processes could be Visual Basic app or
even PowerBuilder app.

Does anyone know what the equivalent utility is in SQL Server?

thank you

 

[BeckahC]

I've not had to do this before, but I'm pretty sure you can do this with a trigger that would run another Stored procedure. Unfortunately, I do not know the precise syntax of how to do this.

You might have some luck with looking up "Triggers" in Books Online?

Sorry I couldn't be more of a help. BeckahC

 

[maxpower1]

thanks for the reply. However, that is not my question.
I'm looking for THE SPECIFIC function/object/call in
SQL Server that can 'wake up' or nudge another process
when some value change in a table. The equivalent in
Oracle is DBMS_ALERT.

I should not have used the word 'trigger' in the original
msg

thanks

 

[BeckahC]

Sorry, I'm not too familiar with Oracle... have you tried looking for "DBMS_ALERT" in Books Online? That might have some info? Or variations...? BeckahC

 

[maxpower1]

For your future reference, here is how you
do it in sql server:-

create a trigger that calls a stored procedure that uses that xp_cmdshell to
start your vb app. i.e.


CREATE proc dbo.open_program as
exec master..xp_cmdshell @cmd

set you update trigger to call this whenever there is a change