Prev: Arithabort
Next: Migrating from MsAccess to MS SQL
From: Hemant on 19 Apr 2010 10:10
Hi,

I have moved my database sql server 2000 to sql server 2008 and on 64 bit.
For mail I used xp_smtp_sendmail but this is not working in sql server 2008
..
Please suggest me alternative for this

Thanks,
Hemant



From: Shiju Samuel on 19 Apr 2010 10:26
You should use sp_send_dbmail

http://msdn.microsoft.com/en-us/library/ms190307.aspx

before doing this you should configure a mail profile

http://msdn.microsoft.com/en-us/library/ms189879.aspx

Hemant wrote:

> Hi,
>
> I have moved my database sql server 2000 to sql server 2008 and on 64
> bit. For mail I used xp_smtp_sendmail but this is not working in sql
> server 2008 . Please suggest me alternative for this
>
> Thanks,
> Hemant



--

From: Hemant on 21 Apr 2010 02:38
Thanks,


"Shiju Samuel" <Shiju.Samuel(a)gmail.com> wrote in message
news:uV$Pgx83KHA.3728(a)TK2MSFTNGP06.phx.gbl...
> You should use sp_send_dbmail
>
> http://msdn.microsoft.com/en-us/library/ms190307.aspx
>
> before doing this you should configure a mail profile
>
> http://msdn.microsoft.com/en-us/library/ms189879.aspx
>
> Hemant wrote:
>
>> Hi,
>>
>> I have moved my database sql server 2000 to sql server 2008 and on 64
>> bit. For mail I used xp_smtp_sendmail but this is not working in sql
>> server 2008 . Please suggest me alternative for this
>>
>> Thanks,
>> Hemant
>
>
>
> --
>


From: Hemant on 22 Apr 2010 02:07
Hi,

But one more problem is that I want to
Change "from" portion of the email when calling sp_send_dbmail.

Thanks,
Hemant
"Hemant" <Hemant(a)nomail.com> wrote in message
news:uMTdMzR4KHA.4952(a)TK2MSFTNGP02.phx.gbl...
> Thanks,
>
>
> "Shiju Samuel" <Shiju.Samuel(a)gmail.com> wrote in message
> news:uV$Pgx83KHA.3728(a)TK2MSFTNGP06.phx.gbl...
>> You should use sp_send_dbmail
>>
>> http://msdn.microsoft.com/en-us/library/ms190307.aspx
>>
>> before doing this you should configure a mail profile
>>
>> http://msdn.microsoft.com/en-us/library/ms189879.aspx
>>
>> Hemant wrote:
>>
>>> Hi,
>>>
>>> I have moved my database sql server 2000 to sql server 2008 and on 64
>>> bit. For mail I used xp_smtp_sendmail but this is not working in sql
>>> server 2008 . Please suggest me alternative for this
>>>
>>> Thanks,
>>> Hemant
>>
>>
>>
>> --
>>
>
>


 | 
Pages: 1
Prev: Arithabort
Next: Migrating from MsAccess to MS SQL