Replication problem - 1024 column

Dear Friends
I am facing the problem in my accounting database
replication there is one table with 1024 column and hence
the replication is failing as the maximum size is 1024
and the rowguide column can not be created.
Please guide if there is any way out to do the replicaion
with 1025 column in the table.
I can not do anything in this table as the applicaion is
third party. ( Can not delete any column)
Your earlier reply would be a great help.
Best regards
Sharad
Hi
SQL Server does not allow more than 1024 columns for a Table.
A system with 1024 columns...especially accounting. I hope you got it for
free and are looking at replacing it soon. No DBA who knows what he is doing
would design such a table. It is totally un-manageable, and with a
limitation of 8k per row, if every column were populated, each column could
be only 8 bytes.
There is no solution for you as you have hit a system limitation.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Sharad" <Niitmalad@.yahoo.co.in> wrote in message
news:2a6201c4eb7e$811d3c40$a401280a@.phx.gbl...
> Dear Friends
> I am facing the problem in my accounting database
> replication there is one table with 1024 column and hence
> the replication is failing as the maximum size is 1024
> and the rowguide column can not be created.
> Please guide if there is any way out to do the replicaion
> with 1025 column in the table.
> I can not do anything in this table as the applicaion is
> third party. ( Can not delete any column)
> Your earlier reply would be a great help.
> Best regards
> Sharad
>
|||Hello Sharad,
what about splitting of your article (table) into two publications?
Greetings from Cologne
Thomas
"Sharad" wrote:

> Dear Friends
> I am facing the problem in my accounting database
> replication there is one table with 1024 column and hence
> the replication is failing as the maximum size is 1024
> and the rowguide column can not be created.
> Please guide if there is any way out to do the replicaion
> with 1025 column in the table.
> I can not do anything in this table as the applicaion is
> third party. ( Can not delete any column)
> Your earlier reply would be a great help.
> Best regards
> Sharad
>
>
|||obviously Mike has never heard of PeopleSoft.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:exm6Ea46EHA.2180@.TK2MSFTNGP12.phx.gbl...
> Hi
> SQL Server does not allow more than 1024 columns for a Table.
> A system with 1024 columns...especially accounting. I hope you got it for
> free and are looking at replacing it soon. No DBA who knows what he is
doing
> would design such a table. It is totally un-manageable, and with a
> limitation of 8k per row, if every column were populated, each column
could
> be only 8 bytes.
> There is no solution for you as you have hit a system limitation.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Sharad" <Niitmalad@.yahoo.co.in> wrote in message
> news:2a6201c4eb7e$811d3c40$a401280a@.phx.gbl...
>

Replication problem

Hi folks; i have added a column into a published table using SP_REPLADDCOLUMN.
I get the following message:
Warning: The table 'MY_TABLE' has been created but its maximum row size (8814) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.
Warning: The table 'aonflict_MBDB_PUBLICATION_PTL_PATIENT_CLAIM' has been created but its maximum row size (10801) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.

MY_TABLE had 40 columns.
Is there any maximum limit of allowed columns in a published table?
Can anyone explain what are the concequences!I dont think the message you are receiving is related to replication

The 8060 byte limit is a universal limit for the data size of a row. It relates to the maximum amount of data that can be stored on a page.

Replication problem

How to perform replication suppose on two tables but NOT for all columns'
Suppose if i have IDENTITY column in table i can use option NOT FOR
REPLICATION, however in case my column doesn't identity, so '
Message posted via http://www.webservertalk.comI THINK IT'S ONLY FOR identity COLUMNS
Message posted via http://www.webservertalk.com