Alert from addition to table

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.
TonyHi 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" <x34@.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
>|||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
"GregO" <grego@.community.nospam> glsD:edQ1fnAoFHA.1048@.tk2msftngp13.phx.gbl...[co
lor=darkred]
> 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" <x34@.netvigator.com> wrote in message
> news:%23nRYnw$nFHA.1148@.TK2MSFTNGP12.phx.gbl...
>[/color]sql

Aggregation Problem with Hours and Minutes in Time Dimension

For the first time, I have created a time dimension that includes hours and minutes, in addition to the Year, Quarter, Month, and Date that I am familiar with.

I want to display the average of my measures at whatever level of Time the user chooses. I thus chose "AverageOfChildren" as the aggregation method for these measures.

Unfortunately, SSAS aggregates these measures by Sum over Hours and Minutes, and then by AverageOfChildren over Date, Month, Quarter, and Year.

I am confused.

How can I force it to perform an "AverageOfChildren" at all levels ?

First, have a look at this document(http://www.microsoft.com/technet/prodtechnol/sql/2005/realastd.mspx) and think about your design a second time(on page 34-35 in the word version)

Next. This is only a guess but how are your attribute relations between minutes, hours, date,quarter and year defined, if they are included in the same user hierarchy?

HTH

Thomas Ivarsson