And here they are... the 5 sp's that I get for this table:
CREATE TABLE [dbo].[test_for_replication](
[id] [int] NOT NULL PRIMARY KEY,
[name] [varchar](30) NOT NULL,
[description] [varchar](255) NOT NULL)
The ones being used are:
sp_MSdel_dbotest_for_replication
sp_MSins_dbotest_for_replication
sp_MSupd_dbotest_for_replication
The seemingly superfluous ones are:
sp_MSdel_dbotest_for_replication_msrepl_ccs
sp_MSins_dbotest_for_replication_msrepl_ccs
Here are the create proc scripts for all of them:
CREATE procedure [dbo].[sp_MSdel_dbotest_for_replication]
@pkc1 int
as
begin
delete "dbo"."test_for_replication"
where "id" = @pkc1
if @@rowcount = 0
if @@microsoftversion>0x07320000
exec sp_MSreplraiserror 20598
end
create procedure [dbo].[sp_MSdel_dbotest_for_replication_msrepl_ccs]
@pkc1 int
as
begin
delete "dbo"."test_for_replication"
where "id" = @pkc1
end
create procedure [dbo].[sp_MSins_dbotest_for_replication]
@c1 int,@c2 varchar(30),@c3 varchar(255)
as
begin
insert into "dbo"."test_for_replication"(
"id"
,"name"
,"description"
)
values (
@c1
,@c2
,@c3
)
end
create procedure [dbo].[sp_MSins_dbotest_for_replication_msrepl_ccs]
@c1 int,@c2 varchar(30),@c3 varchar(255)
as
begin
if exists ( select * from "dbo"."test_for_replication"
where "id" = @c1
)
begin
update "dbo"."test_for_replication" set
"name" = @c2
,"description" = @c3
where "id" = @c1
end
else
begin
insert into "dbo"."test_for_replication"(
"id"
,"name"
,"description"
)
values (
@c1
,@c2
,@c3
)
end
end
create procedure [dbo].[sp_MSupd_dbotest_for_replication]
@c1 int = null,@c2 varchar(30) = null,@c3 varchar(255) = null,@pkc1 int
,@bitmap binary(1)
as
begin
if ( substring(@bitmap,1,1) & 1 = 1 )
begin
update "dbo"."test_for_replication" set
"id" = case substring(@bitmap,1,1) & 1 when 1 then @c1 else "id" end
,"name" = case substring(@bitmap,1,1) & 2 when 2 then @c2 else "name" end
,"description" = case substring(@bitmap,1,1) & 4 when 4 then @c3 else "description" end
where "id" = @pkc1
if @@rowcount = 0
if @@microsoftversion>0x07320000
exec sp_MSreplraiserror 20598
end
else
begin
update "dbo"."test_for_replication" set
"name" = case substring(@bitmap,1,1) & 2 when 2 then @c2 else "name" end
,"description" = case substring(@bitmap,1,1) & 4 when 4 then @c3 else "description" end
where "id" = @pkc1
if @@rowcount = 0
if @@microsoftversion>0x07320000
exec sp_MSreplraiserror 20598
end
end