Thanks for your feedback guys.

However, i was wondering if anybody has done this using cursors.?

thanks

Have you tried running "exec sp_refreshview" store proc for this view?

Hi All,

I am also trying to use xp_smtpmail dll to send mail from sql server, however not able to.We have lotus notes as our email client. Can any of you...