tag:blogger.com,1999:blog-1391695206712094920.post3637923680482935254..comments2023-08-22T08:29:12.843-07:00Comments on Learning Microsoft Technologies.......: .Net Components(CLR) Integration with SQL ServerUma Shankar Patelhttp://www.blogger.com/profile/02287010306811895923noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-1391695206712094920.post-50096690639821539392013-09-03T23:10:23.522-07:002013-09-03T23:10:23.522-07:00Yes,
I post in another blog post.
http://www.query...Yes,<br />I post in another blog post.<br />http://www.queryingsql.com/2013/09/sending-mail-using-sql-server-express.htmlUma Shankar Patelhttps://www.blogger.com/profile/02287010306811895923noreply@blogger.comtag:blogger.com,1999:blog-1391695206712094920.post-54925230216283596812013-09-03T12:09:34.651-07:002013-09-03T12:09:34.651-07:00But I discuss,there is no database mail functional...But I discuss,there is no database mail functionality in Express edition.<br /><br />Please try that solution and then say if it didn't work! I use this on SQL server 2005/2008/2008 R2 Express edition without any problems.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1391695206712094920.post-75004450806306996872013-09-02T02:57:56.005-07:002013-09-02T02:57:56.005-07:00Yes we can do this.This is using SQL mail.
But I d...Yes we can do this.This is using SQL mail.<br />But I discuss,there is no database mail functionality in Express edition as SQL server enterprise and standered edition.<br />Any way thanks for sharing.Uma Shankar Patelhttps://www.blogger.com/profile/02287010306811895923noreply@blogger.comtag:blogger.com,1999:blog-1391695206712094920.post-61598660415843099752013-09-02T02:33:01.410-07:002013-09-02T02:33:01.410-07:00It's not true, SQL server database mail featur...It's not true, SQL server database mail feature is present in SQL server express edition ! But it is hidden in SSMS, you have to use t-sql commands:<br /><br />-- database mail account<br />EXECUTE msdb.dbo.sysmail_add_account_sp<br /> @account_name = 'Backup',<br /> @description = 'Mail account for Database Mail',<br /> @email_address = 'email@server.com',<br /> @display_name = 'Backup',<br /> @username='notifyadmin@zoznam.sk',<br /> @password='heslo123456',<br /> @mailserver_name = '213.81.185.97'<br /><br />-- database profile<br />EXECUTE msdb.dbo.sysmail_add_profile_sp<br /> @profile_name = 'Backup',<br /> @description = 'Profile used for database mail'<br /><br />-- account to profile<br />EXECUTE msdb.dbo.sysmail_add_profileaccount_sp<br /> @profile_name = 'Backup',<br /> @account_name = 'Backup',<br /> @sequence_number = 1<br /><br />-- principal profile<br />EXECUTE msdb.dbo.sysmail_add_principalprofile_sp<br /> @profile_name = 'Backup',<br /> @principal_name = 'public',<br /> @is_default = 1 ;<br /><br />/* update records<br />SELECT *<br />FROM sysmail_account<br />GO<br /><br />EXECUTE msdb.dbo.sysmail_update_account_sp @account_name = 'Backup',<br />@display_name='Server example'*/<br /><br />-- send mail:<br />exec msdb.dbo.sp_send_dbmail @profile_name = 'Backup', @recipients = 'email1@server.com;email2@server.com', @subject = @subject_failed, @body = @mailstring, @body_format = 'text'<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1391695206712094920.post-58435863510397061102013-08-27T13:08:43.542-07:002013-08-27T13:08:43.542-07:00Very easy to follow instructions. ThanksVery easy to follow instructions. ThanksHomerhttps://www.blogger.com/profile/12997295079646255657noreply@blogger.com