Set a SQL trigger and have asp.net subscribe to it?

Question

Is it possible to set a SQL trigger, where if it gets fired, do something in an asp.net application?

Answer 1

EDIT: Excuse me... taht technology is deprecated, and now you should use: SQL Dependency class

DEPRECATED:

You can use SQL Server Notification Service.

Look at this article:

Understanding SQL Server 2005 Notification Services with ASP.NET 2.0

It uses right the same technology that SqlCacheDependency Class which could also help you, depending on what exactly you want to achieve.

Answer 2

• Theoretically YES (via SQL CLR Stored Proc calling a web service in that asp.net app)
• Psychologically NO

You'd be better using a queue or log table, write to that and have a service or task subscribe to it.