Re: how to add table and all its index for replication

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Paul Ibison (Paul.Ibison_at_Pygmalion.Com)
Date: 01/10/05 

Date: Mon, 10 Jan 2005 03:30:39 -0800

Have a look at @schema_option in sp_addarticle. If you
select teh elipsis button in EM and on the article
properties, snapshot tab, you'll see the corresponding
checkboxes. The easiest thing to do is to select what you
want graphically, and then have EM do the bitmask logic
to generate the correct parameter value.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
 http://www.nwsu.com/0974973602p.html)

Relevant Pages

  • Filter by form problem with Yes/No Data and SQL Server
    ... SQL Server 2005 Back end: ... I have a complex form that has lots of data fields including about ... thirty or so checkboxes storing Yes/No data that I would like my users ... This works perfectly fine when I filter on a text field. ...
    (comp.databases.ms-access)
  • Re: Going into an infinite loop
    ... > Now, when I check All Object Types, all the other checkboxes take on the ... What I want to happen is when one of the> other check boxes are checked, I want the chkAllObjectTypes checkbox to change> state to ... > Looking for a SQL Server replication book? ...
    (microsoft.public.dotnet.languages.csharp)
  • Form error????
    ... I just added two checkboxes on my main form and on the MS SQL server I also ... added two fields as “bit” format. ... "The record has been changed by another user since you started editing it. ... When I delete those two checkboxes it works fine?????? ...
    (microsoft.public.access.forms)
  • Re: default value after replication
    ... AFAIR if you select the checkboxes on the article properties, ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • Re: Recreating unique clustered index in transactional replication
    ... Include DRI on the snapshot tab. ... HTH, ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)