none
SSMS 2016 Error when expanding tables.

    Question

  • This happened after an SSMS 2016 update.

    I narrowed it down to a table that has multiple columns with SPARSE specified.

    SSMS 2016 info:

    Microsoft SQL Server Management Studio                        13.0.16105.4
    Microsoft Analysis Services Client Tools                        13.0.1700.441
    Microsoft Data Access Components (MDAC)                        10.0.10586.0
    Microsoft MSXML                        3.0 6.0
    Microsoft Internet Explorer                        9.11.10586.0
    Microsoft .NET Framework                        4.0.30319.42000
    Operating System                        6.3.10586

    Here is the SSMS Error text.

    TITLE: Microsoft SQL Server Management Studio
    ------------------------------

    Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. (Microsoft SQL Server, Error: 512)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=10.50.6542&EvtSrc=MSSQLServer&EvtID=512&LinkId=20476

    ------------------------------
    BUTTONS:

    OK
    ------------------------------
      at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
       at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
       at System.Data.SqlClient.SqlDataReader.Read()
       at Microsoft.SqlServer.Management.Smo.DataProvider.ReadInternal()
       at Microsoft.SqlServer.Management.Smo.DataProvider.Read()
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.NavigableItemBuilderDataReader.Read(Object[]& values)
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItemWithQuery(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, String urnQuery, Boolean registerBuilder, Boolean registerBuiltItems)
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.BuildDynamicItem(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItemBuilder.Build(IList`1 nodes, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NonContextFilterNavigableItemBuilder.Build(IList`1 targetList, INodeInformation source, INavigableItem sourceItem, IFilterProvider filter)
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.RequestChildren(IGetChildrenRequest request)
       at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren(WaitHandle quitEvent)

    Tuesday, January 24, 2017 8:25 PM

Answers

All replies

  • Hello,

    This seems to be a bug. Please report it to Microsoft Connect.

    https://connect.microsoft.com/SQLServer/


    Please update the thread with the URL of the Connect item in case more people run into this issue.

    Try using the previous version of SSMS meanwhile.

    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com



    Tuesday, January 24, 2017 9:11 PM
    Moderator
  • Hi Bill,

    I’m reproducing this with latest SSMS(16.5.2). With SQL Profiler, it seems an extra CAST(….) AS [HasSparseColumn] has been added to the underlying query which causes the issue. 

    Meanwhile, you may have to rollback to pervious SSMS release if this causes too much trouble.

    I’ll try report it internally to product team, thanks for your understanding and support.

    Regards,
    Lin

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, January 25, 2017 7:32 AM
    Moderator
  • https://connect.microsoft.com/SQLServer/feedback/details/3119590/microsoft-sql-server-management-studio-error-on-refresh-tables

    MCTS SQL Server 2005

    Wednesday, January 25, 2017 10:56 AM
  • Thank you for reporting the issue. We are working on the fix for this right now.

    Parikshit

    Wednesday, January 25, 2017 10:33 PM
  • Hi Bill,

    The product team have been notified on this issue and they are working on a fix right now.

    Thanks for your understanding and support.

    Regards,
    Lin

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, January 26, 2017 6:56 AM
    Moderator
  • Thanks.

    I see there is a new update SSMS 16.5.3

    I installed it and it fixed the issue.

    Friday, January 27, 2017 5:55 PM