i change the table name ##Errors and its work.

May i know why this will happen?

thanks

yup, sorry it is just a typo when i post the question and i had edit it already.This not the cause for the error.

Did you have any idea regarding to...

-blank-

Hi there, i know how to send the mail but have no idea how to grad the data i wan every time when there is any update to the alarm.

Regards,

CL

For my,can i write like this to retrieve POSITION1,HAPPENTIME And CODE?

Beside, is it will send the mail everytime my database update if use the code below??

The output i try to...

BrainDonor (5/20/2009)

---

Hi cl_see,

I'm in the process of developer a solution similar to your requirements.

I have a user on SS 2000, with no email client installed on the same server...

RBarryYoung (5/19/2009)

---

If you can provide us with the the table definition (CREATE TABLE ..., you can script this out from enterprise manager) and an example of what data change or...

RBarryYoung (5/19/2009)

---

You can do it in a trigger, but it's probably not a good idea. That's because in SQL 2000 you have to use SQL MAIL which is synchronous...