In the SSMS 2008 "Connect to Server" list I had setup a new user on a database and tested it. Now that user is popping up by default every time I open SSMS and when I select my connection in the drop down list, it now requires a password and won't auto-log me in.
How do I get rid of that person in my list and get it to save my password? I keep selecting the "Remember Password" check box and it just ignores it and doesn't remember anything.
It is not possible to just "get rid of that person in my list " but to clear/reset the entire list:
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…