Thanks for your response Gail. Looks like a sensible thing to do.

Can anybody advise me on where to look to find out what the latest version of the BIDS Reporting...

Amazing!

smunson's response features two T-SQL functionalities I've never seen before (That's a lot for a single post!)

The ;WITH construct to make a Common Table Expression (CTE) is a really interesting...

🙂

Hi again all,

I get

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, = or when the subquery is used as an expression.

when...

Great! Didn't know you could do that.

Thanks a lot for the super-fast response too!

Rob

Thanks all for your responses.

My final decision was just not to be lazy.

I've put separate triggers on each table, logging to separate "Deleted" tables, and can now do the join...

Hi again,

you're absolutely right, well spotted.

The trigger is running, but not doing what I expected.

Inside the trigger I'm trying to join to something which has already been deleted, so the...

Hi Ian,

thanks a lot for the super-fast response!

Nested Triggers:

Min: 0

Max: 1

config_value: 1

run_value: 1

I assume this means it's enabled?

Hi Michael,

thanks for such a quick response.

The reason I didn't think this was where the solution lay was because of this quote from Books Online (Creating and Applying the snapshot):

After...