> My situation is this.
> using mssql 2000:
>
> I have a series of tables.  Each table is designated for a particular
> "profile"
> There are lets say 4 profile tables.  Each table has a list of assets
> in them.  Then the information pertaining to that particular profile
> for that particular asset.
>
> There is going to be a GUI that lets the user alter these tables.
>
> I have a windows service running on the server that supports the
> tables.
>
> I somehow need a way for the windows service to know a change was made
> to any one of those tables, and then upon there being an update
> generate an xml document.
>
> I know how to generate the xml document, I'm having trouble figuring
> out how to make the service aware that a change was made to the
> database.  is there someway that the database can tell the service
> whats going on?   Or is the service gonna have to check the server say
> every 5 minutes and figure out if a change was made?
>
> Any help would be appreciated. thanks!
>