batch file to send email

Hi,

I am a developer, but my client asked me to write a SQL batch file to send emails at the end of the day. This email should be sen to all the people who make changes to the database table name tblXYZ. I mean update the table for that particular day.
I am using SQLServer2000 database and .net framework.

I need the help really urgent.

Any help would be really appreciated.

Thanks :confused:priya0123,

Have you tried xp_cmdshell ?

This is an extended stored proc that allows you to shell out. You could write a batch file wrapper for a simple smtp client - something like bmail.