[SA 9.0.166 Pro] - Connection indicator + FR

[SA 9.0.166 Pro] - Connection indicator + FR

There are several locations in SQL Editor some connection properties are displayed (see screenshots below)

and

Upon establishing connection the window title, tab title, and tab all show the connection name that is given in SA Options > DB Options > DB Connections, and the status bar shows the server name (second image). Later at some point the former three changes into the word Current concatenated with the server name, and the connection name is gone, making servers with not very talkative names like the localdb server in the example completely unrecognizable. At the same time the color associated with the connection vanishes from the status bar server name.

I'm never going to memorize which connection is #05F2A65, not to mention what to do in case that number changes. Also, a new connection name Current appears in SA Options > DB Options > DB Connections. Which is, I guess that's what SA refers to as CurrentGEMWORKS... and the reason the connection color is reset to No.

Is there a way to alter this behavior? I mean I'd really like if the connection name displayed would not change so suddenly. And the connection name could be displayed in the status bar next to the server name.

If the tabs could be colored the same way the status bar server name is, it would be great. If the whole editor background could be tinted with the extremely faded version of that color, distinguishing connection would not require constant checking of those indicators. For example, it could help prevent accidentally running vastly dangerous code on production servers, like I did just a few moments ago (but I guess I'm aiming too high with that one).

I've seen this as well.

In fact my editor currently shows it (no pun intended)

Last edited by Mindflux on Thu Oct 20, 2016 12:54 pm; edited 1 time in total

Is #05F2A65 part of the database instance name?
What does the "Context" query return as your server name? I means the query from SQL Assistant options for SQL Server.

It is. It is a named LocalDB instance. Context query returns GEMWORKS\LOCALDB#052F2A65, the same that is returned for

	Code:
	SELECT @@servername

The point is that we should not rely on server name for identification. Either because it can be as meaningless as in the example, or simply because any number of servers can have the same server name which makes them indiscernible.

Quote:

It is. It is a named LocalDB instance. Context query returns GEMWORKS\LOCALDB#052F2A65, the same that is returned for

	Code:
	SELECT @@servername

The point is that we should not rely on server name for identification. Either because it can be as meaningless as in the example, or simply because any number of servers can have the same server name which makes them indiscernible.

I see. You can actually change the name of the connection in SQL Assistant settings. In DB Connections section rename it on the left side of the screen to something friendlier, for example, rename to "Sandbox database." After you reconnect this new name will appear in the top title bar and on the editor's tab. Hope this helps.

Er... I guess you missed a few things described in the first post. I'm aware of the ability to rename connections. If you check the screenshot again, you can see that it shows the connection as (localdb)\kapos(GEMWORKS\LOCALDB#052F2A65), that is, in connection name(server name) format, where localdb(kapos) is the connection name and GEMWORKS\LOCALDB#052F2A65 in the brackets is the server name. The problem is that it changes after a while (I don't know what triggers that), and then only Current + server name is displayed.

Yeah I'm not sure what triggers that change either. Mine goes from FRY to CurrentFRY

I guess FRY is both your connection and the name of your server as well, right?

	gemisigo wrote:
	I guess FRY is both your connection and the name of your server as well, right?

Yes

Well, this only causes minor confusion when you've got properly named servers.

	gemisigo wrote:
	Well, this only causes minor confusion when you've got properly named servers.

Doesn't mean it's not annoying!

I just lived with it because I wasn't sure why it was doing that

	Mindflux wrote:
	Doesn't mean it's not annoying! I just lived with it because I wasn't sure why it was doing that

I did not say a word about it not being annoying :) I'm frustrated by it as hell...

I'm pretty sure it's the consequence of that mysterious Current connection getting auto-created. However, the reason behind that one is beyond me. SysOp?

gemisigo wrote:

	Mindflux wrote:
	Doesn't mean it's not annoying! I just lived with it because I wasn't sure why it was doing that

I did not say a word about it not being annoying :) I'm frustrated by it as hell...

I'm pretty sure it's the consequence of that mysterious Current connection getting auto-created. However, the reason behind that one is beyond me. SysOp?

I get connections named (none) and ".", in the DB Connections pane from time to time for who knows what reason.

The same here. I just dumped those mindlessly.

EDIT: I guess those get created when upgrading SA and it merges a few things from the factory.sas with your.sas.

Aside from the tangent we had. Any ideas why "current" ends up in the connection name in the title bar and tabs?