none
SSMS 2016 Error when Expanding tables "Subquery returned more than 1 value"

    Question

  • Hello.

    When using SSMS on SOME databases i get the following error when expanding the "Tables" node on object explorer

    "Subquery returned  more than 1 value. This is not permitted when  the subquery follows =,!=,<>.....
    Microsoft SQL Server,Error : 512)"

    The error has only started since I recently recieved an update yestarday.
    I executed a "Repair" on the my sql installation without any success.
    Other clients using older versions of SSMS do no have this issue on the same databases.


    Best Regards

    JohnLeo Carton



    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.14393.0
    Microsoft MSXML 3.0 6.0 
    Microsoft Internet Explorer 9.11.14393.0
    Microsoft .NET Framework 4.0.30319.42000
    Operating System 6.3.14393

    Wednesday, January 25, 2017 8:37 AM

All replies