July 2, 2011 at 4:00 am
pls give me steps for configure sp_send_cdosysmail in sql server 2008.
July 2, 2011 at 10:56 am
Coolroof (7/2/2011)
pls give me steps for configure sp_send_cdosysmail in sql server 2008.
Using CDO for mailing is from the SQL 2000 days. Please consider the Database Mail subsystem to send email from T-SQL in SQL 2008:
http://technet.microsoft.com/en-us/library/ms175887.aspx
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 4, 2011 at 3:00 am
Coolroof (7/2/2011)
pls give me steps for configure sp_send_cdosysmail in sql server 2008.
Already answered and SSC link given.
http://qa.sqlservercentral.com/Forums/Topic1134818-391-1.aspx#bm1134840
Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/
July 4, 2011 at 4:55 am
You can get the code for the stored proc from:
http://support.microsoft.com/kb/312839.. i've also attached the same.
Before executing the script you need to change the Mail server name:
-- Replace MailServerName by the name or IP of your SMTP Server.
EXEC @hr = sp_OASetProperty @iMsg, 'Configuration.fields("http://schemas.microsoft.com/cdo/configuration/smtpserver").Value', cdoSMTPServerName.
Once done with this you would be able to send mails using this store proc.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply