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.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 Event for table modification

Author  Topic 

olibara
Yak Posting Veteran

94 Posts

Posted - 2013-11-20 : 10:58:12
Hello

I'm working with .NET cSharp accessing MS Sql database with ADO

From my application I need to know is some little reference tables get modified. If yes I need to reload some data
The tables and load process are not heavy but everytime something is insertet or updated I need to reload all

I'm trying to figure out is trying to use MSSS Event will be the best or if having trigger updating a little flag table that can be watched by the application every n seconds is not even simpler

Any idea ?
Thanks for your help
   

- Advertisement -