Yes. that's what's reporting uninitialized subscription.

doh! Thank you.

I accept I got it wrong, but what do you mean the second transaction fails? Only the insert null into the primary key field statement fails. There are no failed...

Okay but where does the numbering at the end of the underscores correspond to the spid that created it?

Hypothetically, lets say I wanted to see what spid owned each copy...

Thank you so much! And I learned about common table expressions today. 😉

I love SQL Server Central!

Yes. It should only update if there is exactly one match (eg. ZETA_RHO_23 could match ZETA and RHO, therefore no update, KATHUMPA_GORGANZOLA_6, no match, no update) and the list needs...

Like this?

create table #myTableOfProjectInstances(ProjectInstanceName varchar(1000), CorrespondingProjectName varchar(100))

insert into #myTableOfProjectInstances(ProjectInstanceName) values ('ALPHA_12')

insert into #myTableOfProjectInstances(ProjectInstanceName) values ('BETA_GAMMA_25')

insert into #myTableOfProjectInstances(ProjectInstanceName) values ('DELTA_PRODUCTION')

insert into #myTableOfProjectInstances(ProjectInstanceName) values ('TXEPSILON')

insert into #myTableOfProjectInstances(ProjectInstanceName) values ('ALPHA_26')

create table #myTableOfProjectsByName(ProjectName varchar(100))

insert...