Hello, Charmy!
Thank-you for your kind words. It is good to know that my blogs helped you to get a little bit closer to Microsoft SQL Server.
As to the problem that you mention, you are not alone. This has been on my wishlists also ever since SSMS was introduced with SQL Server 2005. The problem has been reported to Microsoft and is documented at: https://connect.microsoft.com/SQLServer/feedback/details/424800/ssms-expose-connect-to-server-mru-list-to-users#details
Workaround:
As a workaround, here is something that you can try:
- Navigate to : %appdata%\Microsoft\Microsoft SQL Server\100\Tools\Shell (For SQL Server 2008) OR
%appdata%\Microsoft\Microsoft SQL Server\90\Tools\Shell (For SQL Server 2005)
- For SQL Server 2008, delete teh SqlStudio.bin file. For SQL Server 2005, delete the mru.dat file.
- You should now be all set
I hope that the above information helped you, and that you will continue to regularly share your feedback to the community.
As I always say,
Be Courteous. Drive Responsibly.
commented on Jan 20 2011 5:57AM