(@publisher_database_id, @3originator, @3originator_db) select @originator_id = @@identity end end else select @originator_id = 0 if( @type in( 37,38 ) ) begin select @syncstat = 38 - @3type exec sp_MSset_syncstate @publisher_id, @publisher_db, @3article_id, @syncstat, @3xact_seqno end INSERT INTO MSrepl_commands VALUES (@publisher_database_id, @3xact_seqno,@3type, @3article_id, @originator_id, @3command_id, @3partial_command, @3command) end IF @4xact_id = 0x0 return IF @4command IS NOT NULL begin if @4originator <> N'' and @4originator_db <> N'' and @4originator is not null and @4originator_db is not null begin set @originator_id = null select @originator_id = id from MSrepl_originators where publisher_database_id = @publisher_database_id and UPPER(srvname) = UPPER(@4originator) and dbname = @4originator_db if @originator_id is null begin insert into MSrepl_originators (publisher_database_id, srvname, dbname) values (@publisher_database_id, @4originator, @4originator_db) select @originator_id = @@identity end end else select @originator_id = 0 if( @type in( 37,38 ) ) begin select @syncstat = 38 - @4type exec sp_MSset_syncstate @publisher_id, @publisher_db, @4article_id, @syncstat, @4xact_seqno end INSERT INTO MSrepl_commands VALUES (@publisher_database_id, @4xact_seqno,@4type, @4article_id, @originator_id, @4command_id, @4partial_command, @4command) end IF @5xact_id = 0x0 return IF @5command IS NOT NULL begin if @5originator <> N'' and @5originator_db <> N'' and @5originator is not null and @5originator_db is not null begin set @originator_id = null select @originator_id = id from MSrepl_originators where publisher_database_id = @publisher_database_id and UPPER(srvname) = UPPER(@5originator) and dbname = @5originator_db if @originator_id is null begin insert into MSrepl_originators (publisher_database_id, srvname, dbname) values (@publisher_database_id, @5originator, @5originator_db) select @originator_id = @@identity end end else select @originator_id = 0 if( @type in( 37,38 ) ) begin select @syncstat = 38 - @5type exec sp_MSset_syncstate @publisher_id, @publisher_db, @5article_id, @syncstat, @5xact_seqno end INSERT INTO MSrepl_commands VALUES (@publisher_database_id, @5xact_seqno,@5type, @5article_id, @originator_id, @5command_id, @5partial_command, @5command) end IF @6xact_id = 0x0 return IF @6command IS NOT NULL begin if @6originator <> N'' and @6originator_db <> N'' and @6originator is not null and @6originator_db is not null begin set @originator_id = null select @originator_id = id from MSrepl_originators where publisher_database_id = @publisher_database_id and UPPER(srvname) = UPPER(@6originator) and dbname = @6originator_db if @originator_id is null begin insert into MSrepl_originators (publisher_database_id, srvname, dbname) values (@publisher_database_id, @6originator, @6originator_db) select @originator_id = @@identity end end else select @originator_id = 0 if( @type in( 37,38 ) ) begin select @syncstat = 38 - @6type exec sp_MSset_syncstate @publisher_id, @publisher_db, @6article_id, @syncstat, @6xact_seqno end INSERT INTO MSrepl_commands VALUES (@publisher_database_id, @6xact_seqno,@6type, @6article_id, @originator_id, @6command_id, @6partial_command, @6command) end IF @7xact_id = 0x0 return IF @7command IS NOT NULL begin if @7originator <> N'' and @7originator_db <> N'' and @7originator is not null and @7originator_db is not null begin set @originator_id = null select @originator_id = id from MSrepl_originators where publisher_database_id = @publisher_database_id and UPPER(srvname) = UPPER(@7originator) and dbname = @7originator_db if @originator_id is null begin insert into MSrepl_originators (publisher_database_id, srvname, dbname) values (@publisher_database_id, @7originator, @7originator_db) select @originator_id = @@identity end end else select @originator_id = 0 if( @type in( 37,38 ) ) begin select @syncstat = 38 - @7type exec sp_MSset_syncstate @publisher_id, @publisher_db, @7article_id, @syncstat, @7xact_seqno end INSERT INTO MSrepl_commands VALUES (@publisher_database_id, @7xact_seqno,@7type, @7article_id, @originator_id, @7command_id, @7partial_command, @7command) end IF @8xact_id = 0x0 return IF @8command IS NOT NULL begin if @8originator <> N'' and @8originator_db <> N'' and @8originator is not null and @8originator_db is not null begin set @originator_id = null select @originator_id = id from MSrepl_originators where publisher_database_id = @publisher_database_id and UPPER(srvname) = UPPER(@8originator) and dbname = @8originator_db if @originator_id is null begin insert into MSrepl_originators (publisher_database_id, srvname, dbname) values (@publisher_database_id, @8originator, @8originator_db) select @originator_id = @@identity end end else select @originator_id = 0 if( @type in( 37,38 ) ) begin select @syncstat = 38 - @8type exec sp_MSset_syncstate @publisher_id, @publisher_db, @8article_id, @syncstat, @8xact_seqno end INSERT INTO MSrepl_commands VALUES (@publisher_database_id, @8xact_seqno,@8type, @8article_id, @originator_id, @8command_id, @8partial_command, @8command) end IF @9xact_id = 0x0 return IF @9command IS NOT NULL begin if @9originator <> N'' and @9originator_db <> N'' and @9originator is not null and @9originator_db is not null begin set @originator_id = null select @originator_id = id from MSrepl_originators where publisher_database_id = @publisher_database_id and UPPER(srvname) = UPPER(@9originator) and dbname = @9originator_db if @originator_id is null begin insert into MSrepl_originators (publisher_database_id, srvname, dbname) values (@publisher_database_id, @9originator, @9originator_db) select @originator_id = @@identity end end else select @originator_id = 0 if( @type in( 37,38 ) ) begin select @syncstat = 38 - @9type exec sp_MSset_syncstate @publisher_id, @publisher_db, @9article_id, @syncstat, @9xact_seqno end INSERT INTO MSrepl_commands VALUES (@publisher_database_id, @9xact_seqno,@9type, @9article_id, @originator_id, @9command_id, @9partial_command, @9command) end IF @10xact_id = 0x0 return IF @10command IS NOT NULL begin if @10originator <> N'' and @10originator_db <> N'' and @10originator is not null and @10originator_db is not null begin set @originator_id = null select @originator_id = id from MSrepl_originators where publisher_database_id = @publisher_database_id and UPPER(srvname) = UPPER(@10originator) and dbname = @10originator_db if @originator_id is null begin insert into MSrepl_originators (publisher_database_id, srvname, dbname) values (@publisher_database_id, @10originator, @10originator_db) select @originator_id = @@identity end end else select @originator_id = 0 if( @type in( 37,38 ) ) begin select @syncstat = 38 - @10type exec sp_MSset_syncstate @publisher_id, @publisher_db, @10article_id, @syncstat, @10xact_seqno end INSERT INTO MSrepl_commands VALUES (@publisher_database_id, @10xact_seqno,@10type, @10article_id, @originator_id, @10command_id, @10partial_command, @10command) end IF @11xact_id = 0x0 return IF @11command IS NOT NULL begin if @11originator <> N'' and @11originator_db <> N'' and @11originator is not null and @11originator_db is not null begin set @originator_id = null select @originator_id = id from MSrepl_originators where publisher_database_id = @publisher_database_id and UPPER(srvname) = UPPER(@11originator) and dbname = @11originator_db if @originator_id is null begin insert into MSrepl_originators (publisher_database_id, srvname, dbname) values (@publisher_database_id, @11originator, @11originator_db) select @originator_id = @@identity end end else select @originator_id = 0 if( @type in( 37,38 ) ) begin select @syncstat = 38 - @11type exec sp_MSset_syncstate @publisher_id, @publisher_db, @11article_id, @syncstat, @11xact_seqno end INSERT INTO MSrepl_commands VALUES (@publisher_database_id, @11xact_seqno,@11type, @11article_id, @originator_id, @11command_id, @11partial_command, @11command) end IF @12xact_id = 0x0 return IF @12command IS NOT NULL begin if @12originator <> N'' and @12originator_db <> N'' and @12originator is not null and @12originator_db is not null begin set @originator_id = null select @originator_id = id from MSrepl_originators where publisher_database_id = @publisher_database_id and UPPER(srvname) = UPPER(@12originator) and dbname = @12originator_db if @originator_id is null begin insert into MSrepl_originators (publisher_database_id, srvname, dbname) values (@publisher_database_id, @12originator, @12originator_db) select @originator_id = @@identity end end else select @originator_id = 0 if( @type in( 37,38 ) ) begin select @syncstat = 38 - @12type exec sp_MSset_syncstate @publisher_id, @publisher_db, @12article_id, @syncstat, @12xact_seqno end INSERT INTO MSrepl_commands VALUES (@publisher_database_id, @12xact_seqno,@12type, @12article_id, @originator_id, @12command_id, @12partial_command, @12command) end IF @13xact_id = 0x0 return IF @13command IS NOT NULL begin if @13originator <> N'' and @13originator_db <> N'' and @13originator is not null and @13originator_db is not null begin set @originator_id = null select @originator_id = id from MSrepl_originators where publisher_database_id = @publisher_database_id and UPPER(srvname) = UPPER(@13originator) and dbname = @13originator_db if @originator_id is null begin insert into MSrepl_originators (publisher_database_id, srvname, dbname) values (@publisher_database_id, @13originator, @13originator_db) select @originator_id = @@identity end end else