Poison Message Question

I know I have to build in some ability to deal with a posion message. I was thinking that (sort of mentioned in the article http://msdn2.microsoft.com/en-us/library/ms166137.aspx) I would write a special stored procedure that would handle this situation. I don't know how I could activate this. I don't want to poll of course in a waitfor.

Does anyone have a good idea on this?

When a poison message is detected and a queue is disabled, an event notification is also fired. To subscribe to this event, create an event notification:

CREATE EVENT NOTIFICATION [QueueDisabled]

ON QUEUE [<queue name>]

FOR BROKER_QUEUE_DISABLED

TO SERVICE 'QueueDisabledServiceHandler', 'current database';

You can nou implment the procedure as an activated procedure on the queue servicing the 'QueueDisabledServiceHandler' service. The event message body contains the name and schema of the queue being disabled because of a poison message.

HTH,
~ Remus

Pls help on data design

I am tring to build a large relational database as source for OLAP and it is running ok.

It is a financial transaction database accumulated with data of (1) Actuals in Jan 2005, Feb 05... to Mar 06

(2) Budgeted numbers in Jan 2005, Feb 05... to Mar 06

An example is like this:-

Table A - actuals

Date/Product/Sales value

Table B - Budget

Date/Product/Sales value

However, one last trouble is regarding the time dimension,.

What is the best way to assign the time value to each transaction so that I can:-

(1) Compare aggregated Jan 06 with Jan 05 easily ?

(2) Compare aggregated Feb 06 with Jan 06 easily ?

(3) Compare actual vs budget easily ?

For example, if date is 23 Jan 2006, should I make 2 more columns, month & year, ie assign values 1 and 2006 ?

Also, should I create 2 columns of value fields, "Actual" and "budget", or should I create one single data value, but added one more domension, "status" for example and asiign "Actual" or "budget" to each transaction ?

Help...

Assuming that you're using AS 2005, you can get some ideas by looking at the Adventure Works cube - Financial Reporting measure group (just 1 measure: Amount) and Scenario dimension (3 members: Actual, Budget and Forecast). Defining Time Intelligence permits various time-based comparisons, such as the ones you mentioned:

http://msdn2.microsoft.com/en-us/library/ms175440(SQL.90).aspx

>>

Defining Time Intelligence (SSAS)

The time intelligence enhancement is a cube enhancement that adds time calculations (or time views) to a selected hierarchy. This enhancement supports the following categories of calculations:

Period to date.
Period over period growth.
Moving averages.
Parallel period comparisons.

Please help, urgent...Some question for SQL compact edition.

My client has a system and a IBM db to store the data. I try to build sub-system window mobile application for data entery. But my client do not want to install active sync.

So our team figure a way out of this case. We create a web program to get data from IBM db, then create a .sdf file for the PDA. In the PDA, we install a software to make it become USB mass storage. The web program will copy the sdf file to PDA.

I want to know, is this a possible solution? If so, how to creat that web program to get those data and create .sdf file?

Use middleware from IBM to get the data from the IBM DB, and the SqlCeClient objects to create and populate the SDF file. You can do this with asp.net. You must also create a desktop program to download the sdf file from the web server and copy to the USB mass strorage.
What are your requirements for submitting data the other way - it will be difficult without network connectivity from the device ?|||I want to use the middleware to do the same thing which allow to get data and submitting data. Is that possible?...