有没有办法让 SSMS 在我每次打开它时都打开某个连接?
每天晚上,大学都会在午夜重新启动我系中的每台机器,我帮助我的教授在 11 个不同的 SQL 服务器上完成各种项目。因为我没有个人电脑,所以我不能让 SSMS 整夜保持打开状态。
是否可以启用某个设置或某些功能,以便它记住在我打开 SSMS 时打开我告诉它的连接?
谢谢。
Every night the university reboots every machine in my department at midnight and I help my professor with various projects on 11 different sql servers. Since i do not own a personal computer i can't just leave SSMS open over night.
Is it possible to have a setting or some featured enabled so that it remembers to open the connections that i tell it to when i open SSMS?
Thank you.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
您可以从命令行调用 SSMS 并使用开关来执行您想要执行的操作。
有 -S -d -U 和 -P 开关用于服务器、数据库、用户名和密码。您应该能够将调用放入 .bat 文件中并足够轻松地使用它。
Microsoft 网站上有文档。
You can call SSMS from the command line and uses switches to do what you're trying to do.
There are -S -d -U and -P switches for server, database, username, and password. You should be able to put the call into a .bat file and use that easily enough.
There is documentation on the Microsoft website.
如果您被允许安装第三方软件,SSMS 工具包插件可以满足您的需要。
If you are allowed to install third party software the SSMS Tools Pack addin does what you need.