SQL cache notification.

N

Nadia Amir

I want to enable SQL cache notification on northwind tables employees. I have used the tool aspnet_regsql.exe as defined in the tutorial http://msdn2.microsoft.com/en-us/library/e3w8402y(vs.80).aspx . It does gives me the message that it has successfully ebale the table for caching .But when i use the applicationw hich use the SQL dependency it gives me this error
The 'Employees' table in the database 'Northwind' is not enabled for SQL cache notification.

Please make sure the table exists, and the table name used for cache dependency matches exactly the table name used in cache notification registration.

To enable a table for SQL cache notification, please use SqlCacheDependencyAdmin.EnableTableForNotifications method, or the command line tool aspnet_regsql. To use the tool, please run 'aspnet_regsql.exe -?' for more information.

To get a list of enabled tables in the database, please use SqlCacheDependencyManager.GetTablesEnabledForNotifications method, or the command line tool aspnet_regsql.exe.
what could be the problem ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed, ASP.NET caching with SQL Server doesn't work 2
where can I find the file aspnet_regsql.exe? 3
SqlCacheDependency - Cache Invalidation wihout result set modification 2
Unable to login to membership database 1
Does the SQL Server 2005 CommandNotification cache dependency workwith stored procedures? 1
stored procedures run against aspnet_* tables return no data rows 2
ASP.NET Configureation - can NOT connect to SQL server 5
Openning WAT does NOT reate aspnetdb.mbf 2

Top