alter table DDL does not deliver to distribuiton database

alter table DDL does not deliver to distribuiton database by requestbug

Closed

as Won't Fix Help for as Won't Fix

Type:	Bug
ID:	774083
Opened:	12/11/2012 6:42:30 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

ENV
===
sql server 2008r2 and sql server 2012 both have this issue
transactional replication

reproduce Steps
====
create table [t_test ](id int priamry key ,c int)--- please note the table name is ended with a space
---publish the article
--
--
---add a new column
ALTER TABLE[T_test] add column1 int null -- please note , the table name ends without the space

--this DDL statement is not picked by the logreader agent as the related log records are not marked as 'REPLICATE'

select Description, *From sys.fn_dblog(null,null) where Description='REPLICATE'

Details (expand)

English

SQL Server 2012 - Developer Edition

Replication

Windows Server 2008 (all editions)

English

create table [t_test ](id int priamry key ,c int)--- please note the table name is ended with a space
---publish the article
--
--
---add a new column
ALTER TABLE[T_test] add column1 int null -- please note , the table name ends without the space

--this DDL statement is not picked by the logreader agent as the related log records are not marked as 'REPLICATE'

select Description, *From sys.fn_dblog(null,null) where Description='REPLICATE'

n/a

0 attachments

Posted by Microsoft on 1/14/2013 at 10:57 AM

Hi requestbug ,

given my previous message, I'm archiving this work item for now.

Best regards
Jean-Yves Devant
Program Manager Servicing and Lifecycle Experience of High Availability Technologies in SQL Server

Posted by Microsoft on 1/4/2013 at 4:56 PM

Hi requestbug,

thanks for taking the time to share your feedback, this is really important to us.
Unfortunately this does not meet the bar. We do not plan to address this for now. We will revisit the decision if more customers vote for the issue. In the meantime we recommend you do not create a table with a name that includes a trailing space.

Best regards
Jean-Yves Devant
Program Manager Servicing and Lifecycle Experience of High Availability Technologies in SQL Server

Posted by Microsoft on 1/4/2013 at 4:33 PM

Hi requestbug ,

thanks for taking the time to share your feedback, this is really important to us.
We will investigate the issue and get back to you.

Best regards
Jean-Yves Devant
Program Manager Servicing and Lifecycle Experience of High Availability Technologies in SQL Server