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.
>
>