|
dandy72 wrote:
Where have I mentioned there was no confirmation dialog?
SSMS does not give a confirmation dialog using the technique the OP mentioned.
|
|
|
|
|
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. 
|
|
|
|
|
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!
|
|
|
|
|
Well, I always try to do that much. Sometimes the bar is pretty low.
|
|
|
|
|
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...
|
|
|
|
|
I had a similary discovery, that if you open the Alt-Tab panel of running programs, and keep the Alt key down, you can with your mouse close all those windows that you no longer need by mouse clicking their upper right hand X. It may have been around for many years, but I discovered it a few months ago.
|
|
|
|
|
I discovered that many years ago, by accident 
|
|
|
|
|
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)
foreach ($serverTypeItem in $sqlStudio.SSMS.ConnectionOptions.ServerTypes.Values) {
foreach ($server in $serverTypeItem.Servers) {
([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 dictionary, so you can easily use the REMOVE method to pick things out of that list; then serialise to file to persist any changes.
Not quite as easy as deleting through the UI; but useful if you wanted to automate the management of this list in some way (e.g. have scripts preset to change the list according to which system/client you're working with).
modified 12-Aug-19 4:06am.
|
|
|
|
|
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[^]
|
|
|
|
|
Did you forget your meds? 
|
|
|
|
|
Buy his hooks from a second hand store?
Socialism is the Axe Body Spray of political ideologies: It never does what it claims to do, but people too young to know better keep buying it anyway. (Glenn Reynolds)
|
|
|
|
|
Does a modern Captain Hook use web hooks?
|
|
|
|
|
DRHuff wrote: Buy his hooks from a second hand store?
What do you mean Mr McGee? And why are you wearing a Raspberry Beret?
Michael Martin
Australia
"I controlled my laughter and simple said "No,I am very busy,so I can't write any code for you". The moment they heard this all the smiling face turned into a sad looking face and one of them farted. So I had to leave the place as soon as possible."
- Mr.Prakash One Fine Saturday. 24/04/2004
|
|
|
|
|
Mick Martin quoting from a Prince[^] song?
Software Zen: delete this;
|
|
|
|
|
Yes, it was advised to him by Dr.Hook 
|
|
|
|
|
Did you read that on the cover of the Rolling Stone?
Socialism is the Axe Body Spray of political ideologies: It never does what it claims to do, but people too young to know better keep buying it anyway. (Glenn Reynolds)
|
|
|
|
|
No - Sylvia's mother told him.
|
|
|
|
|
Quote: He said captain
I said wot
He said captain
I said wot d'ya want
|
|
|
|
|
|
hmmm, that sounds nice.
gives me an idea... a torch in my rain poncho, even cosier!
Message Signature
(Click to edit ->)
|
|
|
|
|
I'd much rather get rained on.
It really sounds more like a Japanese thing than a Chinese one, though -- Japanese ideas are usually the craziest ones.
I wanna be a eunuchs developer! Pass me a bread knife!
|
|
|
|
|
And just as useless Robotic Tail[^] from a link on the page you lined.
Technician
1. A person that fixes stuff you can't.
2. One who does precision guesswork based on unreliable data provided by those of questionable knowledge.
JaxCoder.com
|
|
|
|
|
The idea itself isn't so weird, except that this already exists...
It goes like this "Hey, I noticed we're going the same direction and you don't have an umbrella, you're welcome to join me, I'm [state your name]."
You'll probably get some weird looks, but after the initial surprise people could get quite sociable (too bad I'm not).
If things hit it off there's a neat little trick to keep in touch, it's called switching out numbers, but it's a secret technique that not many people know of.
There are a few apps available to help in this regard though, the Contacts app comes to mind, as do WhatsApp and Facebook, or maybe even LinkedIn if you're both on your way to work.
Facebook is particularly easy, just say something like "Hey [name], do you mind if I add you on Facebook?" and they'll usually say "Not at all" because they can't really stop you and it's quite easy to block you afterwards.
I've only once shared an umbrella with strangers which was at a festival where we were all cramped together and I just so happened to have an umbrella (actually it was a friend's, but I was holding it at the time).
While it wasn't particularly awkward, no friends were made that day.
The real challenge is being outside in the rain with an umbrella and finding a stranger without one that's also going in the same direction... 
|
|
|
|
|
Seeing I'm unlikely to break into the themed ones...
Throw down the haggard net clipper. (8)
Software rusts. Simon Stephenson, ca 1994. So does this signature. me, 2012
|
|
|
|
|
GAUNTLET?
"Throw down the gauntlet" seems right, and "haggard" == "GAUNT", but I don't see "net clipper" being "LET"?
Sent from my Amstrad PC 1640
Never throw anything away, Griff
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
AntiTwitter: @DalekDave is now a follower!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
