"maxzsim via SQLMonster.com" <u14644@uwe> wrote in message
news:587958988abb4@uwe...
> Hi ,
>
> I found that i could only set up a db in the server as either a
> snapshot/merger replication with the transactional replication greyed out
>
>
> any reason why i am not able to make it a transactional replication ?
>
> tks & rdgs
>
> --
> Message posted via SQLMonster.com
> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-replication/200512/1

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:%23lC3Vey%23FHA.3068@TK2MSFTNGP09.phx.gbl...
> are you running msde?
>
> --
> Hilary Cotter
> 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
>
> "maxzsim via SQLMonster.com" <u14644@uwe> wrote in message
> news:587958988abb4@uwe...
>> Hi ,
>>
>> I found that i could only set up a db in the server as either a
>> snapshot/merger replication with the transactional replication greyed out
>>
>>
>> any reason why i am not able to make it a transactional replication ?
>>
>> tks & rdgs
>>
>> --
>> Message posted via SQLMonster.com
>> http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-replication/200512/1
>
>

Paul Ibison wrote:
>... or personal edition?
>Paul Ibison
>
>> are you running msde?
>>
>[quoted text clipped - 6 lines]
>>>
>>> tks & rdgs

Paul Ibison wrote:
>Is there an error when you run this:
>sp_dboption @dbname = 'database'
> , @optname = 'published'
> , @optvalue = 'true'
>Or are you possibly referring to the articles being greyed out (this is
>because of a lack of a Primary key).
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
>http://www.nwsu.com/0974973602p.html)

Paul Ibison wrote:
>Please can you run the following code in your database. All you need to do
>is a find and replace - change Region to a table name that has a PK. If
>there are any messages, please post them back.
>Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
>http://www.nwsu.com/0974973602p.html)
>
>-- Adding the transactional publication
>exec sp_addpublication @publication = N'TestPublication', @restricted =
>N'false', @sync_method = N'native', @repl_freq = N'continuous', @description
>= 'test', @status = N'active', @allow_push = N'true', @allow_pull = N'true',
>@allow_anonymous = N'false', @enabled_for_internet = N'false',
>@independent_agent = N'false', @immediate_sync = N'false', @allow_sync_tran
>= N'false', @autogen_sync_procs = N'false', @retention = 336,
>@allow_queued_tran = N'false', @snapshot_in_defaultfolder = N'true',
>@compress_snapshot = N'false', @ftp_port = 21, @ftp_login = N'anonymous',
>@allow_dts = N'false', @allow_subscription_copy = N'false',
>@add_to_active_directory = N'false', @logreader_job_name = N'TestPI-4'
>
>exec sp_addpublication_snapshot @publication =
>N'TestPublication',@frequency_type = 4, @frequency_interval = 1,
>@frequency_relative_interval = 0, @frequency_recurrence_factor = 1,
>@frequency_subday = 1, @frequency_subday_interval = 0, @active_start_date =
>0, @active_end_date = 0, @active_start_time_of_day = 230000,
>@active_end_time_of_day = 0, @snapshot_job_name =
>N'TestPI-TestPublication-11'
>GO
>
>exec sp_grant_publication_access @publication = N'TestPublication', @login =
>N'BUILTIN\Administrators'
>GO
>exec sp_grant_publication_access @publication = N'TestPublication', @login =
>N'distributor_admin'
>GO
>exec sp_grant_publication_access @publication = N'TestPublication', @login =
>N'sa'
>GO
>
>-- Adding the transactional articles
>exec sp_addarticle @publication = N'TestPublication', @article = N'Region',
>@source_owner = N'dbo', @source_object = N'Region', @destination_table =
>N'Region', @type = N'logbased', @creation_script = null, @description =
>null, @pre_creation_cmd = N'drop', @schema_option = 0x00000000000000F3,
>@status = 16, @vertical_partition = N'false', @ins_cmd = N'CALL
>sp_MSins_Region', @del_cmd = N'CALL sp_MSdel_Region', @upd_cmd = N'MCALL
>sp_MSupd_Region', @filter = null, @sync_object = null, @auto_identity_range
>= N'false'
>GO

maxzsim wrote:
>Hi Paul , when i ran ur script against the db that i want to create the
>publication i got the following.
>
>i am not sure abt the part that this edition does not support because i am
>using the standard edition or how can i check the edition of my SQL Server ?
>could be service pack issue ?
>
>=======================================================
>Server: Msg 21108, Level 16, State 1, Procedure sp_addpublication, Line 275
>This edition of SQL Server does not support transactional publications.
>Server: Msg 15001, Level 11, State 1, Procedure sp_addpublication_snapshot,
>Line 117
>Object 'TestPublication' does not exist or is not a valid object for this
>operation.
>Server: Msg 20026, Level 16, State 1, Procedure sp_MSpublication_access, Line
>42
>The publication 'TestPublication' does not exist.
>Server: Msg 20026, Level 16, State 1, Procedure sp_MSpublication_access, Line
>42
>The publication 'TestPublication' does not exist.
>Server: Msg 20026, Level 16, State 1, Procedure sp_MSpublication_access, Line
>42
>The publication 'TestPublication' does not exist.
>Server: Msg 14027, Level 11, State 1, Procedure sp_addarticle, Line 478
>TestPublication does not exist in the current database.
>
>=======================================================
>
>tks & rdgs
>
>>Please can you run the following code in your database. All you need to do
>>is a find and replace - change Region to a table name that has a PK. If
>[quoted text clipped - 45 lines]
>>= N'false'
>>GO