Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««23456

Sending E-Mail from SQL 2008 Express Expand / Collapse
Author
Message
Posted Friday, July 12, 2013 2:51 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, April 17, 2014 11:01 AM
Points: 350, Visits: 99
Passing in a comma separated list of recipients is good and well if you were hard-coding them, but it would become more work if it were queried from a table. I'd imagine that you could pass in a table variable to be consumed as a DataTable instead. I've done this with a C# app., but not with an extended stored procedure.
Post #1473237
Posted Friday, July 12, 2013 3:20 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 14, 2013 7:00 PM
Points: 74, Visits: 88
Great article, but I don't understand why you would go thru all this trouble, not to mention opening up CLR on the server, which is a security risk if not handled correctly, when all you need to do is execute sp_send_dbmail (just like on a regular standard or enterprise install of SQL)?




Post #1473247
Posted Sunday, July 14, 2013 2:55 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, April 14, 2014 3:39 PM
Points: 8, Visits: 35
Nice solution - just wondering why you wouldn't simply use DBMail?
Post #1473393
Posted Tuesday, July 16, 2013 3:17 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 6:22 AM
Points: 271, Visits: 96
Nice to read.......
thinking in a new way :)
Post #1474037
« Prev Topic | Next Topic »

Add to briefcase «««23456

Permissions Expand / Collapse