Wow, it only took me way to many years to learn this...

[Mike Winiberg]

In Outlook - you can delete the remembered email addresses that pop up when you start typing in the To box. Far to easy to delete the wrong one though...

[John Bevan]

If it helps, you can find this info on the `SqlStudio.bin` file (under `%AppData%`). Here's some PowerShell to help make sense of the file's content: Get List of Servers from SSMS (i.e. historically used connections list from the New Connection dialogue) · GitHub[^]

Add-Type -Path (Get-Command 'Microsoft.SqlServer.Management.UserSettings.dll').Source
[bool]$loaded = $false
Get-Item -Path 'C:\Windows\assembly\GAC_MSIL\Microsoft.SqlServer.ConnectionInfo\*\Microsoft.SqlServer.ConnectionInfo.dll' | Select-Object -ExpandProperty FullName | Sort-Object -Descending | ForEach-Object {if (!$loaded ){try {Add-Type -Path $_;Write-Verbose "Successfully loaded $_";$loaded=$true}catch{Write-Warning "Failed to load $_"}}}

[string]$settingsFilePath = (Resolve-Path (Join-Path -Path $env:APPDATA -ChildPath 'Microsoft/SQL Server Management Studio/*/SqlStudio.bin')).Path | Sort-Object -Descending | Select-Object -First 1
if ($settingsFilePath) {
try {
[System.IO.MemoryStream]$ms = [System.IO.File]::ReadAllBytes($settingsFilePath)
[System.Runtime.Serialization.Formatters.Binary.BinaryFormatter]$formatter = New-Object -TypeName 'System.Runtime.Serialization.Formatters.Binary.BinaryFormatter'
[Microsoft.SqlServer.Management.UserSettings.SqlStudio]$sqlStudio = $formatter.Deserialize($ms) #[Microsoft.SqlServer.Management.UserSettings.SettingsDictionary[[System.Guid],[Microsoft.SqlServer.Management.UserSettings.ServerTypeItem]]]
foreach ($serverTypeItem in $sqlStudio.SSMS.ConnectionOptions.ServerTypes.Values) { #[Microsoft.SqlServer.Management.UserSettings.ServerTypeItem]
foreach ($server in $serverTypeItem.Servers) { # [Microsoft.SqlServer.Management.UserSettings.ServerConnectionItem]
([PSCustomObject][Ordered]@{
Instance = $server.Instance
AuthMeth = ([Microsoft.SqlServer.Management.Common.SqlConnectionInfo+AuthenticationMethod]$server.AuthenticationMethod)
Connections = $server.Connections
})

        }
    }
} finally {
    $ms.Dispose()
}

} else {
throw 'Could not find SqlStudio.bin. Older versions used MRU.dat... but I''ve not coded a solution for that, sorry!'
}

The connection settings are held in a di

[DerekT P]

Sounds horrendously dangerous to me - especially without any confirmation dialog. So I'm typing some SQL into a query window - move the mouse "out of the way" so I don't have the pointer over the query text, and hit "delete" because I want to change what I'm typing... wham! Server connection gone. That might be a client's server I'm responsible for administering, but haven't separately saved (written down) the password; now I'm stuffed, especially if it's 11pm on a Saturday night and I need to do maintenance on that server... :-( If the hover/delete combo is obscure, just how obscure will the documentation be that allows me to disable this "feature"...? :wtf: :doh: When building a UI, I never provide the ability to delete anything non-trivial without confirmation.

[RustyF]

Works in outlook too when you are typing the to: address, allows you to delete old recipients

[dandy72]

Where have I mentioned there was no confirmation dialog? Besides...in all use-cases I've implemented this, the removable items only appear as a result of an action like a right-click, which makes the removable item(s) appear; "moving the mouse out of the way" is never enough to make said removable items appear on their own, so what you're describing is rather unlikely to happen. You want to talk about dangerous - how about you're in the middle of typing a long paragraph of text, then some random Windows message pops up, defaulting with the focus on OK, and you happen to hit Space or Enter as you continue typing (before you might not even have realized something came up and stole focus away). The dialog box thinks you've confirmed the action it was asking of you, but it was on the screen for such a short amount of time you have no idea what it said or where it even came from. True story, and I can confirm it's happened to me repeatedly.

[jackbrownii]

> dandy72 wrote: > Where have I mentioned there was no confirmation dialog? SSMS does not give a confirmation dialog using the technique the OP mentioned.

[dandy72]

I was elaborating on a direct response to the message where I said I try to implement the same. If SSMS doesn't prompt for confirmation when deleting something important, then that's its problem, not mine. :-)

[DerekT P]

Sander said:

Quote:

It turns out you can just open the list, hover over a server name and press delete on your keyboard and it'll be gone (without warning).

I interpreted the "without warning" bit as meaning there's no confirmation prompt...? You mentioned you were adding the same functionality in your own apps... but clearly you're implementing an improvement over Microsoft's attempt! :)

[dandy72]

Well, I always try to do that much. Sometimes the bar is pretty low. :-)

[Nick Schwertfeger]

First!

Wow, it only took me way to many years too learn this...

Wow, it only took me way to many years two learn this...

Wow, it only took me way to many years 2 learn this...

Wow, it only took me way to many years to learn this...

Wow, it only took me way two many years too learn this...

Wow, it only took me way two many years two learn this...

Wow, it only took me way two many years 2 learn this...

Wow, it only took me way two many years to learn this...

Wow, it only took me way 2 many years too learn this...

Wow, it only took me way 2 many years two learn this...

Wow, it only took me way 2 many years 2 learn this...

Wow, it only took me way 2 many years to learn this...

Wow, it only took me way too many years too learn this...

Wow, it only took me way too many years two learn this...

Wow, it only took me way too many years 2 learn this...

Wow, it only took me way too many years to learn this...

Gammr is hard? To, two, and too | Frequently confused words | Usage | Grammar - YouTube[^]

[Sander Rossel]

Did you forget your meds? :confused:

Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly