Hi

How do i send an sms using SQL server 2005 Notification services.

If possible i will need full details as I have only gone through tutorials.

Thanks
Sanjeev

Hi
I have not used NS too much , but you can write a service by using .NET
to send sms, cannot you?



"Sanjeev Rampersad" <sanjeevr@sqr.com> wrote in message
news:unE%23rvaEJHA.3488@TK2MSFTNGP02.phx.gbl...
> Hi
>
> How do i send an sms using SQL server 2005 Notification services.
>
> If possible i will need full details as I have only gone through
> tutorials.
>
> Thanks
> Sanjeev
>
>

not familiar with .NET am afraid.

Would like to know if anybody knows how to SMS with
Notification services.

"Uri Dimant" <urid@iscar.co.il> wrote in message
news:OnC9V0aEJHA.4904@TK2MSFTNGP06.phx.gbl...
> Hi
> I have not used NS too much , but you can write a service by using .NET
> to send sms, cannot you?
>
>
>
> "Sanjeev Rampersad" <sanjeevr@sqr.com> wrote in message
> news:unE%23rvaEJHA.3488@TK2MSFTNGP02.phx.gbl...
>> Hi
>>
>> How do i send an sms using SQL server 2005 Notification services.
>>
>> If possible i will need full details as I have only gone through
>> tutorials.
>>
>> Thanks
>> Sanjeev
>>
>>
>
>

I would suggest using alternative means, since Notification Services is
discontinued and will not be supported in future versions (you won't use SQL
Server 2005 forever, will you?).

Most phones will accept text messages by sending e-mail to <number>@<service
domain>. If your phone(s) work this way then I would suggest using Database
Mail for these messages.


On 9/8/08 10:23 AM, in article OqkhC6bEJHA.768@TK2MSFTNGP05.phx.gbl,
"Sanjeev Rampersad" <sanjeevr@sqr.com> wrote:

> not familiar with .NET am afraid.
>
> Would like to know if anybody knows how to SMS with
> Notification services.
>
> "Uri Dimant" <urid@iscar.co.il> wrote in message
> news:OnC9V0aEJHA.4904@TK2MSFTNGP06.phx.gbl...
>> Hi
>> I have not used NS too much , but you can write a service by using .NET
>> to send sms, cannot you?
>>
>>
>>
>> "Sanjeev Rampersad" <sanjeevr@sqr.com> wrote in message
>> news:unE%23rvaEJHA.3488@TK2MSFTNGP02.phx.gbl...
>>> Hi
>>>
>>> How do i send an sms using SQL server 2005 Notification services.
>>>
>>> If possible i will need full details as I have only gone through
>>> tutorials.
>>>
>>> Thanks
>>> Sanjeev
>>>
>>>
>>
>>
>
>

Thanks,

What are the different alternatives?
I assume if it works with DB mail, it could also work using SQL RS Email
Subsciptions ?
And can it also be done using .Net ?

"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:C4EACD85.11CC5%ten.xoc@dnartreb.noraa...
>I would suggest using alternative means, since Notification Services is
> discontinued and will not be supported in future versions (you won't use
> SQL
> Server 2005 forever, will you?).
>
> Most phones will accept text messages by sending e-mail to
> <number>@<service
> domain>. If your phone(s) work this way then I would suggest using
> Database
> Mail for these messages.
>
>
> On 9/8/08 10:23 AM, in article OqkhC6bEJHA.768@TK2MSFTNGP05.phx.gbl,
> "Sanjeev Rampersad" <sanjeevr@sqr.com> wrote:
>
>> not familiar with .NET am afraid.
>>
>> Would like to know if anybody knows how to SMS with
>> Notification services.
>>
>> "Uri Dimant" <urid@iscar.co.il> wrote in message
>> news:OnC9V0aEJHA.4904@TK2MSFTNGP06.phx.gbl...
>>> Hi
>>> I have not used NS too much , but you can write a service by using
>>> .NET
>>> to send sms, cannot you?
>>>
>>>
>>>
>>> "Sanjeev Rampersad" <sanjeevr@sqr.com> wrote in message
>>> news:unE%23rvaEJHA.3488@TK2MSFTNGP02.phx.gbl...
>>>> Hi
>>>>
>>>> How do i send an sms using SQL server 2005 Notification services.
>>>>
>>>> If possible i will need full details as I have only gone through
>>>> tutorials.
>>>>
>>>> Thanks
>>>> Sanjeev
>>>>
>>>>
>>>
>>>
>>
>>
>

Database Mail, SQL Mail, xp_smtp_sendmail from www.sqldev.net

I would recommend Database Mail. I don't see why you need to get reporting
services or .net involved to send an e-mail.



On 9/9/08 2:13 AM, in article #1Yy2MkEJHA.3616@TK2MSFTNGP02.phx.gbl,
"Sanjeev Rampersad" <sanjeevr@sqr.com> wrote:

> Thanks,
>
> What are the different alternatives?
> I assume if it works with DB mail, it could also work using SQL RS Email
> Subsciptions ?
> And can it also be done using .Net ?
>
> "Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
> news:C4EACD85.11CC5%ten.xoc@dnartreb.noraa...
>> I would suggest using alternative means, since Notification Services is
>> discontinued and will not be supported in future versions (you won't use
>> SQL
>> Server 2005 forever, will you?).
>>
>> Most phones will accept text messages by sending e-mail to
>> <number>@<service
>> domain>. If your phone(s) work this way then I would suggest using
>> Database
>> Mail for these messages.
>>
>>
>> On 9/8/08 10:23 AM, in article OqkhC6bEJHA.768@TK2MSFTNGP05.phx.gbl,
>> "Sanjeev Rampersad" <sanjeevr@sqr.com> wrote:
>>
>>> not familiar with .NET am afraid.
>>>
>>> Would like to know if anybody knows how to SMS with
>>> Notification services.
>>>
>>> "Uri Dimant" <urid@iscar.co.il> wrote in message
>>> news:OnC9V0aEJHA.4904@TK2MSFTNGP06.phx.gbl...
>>>> Hi
>>>> I have not used NS too much , but you can write a service by using
>>>> .NET
>>>> to send sms, cannot you?
>>>>
>>>>
>>>>
>>>> "Sanjeev Rampersad" <sanjeevr@sqr.com> wrote in message
>>>> news:unE%23rvaEJHA.3488@TK2MSFTNGP02.phx.gbl...
>>>>> Hi
>>>>>
>>>>> How do i send an sms using SQL server 2005 Notification services.
>>>>>
>>>>> If possible i will need full details as I have only gone through
>>>>> tutorials.
>>>>>
>>>>> Thanks
>>>>> Sanjeev
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>
>