SQL Server Performance Forum – Threads Archive
executing xp_smtp_sendmail in ActivexHey 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
.. on top fo what Simon referred. Satya SKJ
Contributing Editor & Forums Moderator
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.