Re: default value after replication

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

Andrew,
have a look at the @schema_option argument for sp_addarticle, which has a
value for defaults: 0x800.
AFAIR if you select the checkboxes on the article properties, you will end
up with the defaults added, even though it isn't explicitly mentioned.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)


.

Relevant Pages

  • Re: problem with Transactional Replication, indexes;urgent please
    ... in the article properties dialog (elipsis button from publication ... Paul Ibison SQL Server MVP, ... (recommended sql server 2000 replication book: ...
    (microsoft.public.sqlserver.replication)
  • Re: how to add table and all its index for replication
    ... select teh elipsis button in EM and on the article ... properties, snapshot tab, you'll see the corresponding ... checkboxes. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • 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: hopefully Im not right about changing article properites in merge
    ... the article properties are correct as far as the publication ... You could use sp_addscriptexec to sort out the indexes, ... for the identities you could just reseed the subscribers. ... Paul Ibison SQL Server MVP, ...
    (microsoft.public.sqlserver.replication)
  • 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)