Unable to enable SQL Cache dependency for tables with schema.

I got this error below when trying to enable sql cache dependency for tables with schema.

An error has happened. Details of the exception: Cannot create trigger 'dbo.Affiliate.Country_AspNet_SqlCacheNotification_Trigger ' as its schema is different from the schema of the target table or view. Failed during cache dependency registration. Please make sure the database name and the table name are valid. Table names mus t conform to the format of regular identifiers in SQL.


Then i found the solution. Need to modify one of the asp.net system stored proc.
http://chrisbenard.net/downloads/code/AspNet_SqlCacheRegisterTableStoredProcedure_new.sql



Published Wednesday, February 07, 2007 9:18 AM by darenhan

Comments

# BenjaminBoyle.com » Blog Archive » Cannot create trigger because its schema is different from the schema of the target table or view

Pingback from  BenjaminBoyle.com      » Blog Archive           » Cannot create trigger  because its schema is different from the schema of the target table or view

Powered by Community Server (Commercial Edition), by Telligent Systems