Hi,
I have created sp
Create Procedure sp_SMTPMail

    @SenderName varchar(100),
    @SenderAddress varchar(100),
    @RecipientName varchar(100),
    @RecipientAddress varchar(100),
    @Subject varchar(200),
    @Body varchar(8000),
    @MailServer varchar(100) = 'localhost'

    AS
    SET nocount on
    declare @oMail int --Object reference
    declare @resultcode int
    EXEC @resultcode = sp_OACreate 'SMTPsvg.Mailer', @oMail OUT
    if @resultcode = 0
    BEGIN
        EXEC @resultcode = sp_OASetProperty @oMail, 'RemoteHost', @mailserver
        EXEC @resultcode = sp_OASetProperty @oMail, 'FromName', @SenderName
        EXEC @resultcode = sp_OASetProperty @oMail, 'FromAddress', @SenderAddress
        EXEC @resultcode = sp_OAMethod @oMail, 'AddRecipient', NULL, @RecipientName, @RecipientAddress
        EXEC @resultcode = sp_OASetProperty @oMail, 'Subject', @Subject
        EXEC @resultcode = sp_OASetProperty @oMail, 'BodyText', @Body
        EXEC @resultcode = sp_OAMethod @oMail, 'SendMail', NULL
        EXEC sp_OADestroy @oMail
    END
    SET nocount off
GO

And trying to execute it
exec sp_SMTPMail @SenderName='Test1', @SenderAddress='[email protected]',
@RecipientName = 'prayadavdeloitte.com', @RecipientAddress = '[email protected]',
@Subject='SQL Test', @Body='Hello, this is a test email from SQL Server'

query is getting executed bt i m nt receiving my mail.
Can any one help me.