How to Enable Database and table For SQLCacheDependency

Start Visual Studio Command Prompt and enter these commands for enable sqlcachedependency in your application

for enabling a database
for enabling a database

aspnet_regsql -S ServerName -U UserName -P Password -d DataBase -ed

for diUserNamebling a database

aspnet_regsql -S ServerName -U UserName -P Password -d DataBase -dd

for enabling a table

aspnet_regsql -S ServerName -U UserName -P Password -d DataBase -t Table -et

for diUserNamebling a table

aspnet_regsql -S ServerName -U UserName -P Password -d DataBase -t Table-dt

for listing tables

aspnet_regsql -S ServerName -U UserName -P Password -d DataBase -lt