0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 1 year has passed since last update.

SSMS で Poor Man's T-SQL Formatter が正しく読み込まれない場合の対処

Last updated at Posted at 2023-02-14

こんな画面が出たので対処を調べてみました
「'FormatterPackage' パッケージは正しく読み込まれませんでした」
image.png

対処

ssms.exe.config に下記のコードを追加

\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\ssms.exe.config
            <dependentAssembly> 
				<assemblyIdentity name="Microsoft.VisualStudio.Shell.12.0" publicKeyToken="b03f5f7f11d50a3a" culture="neutral"/> 
				<bindingRedirect oldVersion="2.0.0.0-15.0.0.0" newVersion="15.0.0.0"/> 
			</dependentAssembly>

環境

SQL Server Management Studio v18.10
PoorMansTSqlFormatterSSMSPackage.Setup.1.6.16.msi

参考

Poor mans T-SQL formatting add-in "Format T-SQL Code" option disabled in SQL Server Management Studio v18.5
※詳しい動作について解る方はぜひコメントください

0
0
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0
0

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?