Email Trigger

Hi.
I am trying to set a trigger to send an email notification. is this possible
in SQL 2000?
What i am trying to do is send an email saying that a client has been here
for 12 months and would like to raise the rent.
Regards WilburSomething similar to this laid out in http://www.aspfaq.com/2403
"panda" <panda@.discussions.microsoft.com> wrote in message
news:30401819-8EE7-42E3-8898-2F8E75880C40@.microsoft.com...
> Hi.
> I am trying to set a trigger to send an email notification. is this
> possible
> in SQL 2000?
> What i am trying to do is send an email saying that a client has been here
> for 12 months and would like to raise the rent.
> Regards Wilbur|||thank you very much.
"Aaron Bertrand [SQL Server MVP]" wrote:

> Something similar to this laid out in http://www.aspfaq.com/2403
>
>
> "panda" <panda@.discussions.microsoft.com> wrote in message
> news:30401819-8EE7-42E3-8898-2F8E75880C40@.microsoft.com...
>
>