SQL Server 2008 : where does the system store the list of "Server Names" ? I want them cleaned up .
-
28 มิถุนายน 2554 6:55
I would like to know where the SQL Server Management Studio stores the list of "registred" or already used Server Names ?
This list has got information that is not relevant any longer, I do not seem to be able to get it cleaned up.
I have already searched the registry but could not find it
ตอบทั้งหมด
-
28 มิถุนายน 2554 7:03ผู้ดูแลAre you talking about server names shown on logon screen?
Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
--------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------------------------------------------------------------------
My Blog | Team Blog | @Twitter -
28 มิถุนายน 2554 7:11ผู้ดูแล
If my assumption is correct. here are the ways..(Please take backup of file before deleting it from the location specificed above)
For SQL 2005:
C:\Documents and Settings\<USER>\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.datFor SQL 2008:
C:\Documents and Settings\<USER>\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\SqlStudio.binHow to clear the list?
1.Shut down all instances of SSMS
2.Delete/Rename the file
3.Open SSMS
Refer connect item https://connect.microsoft.com/SQLServer/feedback/details/424800/ssms-expose-connect-to-server-mru-list-to-users
Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
--------------------------------------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------------------------------------------------------------------
My Blog | Team Blog | @Twitter- เสนอเป็นคำตอบโดย Pradeep AdigaMicrosoft 28 มิถุนายน 2554 8:32
- ทำเครื่องหมายเป็นคำตอบโดย WeiLin QiaoModerator 7 กรกฎาคม 2554 10:13
.png)
