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

Re: Cannot create trigger 'dbo.Profile.ProfileCodes_AspNet_SqlCacheNotif

Subject: Re: Cannot create trigger 'dbo.Profile.ProfileCodes_AspNet_SqlCacheNotification_Trigger' as its schema is different from the schema of the target table or view.
From: Joe Webb
Date: Thu, 01 Jun 2006 06:15:09 -0500
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Hi - 

You'll probably have more luck in getting responses in another
newsgroup. This one is dedicated to SQL Server Notification Services
(http://www.microsoft.com/sql/ns) and dispite the similar name, it's
not the same thing as Query Notifications.

HTH...

-- 
Joe Webb
SQL Server MVP
http://www.sqlns.com


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)


On 28 May 2006 20:22:47 -0700, [email protected] wrote:

>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>
  • Re: Cannot create trigger 'dbo.Profile.ProfileCodes_AspNet_SqlCacheNotification_Trigger' as its schema is different from the schema of the target table or view., Joe Webb <=