Drawing the world RSS FEED

MSSQL 2000의 경우

use [데이터 베이스명];
GO

EXECUTE sp_change_users_login 'Auto_Fix','[로그인명]';
GO

MSSQL 2005 이상의 경우

USE [데이터 베이스명];
GO

ALTER USER [유저명]WITH LOGIN = [로그인명];
GO

MSSQL 2005 이상 모든 디비, 모든 유저에 적용

DECLARE @Query nvarchar(4000);
DECLARE QueryCursor CURSOR FOR
	SELECT 'ALTER USER ' + a.name + ' WITH LOGIN = ' + b.name AS Query
	FROM sys.database_principals AS a WITH(NOLOCK)
	INNER JOIN sys.sql_logins  AS b WITH(NOLOCK) ON a.name = b.name
	WHERE a.type IN ('S', 'U')
	  AND b.type IN ('S', 'U');

OPEN QueryCursor;

FETCH QueryCursor INTO @Query;

WHILE @@FETCH_STATUS = 0
BEGIN
	PRINT @Query;
	EXECUTE sp_executesql @Query;
	FETCH QueryCursor INTO @Query;
END;

CLOSE QueryCursor;
DEALLOCATE QueryCursor;
GO