E-mail notifications

Hi,
..I have 4 tables:
Users
userid(PK) username pass addr
Offer
offerid(PK) userid(FK to Users) estateid(FK to Estates) price
rooms
Estate
estateid(PK) city phone addr date ...
Search
searchid(PK) userid(FK to Users) estateid(FKto Estates) min price
max price min rooms maxrooms
In the Search table I store information about every user which wants to
receive automatically information about Estates. I don't know how to
accomplish that. With trigger or something else. In Search could be stored
info from 300-400 users which wants to receive e-mail notifications about
estates by their
criteria everytime when a estate is inserted and it is what they want. .
Could someone gives me a solution for that problem?
Thank you!
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.721 / Virus Database: 477 - Release Date: 16.7.2004 a.
Check Notification Services for SQL Server, that would help i think.
"Viktor Popov" wrote:

> Hi,
> ..I have 4 tables:
> Users
> --
> userid(PK) username pass addr
> Offer
> --
> offerid(PK) userid(FK to Users) estateid(FK to Estates) price
> rooms
> Estate
> --
> estateid(PK) city phone addr date ...
> Search
> --
> searchid(PK) userid(FK to Users) estateid(FKto Estates) min price
> max price min rooms maxrooms
>
> In the Search table I store information about every user which wants to
> receive automatically information about Estates. I don't know how to
> accomplish that. With trigger or something else. In Search could be stored
> info from 300-400 users which wants to receive e-mail notifications about
> estates by their
> criteria everytime when a estate is inserted and it is what they want. .
> Could someone gives me a solution for that problem?
> Thank you!
>
> --
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.721 / Virus Database: 477 - Release Date: 16.7.2004 a.
>
>