microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Cannot create trigger 'dbo.Profile.ProfileCodes_AspNet_SqlCacheNotificat

Subject: Cannot create trigger 'dbo.Profile.ProfileCodes_AspNet_SqlCacheNotification_Trigger' as its schema is different from the schema of the target table or view.
From:
Date: 28 May 2006 20:22:47 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
I am having problems enabling sql table for notifications in sql 2005.
The problem is that when i use custom schema name i get following
error:

Cannot create trigger
'dbo.Profile.ProfileCodes_AspNet_SqlCacheNotification_Trigger' as its
schema is different from the schema of the target table or view.


Everything works fine if I change schema name to "dbo".


this does not work:
C:\Program Files\Microsoft Visual Studio 8\VC>aspnet_regsql -E -d MYDB
-et -
t Profile.ProfileCodes


Enabling the table for SQL cache dependency.


.An error has happened.  Details of the exception:
Cannot create trigger
'dbo.Profile.ProfileCodes_AspNet_SqlCacheNotification_Tri
gger' 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.


The failing SQL command is:
dbo.AspNet_SqlCacheRegisterTableStoredProcedure


BUT this works fine: (after i switch schema name to "dbo")
C:\Program Files\Microsoft Visual Studio 8\VC>aspnet_regsql -E -d MYDB
-et -
t dbo.ProfileCodes


My question is: Why can't i enable table notifications when i use my
own schema names? 


what am i doing wrong? 


thanks


<Prev in Thread] Current Thread [Next in Thread>
  • Cannot create trigger 'dbo.Profile.ProfileCodes_AspNet_SqlCacheNotification_Trigger' as its schema is different from the schema of the target table or view., emer . kurbegovic <=