Alert from addition to table

13 Aug 2005 11:43 AM

tony wong

The SMS provider will update my SQL server when there is incoming SMS
message.

apart from regular manual check on table

how can i know there is incoming new SMS message?

alert by email? any guidance?

Thanks.

Tony

13 Aug 2005 1:25 PM

GregO

Hi Tony,
You can have a trigger on the table that sends you an email

--
kind regards
Greg O
Need to document your databases. Use the firs and still the best AGS SQL
Scribe
http://www.ag-software.com

Show quote

"tony wong" <x**@netvigator.com> wrote in message
news:%23nRYnw$nFHA.1148@TK2MSFTNGP12.phx.gbl...
> The SMS provider will update my SQL server when there is incoming SMS
> message.
>
> apart from regular manual check on table
>
> how can i know there is incoming new SMS message?
>
> alert by email? any guidance?
>
> Thanks.
>
> Tony
>

13 Aug 2005 1:38 PM

tony wong

Hi Greg

Could i have some hints on that? i am new on programming.

my primary thought is to write exe to check any new SMS and then send email
via smtp, and run it in Windows Scheduler.

Any better methods? Thanks

Tony

Show quote

"GregO" <grego@community.nospam> ¼¶¼g©ó¶l¥ó·s»D:edQ1fnAoFHA.1***@tk2msftngp13.phx.gbl...
> Hi Tony,
> You can have a trigger on the table that sends you an email
>
>
> --
> kind regards
> Greg O
> Need to document your databases. Use the firs and still the best AGS SQL
> Scribe
> http://www.ag-software.com
> "tony wong" <x**@netvigator.com> wrote in message
> news:%23nRYnw$nFHA.1148@TK2MSFTNGP12.phx.gbl...
>> The SMS provider will update my SQL server when there is incoming SMS
>> message.
>>
>> apart from regular manual check on table
>>
>> how can i know there is incoming new SMS message?
>>
>> alert by email? any guidance?
>>
>> Thanks.
>>
>> Tony
>>
>
>