How to send mails through SQL Server 2000

[.NetIndia]

Hi All

   It is possible to send mails from SQL Server itself, How it is achieved. Post your answers.

--
Sreetharan S.T
Software Engineer,
Expert OutSource (P) Ltd,
Bangalore - 55.
Mobile 098441 - 23723
 

--
Regards,
.NetIndia Group,
"There is no delight in owning anything unshared."
"A book lying idle on a shelf is wasted ammunition. Like money, books must be kept in constant circulation. Lend and borrow to the maximum -- of both books and money! But especially books, for books represent infinitely more than money. A book is not only a friend, it makes friends for you. When you have possessed a book with mind and spirit, you are enriched. But when you pass it on you are enriched threefold."

Blog:http://dotnetindia.blogspot.com/

[BabuLives]

http://www.aspfaq.com/show.asp?id=2403

Regards,
Satheesh

[ST Sreetharan]

Yes Satheesh, It needs much configuration and other setups related with Server itself, na? Let me try.

 

Thanks a lot

Sreetharan S.T

[Shivprasad Koirala]

Hi
SQL Server does provide facility to send mail but my advice do not use.
Rather make use of mail server or use the mail components provided in
.NET.It will just hog your server down.

-------
Regards ,
C#, VB.NET , SQL SERVER , UML , DESIGN Patterns Interview question book
http://www.geocities.com/dotnetinterviews/
My Interview Blog
http://spaces.msn.com/members/dotnetinterviews/

[Raja Prakash]

Hey...

         dont use the mailserver class in dotnet... suppose if in the server if the webserver failed.. then you will get error... best way is to send mails from sqlserver.... though you should get some third party tool for that to send mails from sql server... because in sqlserver uses the mailserver option.. but it can be handled if the mail is not sent.. in font end you should not catch the exception.. you should not care if the mail is send of not... like this..

 

try

{

  ------

}

catch

{

}
 

Thank you

Raja Prakash
 

[Shivprasad Koirala]

If there is error in sending mails can also be caught through ASP
components. Just meant that SQL Server is a database and
functionalities liek mail which is gigantic task should be seperated.
Poor sql server is already doing lot of work like transactions ,
locking , data warehousing. Best is to make a mail sending service and
deploy it in a different machine and save yur sql server. If your data
is there everything in the world can be reverted back not data.