Configuring Email in SQL Server Express

Its a known issue that SQL Server express edition wont support Email . TO overcome this we can use CLR based email stored procedure.   Step 1 : Compile the VB code and convert as a dll. Code : Imports System.Net.Mail Public Class StoredProcedure <Microsoft.SqlServer.Server.SqlProcedure()> _ Public Shared Sub spSendMail(ByVal recipients As String, ByVal subject As String, ByVal from As String, ByVal body As String) Dim mySmtpClient As SmtpClient Using myMessage As New MailMessage(from, recipients) myMessage.Subject = subject myMessage.Body = body myMessage.IsBodyHtml = True mySmtpClient = New SmtpClient(“smtp.zxvzxvxzvx.com”) mySmtpClient.Credentials = New System.Net.NetworkCredential(“haneef@xcxzvcxzvz.com”, “vzxvxzvxzvz”) mySmtpClient.Send(myMessage) End Using End Sub End Class Step 2: Replace these 2 lines with your smtp username , password amd smtp server adress mySmtpClient = New SmtpClient(“smtpxxxxxxxx.com”) mySmtpClient.Credentials = New System.Net.NetworkCredential(“haneef@xxxxxxxx.com”, “Password”) Save the above file in d:\sendmail.vb Step 3: Complie the code using below command.   C:\Windows\system32>C:\Windows\Microsoft.NET\Framework\v4.0.30319\vbc /target:li brary D:\sendmail.vb The above will comile and create a file sendmail.dll in the same location. Step 4: Run this command in SQL management studio ALTER DATABASE msdb SET trustworthy ON Step 5: Create the assembly in SQL management studio   USE msdb GO CREATE ASSEMBLY SendEmail FROM ‘C:\SendEmail.dll’ WITH PERMISSION_SET = UNSAFE GO Step 6: Enable CLR sp_configure […]

» Read more

c++ function to return mnm of 2 numbers

Condition : numbers should asked when function is executed:   #include <iostream> using namespace std; int minnummber() { // local variable declaration int result, num1, num2; cout << “Enter first number :: “; cin >> num1; cout << “Enter second number :: “; cin >> num2; if (num1 > num2) result = num2; else result = num1; return result; } int main () { cout << “Min is “<<minnummber(); return 0; }

» Read more

C++ Program to Average of 7 Numbers, Average of Odd Numbers and Average of Even numbers

#include <iostream> #include <string> using namespace std; int main() { int numb; float oddcount =0; float evencount = 0; float oddsum = 0; float evensum = 0; float allsum = 0; for (int k =1; k <= 7 ; k++) { cout << “Enter Number ::”<<k << endl; cin >> numb ; allsum = allsum + numb; while( numb % 2 == 0) { evencount = evencount+1; evensum = evensum + numb; break; } while( numb % 2 != 0) { oddcount = oddcount+1; oddsum = oddsum + numb; break; } } cout << “Average of All ::”<<allsum / 7 << endl; if (evencount != 0 ) cout << “Average of Even Numbers ::”<<evensum / evencount << endl; else cout << “No Even Numbers entered”<< endl; if (oddcount != 0) cout << “Average of Odd Numbers ::”<<oddsum / oddcount << endl; else cout << “No Odd Numbers entered”<< endl; }

» Read more