error while open new query

• comptech

  SSC Enthusiast

  Points: 177

  More actions

  January 11, 2020 at 3:46 pm

  #3714665

  hi

  in ssms 2019, when i want open new query , i have this error:

  'Type of metadata view is unsupported.'

   

  thanks for any help

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  January 12, 2020 at 4:10 pm

  #3714763

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.

• Jo Pattyn

  SSC-Dedicated

  Points: 32430

  More actions

  January 13, 2020 at 4:09 pm

  #3714952

  Which version of SSMS is it? because is has been decoupled from the sql server installation. 18.4 , ... ?

• surbhinahta

  Newbie

  Points: 7

  More actions

  January 24, 2020 at 4:44 am

  #3717972

  This solution is for SQL query -

  In the end, the solution was to copy the PrivateAssemblies\Interop\Microsoft.VisualStudio.Shell.Interop.8.0.dll file (the one with assembly version 15.0.0.0) into the PublicAssemblies folder.

  The steps I did were the following:

  First, as a precaution, I renamed the existing PublicAssemblies\Microsoft.VisualStudio.Shell.Interop.8.0.dll to something else, just in case I would need that file later.

  Then I copied the Microsoft.VisualStudio.Shell.Interop.8.0.dll file from PrivateAssemblies\Interop into the PublicAssemblies folder.