executing xp_smtp_sendmail in Activex | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

executing xp_smtp_sendmail in Activex

Hey guys, How will I run this inside my DTS activeX code? exec @rc = master.dbo.xp_smtp_sendmail Thanks!
Something like: SET cn = CreateObject ("ADODB.Connection")
SET rs = CreateObject ("ADODB.Recordset") cn.ConnectionString = "[Connection String to your master DB]"
rs.Execute cn, "EXEC master.dbo.xp_smtp_sendmail" I suggest looking on some vb script forums…. Alternativly just use a T-SQL command in your package. Simon
http://msdn.microsoft.com/library/en-us/dtssql/dts_addf_ax_06er.asp
http://www.databasejournal.com/features/mssql/article.php/3295691
.. on top fo what Simon referred. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Thanks guys. I created a connection string then place an sqltask in there. It worked.
]]>