none
Error when trying to open "Distributor properties...."

    Frage

  • If I right click the "Replication" folder, then click "Distributor properties....", I will get the following error:

    TITLE: Distributor Properties
    ------------------------------
    
    SQL Server is unable to complete the Distributor Properties.
    
    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=14.0.17224.0&EvtSrc=Microsoft.SqlServer.Management.UI.DistributorPropertiesErrorSR&EvtID=CantComplete&LinkId=20476
    
    ------------------------------
    ADDITIONAL INFORMATION:
    
    An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
    
    ------------------------------
    
    Invalid column name 'deletebatchsize_xact'.
    Invalid column name 'deletebatchsize_cmd'. (Microsoft SQL Server, Error: 207)
    
    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.7001&EvtSrc=MSSQLServer&EvtID=207&LinkId=20476
    
    ------------------------------
    BUTTONS:
    
    OK
    ------------------------------
    

    It was working fine! 

    Dienstag, 22. Mai 2018 11:19

Antworten

  • I have added two columns missing from dbo.MSdistributiondbs in msdb database.

    The two columns are deletebatchsize_xact (int), deletebatchsize_cmd (int) and I gave them the default values of 5000 and 2000 respectively.

    I don't know how this happened and why. but the above solved the issue. 

    • Als Antwort markiert Butmah Sonntag, 3. Juni 2018 08:43
    Sonntag, 3. Juni 2018 08:43

Alle Antworten

  • What version and edition of Publisher SQL instance are you running? is it on the latest patch?

    Please remember to click "Mark as Answer" if my response answered your question or click "Vote as helpful" if it helped you in any way.


    Dienstag, 22. Mai 2018 14:40
  • Microsoft SQL Server 2012 (SP4) (KB4018073) - 11.0.7001.0 (X64)   Aug 15 2017 10:23:29   Copyright (c) Microsoft Corporation  Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) 
    Mittwoch, 23. Mai 2018 04:15
  • Could you try from another SSMS? If you have SSMS installed on another server, try doing the same thing from there and see if the error still shows up.

    Please remember to click "Mark as Answer" if my response answered your question or click "Vote as helpful" if it helped you in any way.

    Mittwoch, 23. Mai 2018 13:33
  • These were introduced with SQL Server 2017, followed by releases in SQL Server 2012 SP4 and SQL Server 2016 SP2. . What version of SSMS are you using?

    Are you running any of the databases in a different compatibility setting?


    Dienstag, 29. Mai 2018 14:43
    Moderator
  • I have added two columns missing from dbo.MSdistributiondbs in msdb database.

    The two columns are deletebatchsize_xact (int), deletebatchsize_cmd (int) and I gave them the default values of 5000 and 2000 respectively.

    I don't know how this happened and why. but the above solved the issue. 

    • Als Antwort markiert Butmah Sonntag, 3. Juni 2018 08:43
    Sonntag, 3. Juni 2018 08:43
  • hi ,

    there is existing replication running...

    if i going to add those two columns affects replication setup?

    Mittwoch, 24. Oktober 2018 05:31
  • No, it won't.
    Mittwoch, 24. Oktober 2018 13:55
    Moderator
  • after added it's working....no disturbance on my existing replica setup..
    Donnerstag, 25. Oktober 2018 02:02