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?
