Silly tab names in SS2005

If like me you write tons of ad-hoc queries in SQL Server 2005 Management Studio then you may get annoyed by having lots of tabs called ‘Servername.DBna…SQLQueryXX.sql’.

Management Studio isn’t even smart enough to name them something sensible when you right-click a View, Store Procedure, or Function and do Alter.

There is an article on connect which states this isn’t fixed until Katmai.

There’s also a workaround posted by Erland Sommarskog which puts the behaviour back to how it was in Query Analyser

1. Click Tools > Options…
2. Expand the Environment node and click General
3. Under “Environment Layout”, select the “MDI Environment” option button
4. Click OK


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 )

Google photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s