I am not able to create publiction. It gives me error--

Invalid Object Name dbo.sysmergepublication does not exist
Publication EmpPublication does not exist
change database context to 'Emp'(Microsoft SQL Server, Error:208)

can you go to your publication database and do this

sp_replicationdboption 'mydatabase','merge publish','true'

and see what happens.

Can you also manually create the table here is its schema.

*** Object: Table [dbo].[sysmergepublications] Script Date: 09/07/2007
09:15:53 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING OFF

GO

CREATE TABLE [dbo].[sysmergepublications](

[publisher] [sysname] NOT NULL DEFAULT (publishingservername()),

[publisher_db] [sysname] NOT NULL DEFAULT (db_name()),

[name] [sysname] NOT NULL,

[description] [nvarchar](255) NULL,

[retention] [int] NULL,

[publication_type] [tinyint] NULL,

[pubid] [uniqueidentifier] NOT NULL,

[designmasterid] [uniqueidentifier] NULL,

[parentid] [uniqueidentifier] NULL,

[sync_mode] [tinyint] NULL,

[allow_push] [int] NULL,

[allow_pull] [int] NULL,

[allow_anonymous] [int] NULL DEFAULT ((1)),

[centralized_conflicts] [int] NULL,

[status] [tinyint] NULL,

[snapshot_ready] [tinyint] NULL,

[enabled_for_internet] [bit] NOT NULL DEFAULT ((0)),

[dynamic_filters] [bit] NOT NULL DEFAULT ((0)),

[snapshot_in_defaultfolder] [bit] NOT NULL DEFAULT ((1)),

[alt_snapshot_folder] [nvarchar](255) NULL,

[pre_snapshot_script] [nvarchar](255) NULL,

[post_snapshot_script] [nvarchar](255) NULL,

[compress_snapshot] [bit] NOT NULL DEFAULT ((0)),

[ftp_address] [sysname] NULL,

[ftp_port] [int] NOT NULL DEFAULT ((21)),

[ftp_subdirectory] [nvarchar](255) NULL,

[ftp_login] [sysname] NULL DEFAULT (N'anonymous'),

[ftp_password] [nvarchar](524) NULL,

[conflict_retention] [int] NULL,

[keep_before_values] [int] NULL DEFAULT ((0)),

[allow_subscription_copy] [bit] NULL DEFAULT ((0)),

[allow_synctoalternate] [bit] NULL DEFAULT ((0)),

[validate_subscriber_info] [nvarchar](500) NULL,

[ad_guidname] [sysname] NULL,

[backward_comp_level] [int] NOT NULL DEFAULT ((10)),

[max_concurrent_merge] [int] NOT NULL DEFAULT ((0)),

[max_concurrent_dynamic_snapshots] [int] NOT NULL DEFAULT ((0)),

[use_partition_groups] [smallint] NULL,

[dynamic_filters_function_list] [nvarchar](500) NULL,

[partition_id_eval_proc] [sysname] NULL,

[publication_number] [smallint] IDENTITY(1,1) NOT NULL,

[replicate_ddl] [int] NOT NULL DEFAULT ((0)),

[allow_subscriber_initiated_snapshot] [bit] NOT NULL DEFAULT ((0)),

[distributor] [sysname] NULL,

[snapshot_jobid] [binary](16) NULL,

[allow_web_synchronization] [bit] NULL DEFAULT ((0)),

[web_synchronization_url] [nvarchar](500) NULL,

[allow_partition_realignment] [bit] NULL DEFAULT ((1)),

[retention_period_unit] [tinyint] NOT NULL DEFAULT ((0)),

[decentralized_conflicts] [int] NULL,

[generation_leveling_threshold] [int] NULL DEFAULT ((1000)),

[automatic_reinitialization_policy] [bit] NOT NULL DEFAULT ((0))

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF


--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

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
[quoted text, click to view]