alter table DDL does not deliver to distribuiton database - by requestbug

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
1
Sign in
to vote
ID 774083 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 12/11/2012 6:42:30 PM
Access Restriction Public

Description

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'
Sign in to post a comment.
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