So, what can be used as a tracking table? We have a partition on a measure
group that includes the last 7 days worth of data and it is updated through
our ETL every 15 minutes. I can't watch the fact table directly because there
are multiple inserts and updates that occur. So, at the end of the ETL
process, we write a single record out to a "logging" table and I am watching
that table to kick off the processing. The problem is that when the record is
written, we get the notification but also a fairly generic error that says:

"Errors in the high-level relational engine. While a SQL trace was being
read, the following notification error occurred: [status = 1]. Trace: The SQL
Server notification read operation failed. SQL Trace status code: 0."

I don't know if this is relevant but the "logging" table that has the single
record written to it at the end of the ETL is in a different DB and for some
reason I can't select any of the table in that DB, so I've created a view in
the database that the rest of the tables are in and I'm using that as a
tracking table.

Any ideas on the generic error message? I should be able to watch a table
other than the fact table to begin the processing on the fact table shouldn't
I?

Thanks,
John Williams