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.