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...
>