Question
July 17, 2007 at 03:26 AM
maria

Replication: SQL Server Express 2005

by maria . Updated 19 years ago

Replication an user database
—————————–
I execute this

DECLARE @publicationDB as sysname;
DECLARE @login as sysname;
DECLARE @password as sysname;
DECLARE @publication as sysname;

SET @publication = N’DP’;

SET @publicationDB = N’DP’;
SET @login =N’sa’;
SET @password = N’AQDATA’;

EXEC sp_addpublication
@publication=@publication,
@status=N’active’,
@allow_push=N’true’,
@allow_pull=N’true’,
@independent_agent=N’true’;

and I receive this answer–>
“Msg 14013, Level 16, State 1, Procedure sp_MSrepl_addpublication, Line 159
This database is not enabled for publication.”
It is possible or not to create a Publication, Distribution,Subscription?

This discussion is locked

All Comments