I am always flooding my desktop with open windows while developing. Showing the desktop is a must have in a situation where you need to switch gears for a few minutes. Windows 10 has the show desktop built in right out of the box. Simply click the small button in the lower right hand corner.
Wednesday, December 20, 2017
Wednesday, December 6, 2017
Auto Fix Orphaned User
When restoring a database to a new or different instance, logins at the instance level are not mapped to the database users. SQL SERVER has a built in stored procedure to help us identify orphaned users, sp_change_users_login. We can also use this stored procedure to fix the mapping if the login exists at the instance level. Finally, if we need to create a new login for the existing user, we can create a login and password. See the below examples.
Subscribe to:
Posts (Atom)