Help: SQL Server

Sharing my knowlege about SQL Server Troubleshooting Skills

  • Blog Stats

    • 2,050,858 hits
  • Select GETDATE()

    July 2014
    M T W T F S S

Tips and Tricks : Delete Complete History and Settings of Management Studio

Posted by blakhani on July 15, 2014

How many times you have browsed internet and cleared complete history of Internet Explorer (or any other browser)? I have done it many times and due to various reasons. Few days back one of my friend asked that how can same thing be achieved in SQL Server 2014 Management Studio? His goal was to delete all the saved setting of management studio for his login. This would include:

  • Server List and Login credentials saved on login screen.
  • History of reports launched – (Read Pinal’s blogs)
  • Settings change in Object Explorer Details like sorting and ordering of columns.
  • All setting which are saved under Tools > Options in menu bar.

(This does NOT effect registered severs list)

This all information is saved under file SQLStudio.bin.

Below is the file in SQL 2012 Management Studio. (Go to start>run> and paste below path)

%appdata%\Microsoft\SQL Server Management Studio\11.0\SqlStudio.bin

Below is the file in SQL 2014 Management Studio.

%appdata%\Microsoft\SQL Server Management Studio\12.0\SqlStudio.bin


In earlier version of SQL Server (before SQL 2012), the path was different. Refer Jonathan’s blog

Hope this helps.

  • Cheers,
  • Balmukund Lakhani
  • Twitter @blakhani
  • Author: SQL Server 2012 AlwaysOnPaperback, Kindle
  • Advertisement

    Leave a Reply

    Fill in your details below or click an icon to log in: Logo

    You are commenting using your account. Log Out /  Change )

    Facebook photo

    You are commenting using your Facebook account. Log Out /  Change )

    Connecting to %s

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    %d bloggers like this: