Search This Blog

Wednesday, July 20, 2016

SQL SERVER – Clear Dropdown List of Recent Connection from SQL Server Management Studio








For SQL 2005, delete the file:

C:\DocumentsSettings\<USER>\ApplicationData\Microsoft\MicrosoftSQL Server\90\Tools\Shell\mru.dat

For SQL Server 2008, delete the file::

C:\Documents and Settings\<user>\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\mru.dat
C:\Documents and Settings\[user]\Application Data\Microsoft\Microsoft SQL Server\100\Tools\ShellSEM\mru.dat




6 comments :

Unknown said...

am amazed i am reading the articles one by one since yesterday night and every time i find a new article grabbing my attention within a post.It guides us tolearnmore about SQL server managements


Best Dot Net Training Institutes in Chennai

Jones said...

For Clear Idea:

Delete mru.dat file from following location.

For SQL Server 2005:
C:\Documents and Settings\\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru.dat

If you can not find mru.dat at above location look for mru.dat in following folder.
C:\Documents and Settings\[user]\Application Data\Microsoft\Microsoft SQL Server\90\Tools\ShellSEM\mru.dat

For SQL Server 2008:
C:\Documents and Settings\\Application Data\Microsoft\Microsoft SQL Server\100\Tools\Shell\mru.dat

If you can not find mru.dat at above location look for mru.dat in following folder.
C:\Documents and Settings\[user]\Application Data\Microsoft\Microsoft SQL Server\100\Tools\ShellSEM\mru.dat

If you are using VISTA OS instead of XP OS. Replace C:\Documents and Settings\[user]\Application Data\Microsoft\ with
C:\Users\\AppData\Roaming\Microsoft\ and it should work.

Make sure to take note down any IP address of SQL Server you may need in future.

More Info: Dot Net Training in Chennai | <a href="http://www.bestdotnettraininginchennai.com/'>Dot Net Training Institute in Chennai</a>

Jones said...

The .NET framework helps you create mobile, desktop, and web applications that run on Windows PCs, devices and servers and it's included in Visual Studio.

Develop web sites and services that run on Linux, Windows and macOS with the blazing fast and modular platform provided by .NET Core and ASP.NET Core.

Xamarin brings the power and productivity of .NET to iOS and Android, reusing skills and code while getting access to the native APIs and performance.

Dot Net Training in Chennai

Best Dot Net Training in Chennai

Best Dot Net Training Institute in Chennai

Unknown said...

Hey Very nice Blog,Thanks For Sharing..

Best Php industrial training in Lucknow
best summer training in lucknow
Embedded system training in lucknow
Best Industrial training company in lucknow
best Php training center
java institutes in Lucknow

Unknown said...

Really a good technical site,keep on writing good stuffs
dot net training in chennai

Realtime Experts said...

Thanks for sharing your post with us.Dot Net Training in Bangalore