SSMS 导入导出设置选项问题

Question

希望这是一个简单的问题，但它让我很烦恼。当我在 SQL Server Management Studio (v18.4) 中使用“导出设置”向导时，它会显示我在“工具|选项”窗口中无法识别的选项。这些是数字选项，例如 #3600、#2018、#2001 等。

如果我在导出之前不取消选中所有这些，我会遇到很多错误。

Your settings were exported, but there were some errors. Error 1: Failed to export settings for '#20116' [code 6714] Error 2: Failed to export settings for '#100' [code 6714] Error 3: Failed to export settings for '#1010' [code 6714] Error 4: Failed to export settings for '#1001' [code 6714] Error 5: Failed to export settings for 'Start Page' [code 922] Error 6: Failed to export settings for '#20133' [code 844] Error 7: Failed to export settings for '1050' [code 844] Error 8: Failed to export settings for '#3600' [code 844] Error 9: Failed to export settings for '2015' [code 844] Error 10: Failed to export settings for '2001' [code 844] Error 11: Failed to export settings for '2011' [code 844] Error 12: Failed to export settings for '2012' [code 844] Error 13: Failed to export settings for '2013' [code 844]

但是，第一行暗示，也许我还好。但是，如果我尝试导入刚刚导出的文件，我会...

Your settings were imported, but there were some errors. Error 1: An error occurred while importing settings for 'Start Page' [code 5302]. Error 2: An error occurred while importing settings for '#20116' [code 5297]. Error 3: An error occurred while importing settings for '#100' [code 5297]. Error 4: An error occurred while importing settings for '#1010' [code 5297]. Error 5: An error occurred while importing settings for '#1001' [code 5297].

更重要的是，导出时出现的一些键盘快捷键不会随导入重新加载。

SSMS Export Wizard Snapshot

我的问题分为两部分。

1) 这些选项是什么？2)有没有一种简单/更容易的方法让我绕过/删除它们？

提前致谢!

Answer 1

看起来这些错误可能是由于旧版本的 SSMS 遗留的设置造成的。

重置您的设置可能会解决错误。 See this了解更多信息。