View Single Post

   
  #1 (permalink)  
Old 03-01-2008, 02:40 PM
sachin shah
 
Posts: n/a
Default how can i send mail by using sql server

hi all

my query is how can i send mail by using sql server, i think by unsing
xp_sendmail store procedure we can do this but my problem is what
paramater to be pass to this store procedure if i want to send mail
from my local machine to another user, bcos i am geeting this error
msg in query analyzer...

query:-EXEC master..xp_sendmail 'ss35934' (ss35934 is valid user name
present into my local nerwork)

getting error msg :- xp_sendmail: failed with mail error 0x80040111

from:- sachin shah

Reply With Quote