我可以为所有新用户配置文件设置默认SSMS选项吗？ [英] Can I set the default SSMS options for all new user profiles?

问题描述

嗨 -

我是一名社区学院讲师，教授T-SQL入门课程，我让学生使用SSMS作为他们的开发环境。学生们正在登录虚拟桌面实例（这恰好是VMWare VDI解决方案），在这里他们可以访问Windows 10桌面，这是一个"链接克隆"桌面。 "黄金大师"实例。一旦他们登录，他们就会启动SSMS，然后关闭它们 - 但是，由于链接克隆实例的性质，当他们注销时，实例
将被丢弃，并且不会保存对实例的任何更改。这对于确保学生可以随时访问功能正常的实验室机器是可取的，但是当我们尝试配置黄金大师时，它确实会带来一些有趣的挑战。

具体来说，我有兴趣改变SSMS的默认设置，以便文本编辑器已经显示学生打开新查询的行号。在我对这个问题的研究中，我已经自学了.vssettings
文件的默认位置，该文​​件存储了SSMS的配置值;遗憾的是，这是一个基于配置文件的设置文件，链接克隆在用户注销时会丢弃用户配置文件，因此不能将任何更改永久保存到vssettings文件中。我还尝试了使用"使用团队设置文件"的想法
。 SSMS中的选项，但这也是基于配置文件的设置，必须在创建配置文件后设置，因此它似乎也不起作用。

所以，问题我相信我问的是，"有没有办法修改SSMS在其选项区域中为新用户的个人资料生成vssettings文件时使用的默认值？"如果是这样，我很想知道去哪里寻找这些
值。非常感谢提供任何帮助！

解决方案

据我所知这是不可能的，而您的问题与VM然后SSMS更相关。

但是你可以导出选项设置& 。注册服务器和您的学生可以将其导入

请参阅 的教程：SQL Server Management Studio组件和配置 => 将设置重置为默认值=>导出/导入
...设置

Hi -

I am a community college instructor teaching an introductory course to T-SQL, and I'm having students use SSMS as their development environment. The students are logging into a Virtual Desktop Instance (This happens to be a VMWare VDI solution) where they get access to a Windows 10 desktop which is a "linked-clone" of a "golden master" instance. Once they log in, they launch SSMS, and off they go - however, because of the nature of the linked-clone instance, when they log out, the instance is discarded and no changes to the instance are saved. This is desirable for ensuring the students can always access a functioning lab machine, but it does make some interesting challenges when we try to configure the golden master.

Specifically, I'm interested in changing the default settings of SSMS so that text editor already has line numbers showing when students open a new query. In my research into this question, I've educated myself in the default location of the .vssettings file which stores the configuration values for SSMS; unfortunately, this is a profile-based settings file, and the linked-clone discards the user profile when the user logs out, so no changes can be permanently saved to the vssettings file. I've also experimented with the idea of using the "use team settings file" option in SSMS, but this too is a profile-based setting that has to be set after the profile is created, so it also doesn't seem to work.

So, the question I believe I'm asking is, "Is there a way to modify the default values which are used by SSMS in its Options area when it generates a vssettings file for a new user's profile?" If so, I'd love to hear where to go looking for these values. Many thanks for any assistance offered!

解决方案

AFAIK it's not possible, and your issue is more related to VM then SSMS.

But you can export option settings & registered server and your students can import them.

See Tutorial: SQL Server Management Studio components and configuration => Reset settings to the default => Export/Import ... settings

这篇关于我可以为所有新用户配置文件设置默认SSMS选项吗？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！