Replication Agent permissions  @@IDENTITY system variable

Chapter 3: Replication Agent for Microsoft SQL Server

Maximum number of columns in a table

A table marked for replication can have no more than three columns less than the maximum number allowed by the Microsoft SQL Server database.

For example, if the database allows up to 232 columns in a table, any table marked for replication can have up to 229 columns. Replication Agent adds three additional columns to a transaction log shadow table, which must not exceed the maximum number of columns allowed by the database.





Copyright © 2005. Sybase Inc. All rights reserved. @@IDENTITY system variable

View this book as PDF