[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.aspnet.caching

Failed to create table sql cache dependancy

Yuva

5/9/2006 1:33:00 PM

Hi
I have created a datatbase "testschema" and schema called "MySchema". I have
created a table "MySchema.table1" in the database. I am trying to create sql
cache dependancy on table using aspnet_regsql utitlity.

aspnet_regsql -S localhost -U UserA -P usr@123 -ed -d testschema -et -t
MySchema.Table1

But it throw an error.

Enabling the table for SQL cache dependency.

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

The failing SQL command is:
dbo.AspNet_SqlCacheRegisterTableStoredProcedure

I have tried with out schema name and again it is failed. Pl. let me know
what's wrong creating dependancy on table?
4 Answers

Brock Allen

5/10/2006 10:05:00 PM

0

You need to first enable the database for cache dependency with:

aspnet_regsql -S ... -U ... -P ... -d testschema -ed

then enable the table:

aspnet_regsql -S ... -U ... -P ... -d testschema -t table1 -et

-Brock
http://staff.develop....


> Hi
> I have created a datatbase "testschema" and schema called "MySchema".
> I have
> created a table "MySchema.table1" in the database. I am trying to
> create sql
> cache dependancy on table using aspnet_regsql utitlity.
> aspnet_regsql -S localhost -U UserA -P usr@123 -ed -d testschema -et
> -t MySchema.Table1
>
> But it throw an error.
>
> Enabling the table for SQL cache dependency.
>
> An error has happened. Details of the exception:
> Cannot create trigger
> 'dbo.MySchema.Table1_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.
> The failing SQL command is:
> dbo.AspNet_SqlCacheRegisterTableStoredProcedure
> I have tried with out schema name and again it is failed. Pl. let me
> know what's wrong creating dependancy on table?
>


emer.kurbegovic

5/27/2006 6:27:00 AM

0

i have exactly the same problem. if i switch the schema name to "dbo"
it registers correctly. it does not seem to be working with any other
schema name but "dbo".

Here is the Error Message:
Cannot create trigger
'dbo.MySchema.Codes_AspNet_SqlCacheNotification_Trigger' as its schema
is different from the schema of the target table or view.

emer.kurbegovic

5/27/2006 6:32:00 AM

0

I do register the database first correctly and i can register any table
within the "dbo" schema.

what am i doing wrong?

emer.kurbegovic

5/29/2006 3:12:00 AM

0

can anyone help out here?