Post reply

Replicate view with more than 255 columns

  • October 24, 2007 at 4:02 am

    #103424

    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 cokumns, why the problem arises when we replicate

    it?

    Can any one help me on this?

    Thanks,

    SBR.

  • October 24, 2007 at 4:26 am

    #744850

    we can solve this issue by means of configuring with Linked server. better try to understand on the configuration part and how to replicate the data from LSrvr.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply