How to change connection properties in SSMS as you connect, like using named pipes instead of TCP/IP, as I do for one of our servers. Screenshots show each step.
SQL SERVER – 2005 – Open SSMS From Command Prompt – sqlwb.exe Example
Open SSMS from command prompt with the sqlwb command. I show its syntax and the switches I use, like -E and -nosplash, to start Management Studio.
SQL SERVER – 2005 Query Editor – Microsoft SQL Server Management Studio
Where is the Query Editor in SQL Server 2005? It is part of SQL Server Management Studio, and I list the enhancements it brings over older tools.
SQL SERVER – 2005 – SSMS – Enable Autogrowth Database Property
How to enable Autogrowth for a database in SSMS: open the database Properties, go to Files and click the small button in the Autogrowth column.
SQL SERVER – 2005 Change Database Compatible Level – Backward Compatibility – Part 2 – Management Studio
How to change database compatible level in SQL Server Management Studio: right click the database, open Properties, then Options, and pick the level you need.
SQL SERVER – 2005 – SSMS Change T-SQL Batch Separator
A big script used EndBatch instead of GO. Rather than a risky mass replace, I changed the Batch Separator in SSMS under Tools, Options, and it ran as is.
SQL SERVER – 2005 Query Analyzer – Microsoft SQL SERVER Management Studio
Looking for Query Analyzer in SQL Server 2005? It moved into SQL Server Management Studio. Where to find it and tips to feel at home there.