CREATE UNIQUE INDEX IDX_PromoMeasure_PromotionType_AdType_DisplayType ON #PromoMeasure (PromotionType, AdType, DisplayType)

I've looked throughout the Account setup and I do not see that this has been made an option.  I too would like the autosubscribe functionality back.

First off, you'll need to be able to define what is valid and invalid data.  Can you expand on what you are looking for and include some data examples that...

If you think that you've already narrowed it down to possible blocking from long running queries, you can stop running the Windows Performance Monitor and focus more on SQL Profiler. ...

Can you post your procedure?

Can you post sample DDL and data along with the expected results from your sample data?  It would help if you epand on the tie breaker as well - include...

To second what Lowell has posted, all triggers should be written to handle multiple row operations.  The way you've written your trigger will only work with the last rows values...

Please do not cross post.  This thread should be continued here: http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=146&messageid=400521

This thread is being worked here:

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=360&messageid=400533

I would follw JDixon's advice.  Restore your full backup to another database.  DO NOT restore it over your production DB.  Then grab the rows that correspond to the 3 modfications...

If you are getting an error, it would sure help us help you to know what the error is.  Can you post the error syntax for us?  You are attempting...

Building on the example data I posted earlier, this should work for you.  Keep in mind that this type of JOIN assumes that there will not be any duplicate Nominee...

I would say the easiest way to find out is to try it.  It should work for you.

OK, adding a primary key onto these tables makes no difference to your query the way you have it written.  The 2 result sets you show (one before the PK...

Yes, it looks like you create a PK on both tables, but what I want to know is on which columns?  Look back at your original post.  It shows your PK...