GlacierIs there any way to change the way query and file names are rendered in the tabs?

When I use the program, it starts each tab name with the fully-qualified domain name (fqdn) of the server and then only shows about 10 characters from the .sql filename (it shortens the fqdn on the right and the filename on the left).

For example: ftlabcsql01.mycompany.ne...eries to test.sql*

I really don't need to see the fqdn of the server on every tab.  I'd like to see more of my file names.

Thanks!

---Wayne Erfling

Hello Wayne,

There's been lots of feedback on that.

If you feel strongly vote for the suggestion https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124480



Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

I voted - thanks for the link. --- Wayne
  Hello Wayne,

  There's been lots of feedback on that.

  If you feel strongly vote for the suggestion https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=124480



  Simon Sabin
  SQL Server MVP
  http://sqlblogcasts.com/blogs/simons

Wayne Erfling (wayne_erfl***@mindspring.com) writes:
No, there isn't any way. Yes, there desperately needs to be.

You can avoid the FQDN though: in SQL Configuration Manager, set up an
alias for the server, and then user this alias when you connect. SSMS
should display your alias, not the FQDN in this case.

I tried to do this in response to your post, or at least I think I tried, but I can't see any difference.

Plus, the Help topic How to: Set a SQL Server Alias (SQL Server Management Studio)

contains this warning: SQL Server Agent will not work correctly unless you select an alias that refers to the local instance of SQL Server.

I am not working with the local instance.

Is there any way to create an alias for a network server?

---Wayne

  Wayne Erfling (wayne_erfl***@mindspring.com) writes:
  No, there isn't any way. Yes, there desperately needs to be.

  You can avoid the FQDN though: in SQL Configuration Manager, set up an
  alias for the server, and then user this alias when you connect. SSMS
  should display your alias, not the FQDN in this case.


  --
  Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

  Books Online for SQL Server 2005 at
  http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
  Books Online for SQL Server 2000 at
  http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Wayne Erfling (wayne_erfl***@mindspring.com) writes:
The place to define an alias, is in the SQL Server Configuration Manager,
under SQL Native Client configuration. I just tested using one of alias
in Mgmt Studio, and it worked fine.

What you found is something for SQL Agent (that I've never seen before).

Excellent!  Thanks!  Help led me astray
  Wayne Erfling (wayne_erfl***@mindspring.com) writes:
  The place to define an alias, is in the SQL Server Configuration Manager,
  under SQL Native Client configuration. I just tested using one of alias
  in Mgmt Studio, and it worked fine.

  What you found is something for SQL Agent (that I've never seen before).

  --
  Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

  Books Online for SQL Server 2005 at
  http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
  Books Online for SQL Server 2000 at
  http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Help with SQL 2005 and Sourcesafe 6
SSIS and polling
Little Lock Symbols
SQL - Fast LOCALHOST , Slow IP
Database Tuning Advisor question (against sql server 2000 trace fi