Re: disable publishing and distribution error

Publication database. Check which databases are published for merge
replication and put it there.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:uyEq9AQBHHA.4672@xxxxxxxxxxxxxxxxxxxxxxx
Ok, which database are you creating sysmergepublications and
sysmergesubscriptions in ?

I've created sysmergesubscriptions in distribution , master , msdb ...

I still receive an error when I run

use master
exec sp_dropdistributor @no_checks = 1
go

I receive :

Msg 208, Level 16, State 1, Procedure sp_MSmergepublishdb, Line 103
Invalid object name 'dbo.sysmergesubscriptions'.



"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:%233PUslE$GHA.896@xxxxxxxxxxxxxxxxxxxxxxx
create table sysmergepublications
(
publisher sysname,
publisher_db sysname,
name sysname,
description nvarchar(510),
retention int,
publication_type tinyint,
pubid uniqueidentifier,
designmasterid uniqueidentifier,
parentid uniqueidentifier,
sync_mode tinyint,
allow_push int,
allow_pull int,
allow_anonymous int,
centralized_conflicts int,
status tinyint,
snapshot_ready tinyint,
enabled_for_internet bit,
dynamic_filters bit,
snapshot_in_defaultfolder bit,
alt_snapshot_folder nvarchar(510),
pre_snapshot_script nvarchar(510),
post_snapshot_script nvarchar(510),
compress_snapshot bit,
ftp_address sysname,
ftp_port int,
ftp_subdirectory nvarchar(510),
ftp_login sysname,
ftp_password nvarchar(1048),
conflict_retention int,
keep_before_values int,
allow_subscription_copy bit,
allow_synctoalternate bit,
validate_subscriber_info nvarchar(1000),
ad_guidname sysname,
backward_comp_level int,
max_concurrent_merge int,
max_concurrent_dynamic_snapshots int,
use_partition_groups smallint,
dynamic_filters_function_list nvarchar(1000),
partition_id_eval_proc sysname,
publication_number smallint,
replicate_ddl int,
allow_subscriber_initiated_snapshot bit,
distributor sysname,
snapshot_jobid binary(16),
allow_web_synchronization bit,
web_synchronization_url nvarchar(1000),
allow_partition_realignment bit,
retention_period_unit tinyint,
decentralized_conflicts int,
generation_leveling_threshold int,
automatic_reinitialization_policy bit
)

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:%23exvteE$GHA.4196@xxxxxxxxxxxxxxxxxxxxxxx
What is the tsql for creating sysmergepublications ?

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:O8kh0ZE$GHA.3480@xxxxxxxxxxxxxxxxxxxxxxx
OK, then try this

create table sysmergesubscriptions(
subscriber_server sysname,
db_name sysname,
pubid uniqueidentifier,
datasource_type int,
subid uniqueidentifier,
replnickname binary(6),
replicastate uniqueidentifier,
status tinyint,
subscriber_type int,
subscription_type int,
sync_type tinyint,
description nvarchar(510),
priority real,
recgen bigint,
recguid uniqueidentifier,
sentgen bigint,
sentguid uniqueidentifier,
schemaversion int,
schemaguid uniqueidentifier,
last_validated datetime,
attempted_validate datetime,
last_sync_date datetime,
last_sync_status int,
last_sync_summary sysname,
metadatacleanuptime datetime,
partition_id int,
cleanedup_unsent_changes int,
replica_version int,
supportability_mode int,
application_name sysname,
subscriber_number int

)



--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business
intelligence.

This posting is my own and doesn't necessarily represent
RelevantNoise's positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:%23t1joQE$GHA.924@xxxxxxxxxxxxxxxxxxxxxxx
Ok, that worked, but now I receive the following set of error messages
:

Msg 207, Level 16, State 1, Procedure sp_MSmergepublishdb, Line 104
Invalid column name 'subscriber_server'
Invalid column name 'db_name'
Invalid column name 'sub_id'
Invalid column name 'pub_id'

"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:O7m6YqK%23GHA.4468@xxxxxxxxxxxxxxxxxxxxxxx
Unpublish all of your user databases doing this command in each db.

sp_replicationdboptin 'databasename','merge publish',false

You will find a database which is missing some tables. Manually
create them by doing this

create table sysmergesubscriptions(dummy int)

and then continue to issue the above option until you clear all error
messages. then try to drop the distribution db.

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business
intelligence.

This posting is my own and doesn't necessarily represent
RelevantNoise's positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"John A Grandy" <johnagrandy-at-yahoo-dot-com> wrote in message
news:%23LQowMJ%23GHA.2180@xxxxxxxxxxxxxxxxxxxxxxx
The "Disable Publishing and Distribution' wizard fails. It
corresponds to the tsql

use master
exec sp_dropdistributor @no_checks = 1
go

The error is

Msg 208, Level 16, State 1, Procedure sp_MSmergepublish db, Line 103
Invalid object name 'dbo.sysmergesubscriptions'















.

Relevant Pages

  • Re: disable publishing and distribution error
    ... Director of Text Mining and Database Strategy ... RelevantNOISE.Com - Dedicated to mining blogs for business intelligence. ... publisher_db sysname, ... allow_push int, ...
    (microsoft.public.sqlserver.replication)
  • Re: disable publishing and distribution error
    ... My database is no longer being published for replication because I used ... Looking for a SQL Server replication book? ... publisher_db sysname, ... allow_push int, ...
    (microsoft.public.sqlserver.replication)
  • Re: disable publishing and distribution error
    ... publisher_db sysname, ... designmasterid uniqueidentifier, ... allow_push int, ... Director of Text Mining and Database Strategy ...
    (microsoft.public.sqlserver.replication)
  • Re: disable publishing and distribution error
    ... publisher_db sysname, ... publication_type tinyint, ... designmasterid uniqueidentifier, ... allow_push int, ...
    (microsoft.public.sqlserver.replication)