You are here: Using trigger to notify an assembly of changes. « MsSQL Server « IT news, forums, messages
Using trigger to notify an assembly of changes.

Posted by simo on 10/13/06 02:31

I have a requirement to create a sorted list of objects, stored within
an assembly, and I would like to use a After Insert/Update trigger to
notify that assembly that something has changed, rather than polling
the database for changes all the time.

My initial problem is that I need to create a static list so that it
can be dynamically looked at by other assemblies, but SQL Server won't
allow me to attach a dll which contains a static method.

Has anyone done something like this? Are there any decent examples
available anywhere?

any help will be appreciated.

simo

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация