none
Sql error while upgrading sccm version 1703 to 1710

    Question

  • ERROR: Failed to execute SQL Server command:  ~  DECLARE @viewname    nvarchar(255) ~  DECLARE newviews INSENSITIVE CURSOR FOR ~    SELECT name FROM sysobjects WHERE type='V' AND name like 'v[_]%' ~  OPEN newviews ~  FETCH NEXT FROM newviews INTO @viewname ~  WHILE (@@FETCH_STATUS = 0) ~  BEGIN ~    EXEC('GRANT SELECT ON ' + @viewname + ' to smsschm_users') ~    FETCH NEXT FROM newviews INTO @viewname ~  END ~  CLOSE newviews ~  DEALLOCATE newviews

    Failed to apply update changes 0x87d20b15

    Thursday, April 12, 2018 5:54 PM

All replies

  • Hi,

    What is your SQL server version?

    Have you run the Pre-requisites before upgrading?

    Examine the CMUpdate.log to start troubleshooting.

    Best Regards,

    Lorry


    Please remember to mark the replies as answers if they help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Friday, April 13, 2018 2:55 AM
  • Hi,

    You have not update for a long time. 

    Have you solved this problem? Can you share the solutions to help more people?

    Please remember to mark the replies as answer if they help.

    Best Regards,

    Lorry


    Please remember to mark the replies as answers if they help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.

    Monday, April 30, 2018 8:41 AM