Shulou(Shulou.com)05/31 Report--

The main content of this article is to explain "how to quickly delete the options in the drop-down list box when logging in SQL Server", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how to quickly delete the options in the drop-down list box when you log in to SQL Server.

Question:

I used to create a login name such as kpi, and then deleted it in "Security-Login name", but every time I log in, the login name kpi is always displayed in the drop-down box. How can I delete it?

Solution:

1). SQL Server 2008 R2 and SQL Server 2008

Close the database login window, and then delete:

The SqlStudio.bin file under% AppData%\ Microsoft\ Microsoft SQL Server\ 100\ Tools\ Shell\. (paste the path directly in Explorer) then open SSMS and you won't see it.

2). SQL Server 2005

Close the database login window, and then delete:

The mru.dat file under% AppData%\ Microsoft\ Microsoft SQL Server\ 90\ Tools\ Shell\. (paste the path directly in Explorer) then open SSMS and you won't see it.

3). SQL Server 2000

Close the database login window, and then clear:

HKEY_CURRENT_USER\ Software\ Microsoft\ Microsoft SQL Server\ 80\ Tools\ Client\ PrefServers\ corresponding content. Open the SSMS again and you won't see it.

At this point, I believe you have a deeper understanding of "how to quickly delete the options in the drop-down list box when logging in SQL Server". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.