Automatic email in asp

[pra123]

I am working on asp and ms sql.

I have created a table called as 'usertable' in ms sql database.
The columns in 'usertable' are username, loginid, password.
The record gets added to this table, when a new user makes a fresh registration.

Eg: username = 'david'
loginid='daveuser'
password='newpass'

So My question is whenever a new user is added to a table, an automatic mail
should come to me 'pra123@yahoo.com' mentioning that a new user is added to table ALONG WITH HIS USERNAME, LOGINID, PASSWORD.
All this information should come to my email account automatically.
So how to write ASP Code for this.

Waiting for your reply.
Regards.

[wmif]

you would need to add the email script into your new user registration script. otherwise, i think i recall seeing an article on how to email from the actual sql server. didnt read it, but you can find it on google im sure.