By product  
  Other  

Troubleshooting

Troubleshooting and known issues with ApexSQL Tools


System.IO. FileNotFoundException: Could not load file or assembly 'Microsoft. VisualStudio. CommandBars'

Applies to
ApexSQL Refactor

Summary

This article shows what sould be done when the "System.IO.FileNotFoundException" is thrown

Symptoms
When starting Microsoft SQL ServerManagementStudio "System.IO.FileNotFoundException"
is thrown

Cause
Some system libraries are missing in the PublicAssemblies catalog

Resolution
1) Check if the Microsoft.VisualStudio.CommandBars.dll library exists in one of the following locations

x:\Program Files\Microsoft Visual Studio\Common7\IDE\PublicAssemblies
x:\Program Files\Common Files\Microsoft Shared\MSEnv\PublicAssemblies

If there is no such file in the mentioned locations, try to reinstall SQL Server client components using the SQL Server installer

2) Locate the folder with Global Assembly Cache Tool gacutil.exe. Execute the following CLI command in the gacutil.exe directory
gacutil /l Microsoft.VisualStudio.CommandBars

If nothing is returned, run the following command, to add the missing DLL to the Global Assembly Cache
gacutil /i [Full path to the Microsoft.VisualStudio.CommandBars.dll]

About ApexSQL Refactor
ApexSQL Refactor is a SQL formatter and database refactoring tool for SQL Server. Format SQL queries, refactor SQL code, database tables and much more

Last updated
November 30, 2011

Labels:

...