Yiqing (Charles) Ju

Troubleshoot SQL P2P replication doesn't replicate DDL schema change.

This article shows a problem with P2P replication doesn't replicate DDL schema changes and something you might want to check.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.7 (10)

You rated this post out of 5. Change rating

2014-10-16

1,974 reads

Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...

The more I work with the Data API Builder (DAB), the more I lean...

It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...

Comments posted to this topic are about the item Vector DB implementation using FAISS

Comments posted to this topic are about the item The Types of Changes

Comments posted to this topic are about the item Escaping Like I

I have this data in a SQL Server 2022 table:

PlayerIDPlayerNamePlayerStatus
1The \%ChampActive
2The ChampActive
3The_ChampionActive
4The__ChampionActive
5The\_ChampActive

How many rows are returned by this code in SQL Server 2022?

select PlayerName from player
where playername like 'The\_C%' escape '\'