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

SqlProvider issue

Subject: SqlProvider issue
From: Peruukki
Date: Tue, 28 Aug 2007 03:40:18 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
Hi all,
I am wondering what's the best practice for the problem I'm facing.
I'd like to use a scheduled provider that checks if a field is changed
in a table, but looking at examples it seems that there's no other way
but keeping a chronicle table with previous values.
Due to the large amount of data, it does not seem so performant.
So I was thinking at the possibility to trigger each change in sql
server, save data in a custom table and let the provider read this
user-created chronicle table.

Does it seem reasonable for you or is there a better way to do it?

Thanks Mauro


<Prev in Thread] Current Thread [Next in Thread>