I want to use a trigger to set a web server session variable to indicate if a users table has changed. I have this SQL so far...

"CREATE TRIGGER Alert ON usertable AFTER INSERT, UPDATE, DELETE AS statements GO"

Is this even possible?

Nope.

SQL server has NO interaction with the webserver

Originally Posted by chrishirst

SQL server has NO interaction with the webserver

Dude! It's a brave new world out there. You need to play with .NET!

To answer the original question, sure, absolutely, you can use a trigger to change a session variable. There's a little bit of complexity involved, and a definite performance hit. But it can absolutely be done, and this is better than polling.

1. Expose a web service that lets your session variable be modified on demand.
2. Create a SQL CLR (aka .NET) stored procedure that calls the web service.
3. Call this stored procedure from your trigger.