Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Replicate view with more than 255 column

Author  Topic 

BRSqlTeam
Starting Member

1 Post

Posted - 2007-10-24 : 05:54:38
Hi,


I'm setting up Transaction Replication b/w SQL Server 2K and SQL Server 2K5.
I have published Tables, Views and SPs as articles.
One of the views has more than 300 columns. So when i try to replicate it, I'm encountering the

following error Message.

"Error 20068: The article cannot be created on table because it has more than 255 columns."

When a view can be created with more than 255 columns, why the problem arises when we replicate it?
Can any one help me on this?

Thanks,
SBR.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-10-24 : 23:10:37
You can call it design flaw.
Go to Top of Page
   

- Advertisement -