question

kselvaputthiran avatar image
kselvaputthiran asked

ended with a partial command (41)

Hello,

I am adding a new column to a table which is under replication. The table contains around 200,000,000 records. After making this change I'm getting the below error. I tried apply slow start mode and few more techniques. It does not resolve...

Can you please help me on this ?

Error Message:

Transaction 0x0001177600007b10000100000000 ended with a partial command (41); the next transaction is 0x0001177600007b10000100000000. When troubleshooting, execute DBCC CHECKDB and look for issues with the distribution database. Execute sp_browsereplcmds on the distribution database and save the result before contacting product support. (Source: MSSQL_REPL, Error number: MSSQL_REPL20013) Get help: http://help/MSSQL_REPL20013

sql-server-2005replicationerror-message
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Matt Whitfield avatar image
Matt Whitfield answered

It does tell you what you need to do:

Execute sp_browsereplcmds on the distribution database and save the result before contacting product support

Time to use one of those product support incidents, then.

1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

kselvaputthiran avatar image kselvaputthiran commented ·
Yes I did browsrepl commands.. and it shows that it is due to DDL command replication.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.