Asked by:

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

Question

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.