孤兒帳號

CREATE LOGIN [appuser1] WITH PASSWORD='Pa$$w0rd1';
CREATE LOGIN [reportuser1] WITH PASSWORD='Pa$$w0rd1';
EXEC sp_change_users_login @Action = 'Update_One', @UserNamePattern = 'appuser1', @LoginName = 'appuser1';
EXEC sp_change_users_login @Action = 'Report'
drop login appuser1
drop DATABASE TSQL