473,480 Members | 1,997 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Failed creating table cache dependency registration

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_T rigger'
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?

May 10 '06 #1
0 1348

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2065
by: martin | last post by:
Hi, I have a page that contain a dropdown list of values. This drop down list rarely changes so I wish to cache the page. However the values in the dropdown box are taken from a database, so if...
2
1484
by: wh | last post by:
I'm not sure what I am trying to do is correct but within a global object I'd like to store an object with a dependency on a specified directory. I am aware that I am able to add a reference to a...
2
987
by: Jason Dean | last post by:
Hello, Can anybody tell me if it's possible to create a dependency on the contents of a directory? For example, I've just built and ASP.NET image rotator that uses System.IO to loop through all...
3
2975
by: --[zainy]-- | last post by:
AA! I am having problems on creating table through Enterprise Manager. It gives me Error 1038 i.e. is as follows Unexpected Error ODBC error: Cannot use empty object or column names. Use...
1
2485
by: Keithb | last post by:
Is there any way to create a cache dependency based on a folder in the server file system? My application needs to drop a table in the cache if any files are changed in a server file folder or its...
0
937
by: =?Utf-8?B?U29tZXNo?= | last post by:
Hi, I want to set the Cache Dependency to a remote machine file. I used a very simple approach to acheive. CacheDependency objCacheDependency = new...
2
1713
by: KGP | last post by:
I have written one procedure into which I am creating table(Oracle 10g) While executing procedure I get error as:ORA-01031: insufficient privileges where as this user has DBA rights and the same...
1
4756
by: Ankit | last post by:
Hi guys i need to make a table to store a certain data using Tkinter..I have searched on the group but i have not been able to find a solution that would work for me..The thing is that i want my...
1
1386
by: dherbstemail-ng | last post by:
I can get the SQL Server 2005 CommandNotification cache dependency to work with inline SQL. It works in a SqlDataSource as well as with the page OutputCache when making ADO.NET calls. Next I...
0
7041
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7044
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
6929
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5337
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4779
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4481
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
2995
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
1300
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
181
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.