sql server mseq: Hi,
how can i execute a StoreProcedue in SQL2000 every time i received a replay
message with a specific subject, and pass some arguments like the subject.


thank in advanced,

Renato Ribeiro

Hi,

1. Create a Task to execute stored procedure
2. Create a message (SP_ADDMESSAGE) to create the subject
3. Using the message ID and Task name create a alert using SP_ADDALERT
4. Trigger the message using RAISERROR statement.

This will automatically fire the Task to execute the stored procedure

Thanks
Hari
SQL Server MVP

[quoted text, click to view]