Replicating ntext datatypes  Replication Agent for Microsoft SQL Server transaction log

Chapter 3: Replication Agent for Microsoft SQL Server

Objects with delimited identifiers

When marking an object that uses delimited identifiers, the marking script uses left and right brackets instead of double quotes to delimit the identifiers. This allows you to mark delimited names without requiring that the SQL Server database have the QUOTED_IDENTIFIER option turned on. However, the pdb_setreptable command itself still requires using double quotes around the identifiers.

For example:

pdb_setreptable “My Table”, mark

appears in the marking script as [owner].[My Table]





Copyright © 2005. Sybase Inc. All rights reserved. Replication Agent for Microsoft SQL Server transaction log

View this book as PDF