Createing articles for replication 
Author Message
 Createing articles for replication
Does anyone have any information on SQL Server 2000 replication. I would
like to know what is the most amount colunms a table can have in order to
create an article for replication. I know in SQL Server 7 the amount is 255.
Has that changed in SQL Server 2000 or is it the same? Is there any way
around the limitation in order the to the replication successfully without
doing the table all over again. Any help is appreciated.

Luis Lurvey
PC Solutions



Sat, 29 May 2004 06:04:04 GMT
 Createing articles for replication

Hi Luis,

SQL 2000:
A table used in a snapshot or transactional publication can have a maximum of
255 columns and a maximum row size of 8,000 bytes. A table used in a merge
publication can have a maximum of 246 columns and a maximum row size of 6,000
bytes.

SQL 7.0:
A table used in a snapshot or transactional publication can have a maximum of
255 columns and a maximum row size of 8,000 bytes. A table used in a merge
publication can have a maximum of 246 columns and a maximum row size of 6,000
bytes.

HTH

Ashwin Kowtha [MS]

This posting is provided "AS IS", with no warranties, and confers no rights.

Please reply only to the newsgroup so that others can benefit. When posting,
please state the version of SQL Server being used and the error number/exact
error message text received, if any.
--------------------

Quote:

>>> Subject: Createing articles for replication
>>> Date: Mon, 10 Dec 2001 16:04:04 -0600
>>> Lines: 12
>>> X-Priority: 3
>>> X-MSMail-Priority: Normal
>>> X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
>>> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000

>>> Newsgroups: microsoft.public.sqlserver.replication
>>> NNTP-Posting-Host: dsl1-207-178-15-148.wia.com 207.178.15.148
>>> Path: cpmsftngxa09!tkmsftngp01!tkmsftngp03
>>> Xref: cpmsftngxa09 microsoft.public.sqlserver.replication:24608
>>> X-Tomcat-NG: microsoft.public.sqlserver.replication

>>> Does anyone have any information on SQL Server 2000 replication. I would
>>> like to know what is the most amount colunms a table can have in order to
>>> create an article for replication. I know in SQL Server 7 the amount is 255.
>>> Has that changed in SQL Server 2000 or is it the same? Is there any way
>>> around the limitation in order the to the replication successfully without
>>> doing the table all over again. Any help is appreciated.

>>> Luis Lurvey
>>> PC Solutions




Wed, 16 Jun 2004 00:04:23 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Createing Articles

2. replication prob. article defintion

3. Replication from subscriber to publisher not replicating for new table articles

4. replication: modifying/adding an article

5. Recrating a Replication Article.

6. Modification within published article in replication

7. Replication: how to synch new article?

8. Issue adding article to existing publication with transactional replication

9. Does Merge Replication transfer the rules, defaults, UDT's when bound to Article

10. Replication Clause in Article ????

11. How to enforce order of article synchronization in merge replication

12. Re-reading of Merge Replication articles during synchronisation


 
Powered by phpBB® Forum Software