Aug 18, 2011

Quick Startup of SSMS

Have you ever noticed how long it takes to start up SQL Server Management Studio (SSMS)?  I always assumed it was because it is the biggest and most powerful tool in my toy box and it deserves the load time.
You can SIGNIFICANTLY reduce the load time by avoiding Microsoft’s marketing message at startup, the splash screen.
To automatically skip over the splash screen follow these simple steps:
1. START ==> RIGHT click the SSMS icon ==> Properties
2. Click the Shortcut tab.
3. Add the option -nosplash at the end of the target string, outside of the quotes.  The final string should look something like:
“C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe” -nosplash
4. Hit OK.
5. Start up SSMS and watch your wait time drop!
This also works with MS Visual Studio.

No comments:

Post a Comment


Thanks for your visit to this blog.
We would be happy with your Queries/Suggestions.