Aha. Looks like I just run the upgrade on the Developer edition to bring it up to standard, this should also upgrade the shared components. If I'm incorrect...

Thank you.

What would be the approach to change? Can I just run installer and install them for standard, or do I have to uninstall them for developer...

Thanks for the input and advice. In my case, the application is a 3rd party tool. I think I pretty much need all of it to be available at...

Thanks again - much appreciated!

Thanks - I have tried this and it seems to work exactly as intended!

Would you suggest I use the approach of creating the third table to act as the...

I tried the new code but unfortunately it did not work. I got a message in my application that 'the record could not be modified because it had been...

This compiles OK but I confess that I don't really understand what it is doing. I appreciate your help - I will try this out, probably over the weekend,...

I was able to get a working set of code with this entry:

ALTER TRIGGER [dbo].[UPDATE_EMAIL_IN_HEAT] ON [dbo].[CONTSUPP]

FOR DELETE

AS

DECLARE @ci VARBINARY(128)

--next line had to be a separate...

When I put this code into the trigger section:

ALTER TRIGGER [dbo].[UPDATE_EMAIL_IN_HEAT] ON [dbo].[CONTSUPP]

FOR DELETE

AS

DECLARE @ci VARBINARY(128) = CAST(DB_NAME() AS VARBINARY(128));

-- Check if anything has already set...

Yes, two way checking is needed - deletes could start in either database, i want to have the second trigger not fire if the first one has already fired, otherwise...

How would the context setting be placed? For example, should it work if my first trigger (modify stmt) starts out like this:

======

ALTER TRIGGER [dbo].[UPDATE_EMAIL_IN_HEAT] ON [dbo].[CONTSUPP]

FOR DELETE...

Here's some context. The T-SQL for altering the existing trigger has this block of code:

========

ALTER TRIGGER [dbo].[UPDATE_EMAIL_IN_HEAT] ON [dbo].[CONTSUPP]

FOR DELETE

AS

BEGIN TRANSACTION

IF @@NESTLEVEL > 1...

I was just copying a snippet I saw somewhere else. If you think it will work without the BEGIN and END I will try that.