How can I have a trigger like mechanism on a queue?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Max2006 - 09 May 2008 02:28 GMT

Hi,

How can I have a trigger like mechanism on a queue?

Thank you,
Max

Reply to this Message

Tibor Karaszi - 09 May 2008 05:53 GMT

Wouldn't that be activation?

Signature

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

> Hi,
>
> How can I have a trigger like mechanism on a queue?
>
> Thank you,
> Max

Reply to this Message

Alan Brewer [MSFT] - 10 May 2008 16:14 GMT

Have a look at the internal activation tutorial in the SQL Server 2008 Books
Online. Activation works the same way in SQL Server 2005, but I did not
write the tutorial until after we published the last update to the SQL
Server 2005 Books Online.

http://msdn.microsoft.com/en-us/library/cc281517(SQL.100).aspx

Signature

Alan Brewer [MSFT]
SQL Server Documentation Team

Download the latest Books Online update:
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx

This posting is provided "AS IS" with no warranties, and confers no rights.

Reply to this Message