USE master
GO

EXEC sp_addlogin 'NEOE', 'NEOE','NEOE'
GO

CREATE LOGIN [NEOE] WITH PASSWORD='ejwhs123$', DEFAULT_DATABASE=[NEOE], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
GO

ALTER LOGIN [NEOE] ENABLE 
GO

USE NEOE
GO

EXEC sp_grantdbaccess 'NEOE', 'NEOE'
GO

SP_CHANGE_USERS_LOGIN 'UPDATE_ONE' , 'NEOE','NEOE'
GO

ALTER USER NEOE WITH DEFAULT_SCHEMA = NEOE;
GO