How do I create a sql dependency ona table in sql server 2000 and asp.net 2.0?

Question

I need to create a sql dependency on a table in sql server 2000 in my asp.net 2.0 pages.

What are the required actions and what is the best way?

Answer 1

Microsoft has a great tutorial on this which basically explains that you need to enable it using the aspnet_regsql.exe utility or the SqlCacheDependencyAdmin class