Orphaned DBO Woes

When working with SQL you'll often run into this problem

It arises when a database owner User Id exists without a Login ID or Login Password

First Find Your Orphans

(substitute into brackets)

USE ['Database'];
GO
EXEC sp_change_users_login 'Report';
GO

Now Repair That

Then create a new Login ID and Login Password for the orphaned User Id

(substitute into brackets)

USE ['Database']
GO
EXEC sp_addlogin ['NEW LOGIN ID'], ['NEW LOGIN ID PASSWORD'], ['DATABASE']
EXEC ['Database'].['INFORMATION SCHEMA'].sp_change_users_login 'Update_One', ['USER ID'], ['NEW LOGIN ID']
Go