This site is a way for me to share photos and blog posts.
The blog will not be a diary, but instead a way of storing technical solutions and information.
As a professional computer programmer (and part time DBA/SysAdmin) it is a daily occurrence that I need to figure out technical solutions. And being human, I regularly forget what those solutions were.
So the blog is a way for me to quickly find the answer I've already worked out once, and hopefully other people on the web will discover them and find the information useful.
It will not be regularly updated!
Latest Blog...
Align SQL Login to User
How to re-align a SQL Login to a Database User
In SQL Server there are two distinct security level when it comes to individual users... one at the server level, the other at the database level.
If a database is restored from a different location, then despite the there being a server login and database user with the exact same name, they are different objects and do not therefore align with each other.
Instead of removing either and re-implementing, simply use the following...
ALTER USER OrphanUser WITH LOGIN = correctedLoginName;