[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.aspnet.caching

Does the SQL Server 2005 CommandNotification cache dependency work with stored procedures?

dherbstemail-ng

3/27/2008 12:55:00 PM

I can get the SQL Server 2005 CommandNotification cache dependency to
work with inline SQL. It works in a SqlDataSource as well as with the
page OutputCache when making ADO.NET calls.

Next I copy/paste the exact same inline SQL into a stored procedure
wrapper and switch my SqlDataSource or ADO.NET code to call the stored
procedure. Now the cache is no longer refreshed after data in the
query results has been changed.

Has anyone been able to get the SQL Server 2005 CommandNotification
cache dependency to work with stored procedures?

If so, is there anything special that need to be done to enable it to
work with stored procedures?

Thanks,
David
1 Answer

dherbstemail-ng

3/28/2008 6:35:00 PM

0

My standard stored procedure template contains SET NOCOUNT ON. It
turns out that this is not compatible with SQL Server 2005
dependencies. After removing it, cache dependencies work with my
stored procedures.