Does Sql Query Notification work for clr stored procedures?

Question

Trying to set up caching on our datasets - we're using clr stored procedures - The database doesn't seem to notify the application of data changes

Any clues as to what you are trying to do? Is this MSSQL 2005 or MSSQL 2008? Is this Express or one of the full versions? Are you implementing your notifications by hand (SqlNotificationRequest) or using the high level class (SqlDependency)? No details means fewer and lower quality answers. — Godeke
– Godeke, Commented Dec 15, 2008 at 17:10
MSSQL 2005. We're using SqlDependency class in an ASP.NET application. — Chris Haines
– Chris Haines, Commented Dec 16, 2008 at 9:07

Chris Haines · Accepted Answer · 2009-01-27 13:13:34Z

1

After much testing, the answer seems to be no... it doesn't seem to work for CLR stored procedures.

answered Jan 27, 2009 at 13:13

Chris Haines

6,5656 gold badges52 silver badges64 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1