Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
Enabling notification for individual tables
Enabling notification for individual tables
✍: Guest
Once the necessary stored procedure and tables are created then we have to notify saying
which table needs to be enabled for notifications.
That can be achieved by two ways:-
ã aspnet_regsql -et -E -d Northwind -t Products
ã Exec spNet_SqlCacheRegisterTableStoredProcedure 'TableName'
Registering tables for notification internally creates triggerfor the tables. For instance for
a “products” table the following trigger is created. So any modifications done to the
“Products” table will update the “AspNet_SqlCacheNotification’ table.
CREATE TRIGGER dbo.[Products_AspNet_SqlCacheNotification_Trigger] ON [Products] FOR INSERT, UPDATE, DELETE AS BEGIN SET NOCOUNT ON EXEC dbo.AspNet_SqlCacheUpdateChangeIdStoredProcedure N'Products‘ END
“AspNet_SqlCacheTablesForChangeNotification” contains a single record for every table you're monitoring. When you make a change in the table (such as inserting, deleting or updating a record), the change Id column is incremented by 1.ASP.NET queries this table repeatedly keeps track of the most recent changed values for every table. When this value changes in a subsequent read, ASP.NET knows that the table has changed.
2007-10-23, 4952👍, 0💬
Popular Posts:
How can you determine the size of an allocated portion of memory? You can't, really. free() can , bu...
What invokes a thread's run() method? After a thread is started, via its start() method of the Threa...
What will be printed as the result of the operation below: main() { char s1[]="Cisco"; char s2[]="sy...
What is the result of using Option Explicit? When writing your C program, you can include files in t...
Can you explain steps in function points? Below are the steps in function points: >First Count ILF, ...