Animation speeds in SQL Server Management Studio

Wow, I can’t believe this is not available in the options and that we have to resort to edit config files.

Anyway, big thanks to Euan for this tip :

  1. Close SQL Server Management Studio.
  2. Open this file in a text editor
    Win XP: C:\Documents and Settings\<username>\My Documents\SQL Server Management Studio\Settings\CurrentSettings\<yyyy-mm-dd>.vssettings
    Win Vista/7:
    C:\Users\<username>\Documents\SQL Server Management Studio\Settings\CurrentSettings\<yyyy-mm-dd>.vssettings
  3. Search for “AnimationSpeed” and replace the existing value (5) with your desired speed; 10 being the fastest choice, I do not know what is the lowest (1?). Save.
  4. Open SQL Server Management Studio and it should now animate at your desired speed.

A couple of notes:

  • <yyyy-mm-dd> is a time stamp because several versions of the config file are saved with different names. Obviously, you will want to edit the one with the most recent date
  • In addition to setting the animation speed, there is also a setting called Animation that can be set to false and will eliminate the animations altogether.