Home Dashboard Directory Help
Search

alter table DDL does not deliver to distribuiton database by requestbug


Status: 

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


1
1
Sign in
to vote
Type: Bug
ID: 774083
Opened: 12/11/2012 6:42:30 PM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

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