Re: Replication problem - 1024 column
From: Mike Epprecht \(SQL MVP\) (mike_at_epprecht.net)
Date: 12/26/04
- Next message: Tina Smith: "Many Rows"
- Previous message: Sharad: "Replication problem - 1024 column"
- In reply to: Sharad: "Replication problem - 1024 column"
- Next in thread: Hilary Cotter: "Re: Replication problem - 1024 column"
- Reply: Hilary Cotter: "Re: Replication problem - 1024 column"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 26 Dec 2004 21:07:23 +0100
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
>
>
- Next message: Tina Smith: "Many Rows"
- Previous message: Sharad: "Replication problem - 1024 column"
- In reply to: Sharad: "Replication problem - 1024 column"
- Next in thread: Hilary Cotter: "Re: Replication problem - 1024 column"
- Reply: Hilary Cotter: "Re: Replication problem - 1024 column"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
