下拉列表,显示sql server中服务器的历史记录 [英] drop-down list where it shows a history of servers in sql server
问题描述
尝试连接Management Studio中的服务器(特别是2008)时,会出现一个输入服务器名称的字段。该字段还有一个下拉列表,其中显示了您尝试连接的服务器的历史记录。
我知道原因。
C:\ Users \ [YourUser] \ AppData \Roaming\Microsoft\Microsoft SQL Server \100\Tools\Shell\SqlStudio.bin
但是
我想知道有时自动历史被清除了。为什么我们会遇到这类问题。
任何人都可以帮忙解决这个问题
When trying to connect to a server in Management Studio (specifically 2008), there is a field where you enter the Server name. That field also has a drop-down list where it shows a history of servers that you have attempted to connect to.
I know the reason.
C:\Users\[YourUser]\AppData\Roaming\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.bin
But
I would like to know Sometimes automatically history was cleared. Why we are getting this type of issue.
Can anyone help on this
推荐答案
其中一个可以在SQL Server 2008中清除历史记录的原因是因为SQLStudio.bin文件已被删除。为什么不检查是否是这种情况?
One of the reasons why the History can get cleared in SQL Server 2008 is because the SQLStudio.bin file has gotten deleted. Why don't you check if that is the case?
先前询问过并且之前已经回答过了!
清除SQL Server Management Studio中的服务器列表 [ ^ ]
正如我在该帖子的解决方案2中所述
Previously asked and previously answered!
clear the server list in SQL Server Management Studio[^]
As I stated in Solution 2 to that post
...看看它们可以从这些解决方案中的链接清除的方式,并确保你不会无意中做任何一个。
...look at the ways it can get cleared from the links in these solutions and make sure you are not doing any of them inadvertently.
这篇关于下拉列表,显示sql server中服务器的历史记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!