Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > Does the SQL Server 2005 CommandNotification cache dependency workwith stored procedures?

Reply
Thread Tools

Does the SQL Server 2005 CommandNotification cache dependency workwith stored procedures?

 
 
dherbstemail-ng@yahoo.com
Guest
Posts: n/a
 
      03-27-2008
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
 
Reply With Quote
 
 
 
 
David Herbst
Guest
Posts: n/a
 
      03-28-2008
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.
 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help. Getting a An error has occurred while establishing a connectionto the server. When connecting to SQL Server 2005, this failure may be causedby the fact that under the default settings SQL Server does not allow remote aboutjav.com@gmail.com ASP .Net 0 05-03-2008 12:43 PM
Re:Issue with SQL Cache Dependency when passing a SqlCommand as input parameter ASP .Net 0 10-25-2007 03:25 PM
Create XML in ASP.NET 2.0 then use for joined table in SQL Server 2005 Stored Procedure news.sbcglobal.net ASP .Net 2 06-11-2006 08:55 AM
Wohoo! VS.NET 2005/ASP.NET 2.0/SQL Server 2005/BizTalk Server 2006 will launch week of Nov. 7 Juan T. Llibre ASP .Net 0 06-07-2005 05:19 PM
Cache dependency for SQL database changed Steffen Loringer ASP .Net 2 05-17-2005 03:38 PM



Advertisments