Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
OBINNA_EKE
Posting Yak Master
234 Posts |
 Posted - 2006-10-03 : 05:12:07
|
| In regards to the article at http://quickstarts.asp.net/QuickStartv20/aspnet/doc/caching/SQLInvalidation.aspx[url]http://quickstarts.asp.net/QuickStartv20/aspnet/doc/caching/SQLInvalidation.aspx[/url]For me to check for table change I have to use notification>aspnet_regsql.exe -S ".\SQLExpress" -E -d "pubs" -et -t "authors"But the problem is that My database is used by many users I would like it to check for specific user rows egI have list of Authors in Authors Table currently I have 5 authorID in the table how do I monitor if AuthorID 3 changes his or her name, I don't want notification to occur in the whole table I want it to occur on AuthorID 3 only, How can I achieve that ?NOTE APPLICATION SETRVICE PROVIDER, every body uses the same tableIf it is that easy, everybody will be doing it |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-10-03 : 07:24:33
|
| You don't. You'd gain almost no savings by querying a table that lists cache info for all Authors by authorID rather than querying the author's table directly by authorId.- Jeff |
 |
|
|
|
|
|
SQL 2000 - ASP.NET 2.0 Polling-based Invalidation