Hi,
Any one know how to send e-mail using SQL SERVER.
Please let me know the steps and set up(if any) for sending a mail.

Thanks in advance.

Regards,
Ram.

Make sure SQL Mail is running (test it in Enterprise Manager -> select the server name, then click Support Services -> SQL Mail and test to see if it's working).

Then use the xp_sendmail extended stored procedure.

Format (incl. passing a SQL query to the mail):
EXEC xp_sendmail @Recipients='[email protected]', @Subject='Subject', @message='Message', @query='Select field from table'