SQLTeam.com | Weblogs | Forums

Sending message from sql to a servlet in a MIDDLE of stored procedure


#1

Hi, I would like to know wethere it is porssible to send message from stored procedure in Sql server to a servlet in a MIDDLE of the stored procedure (which is keep running)

For example, Lets say I have a stored procedure with a "waitfor" inside of it.
I would like to inform the servlet when the waitfor is ended.

I appreciate any help with this because I'm little lost by now. :unamused:
thanks, Eliran.


#2

I would write to a table inside the stored procedure and have the servlet check that table frequently.