Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 DBMS_ALERT substitute in MS SQL SERVER 2000

Author  Topic 

lalitseth
Starting Member

1 Post

Posted - 2005-02-04 : 05:31:33
Hi all,

I am trying to emulate the behavior of DBMA_ALERT provided in Oracle

which can send signals to C/C++ process on events such as insert,

delete or update using the triggers.

Is there any mechanism in SQL Sever 2000 which can helps me in

acheieving this.

Appreciate for helping.

Many Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-02-04 : 15:01:03
I do not know what DBMS_ALERT is, but perhaps RAISERROR will do what you want. Take a look at RAISERROR in SQL Server Books Online. If that isn't what you want, please provide some more detail on what DBMS_ALERT does.

Tara
Go to Top of Page
   

- Advertisement -