Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Using NS to send mail notification at table insert

Author  Topic 

Prudence
Starting Member

5 Posts

Posted - 2003-02-09 : 19:47:48
I have a table with about 10 columns, containing PC information. I added one column called "Status" , containing value of either 0 or 1.

At SQL insert from outside program, the value of "Status" column is set to 0.

I need to send notification (through email) to a specific address that there was an INSERT to the table.

Can I use SQL Service Notification Services for this?



Edited by - Prudence on 02/09/2003 19:49:02

skillile
Posting Yak Master

208 Posts

Posted - 2003-02-10 : 23:06:58
yeah, but why wouldn't you use sqlmail or SMTP through your web browser especially if it is a preset

slow down to move faster...
Go to Top of Page
   

- Advertisement -