SQL SERVER 2005 - CHANGER LE OWNER DE TOUS LES SCHEMAS

USE [MaBase]
GO

DECLARE @NewOwner	AS VARCHAR(50)
DECLARE @SQLCMD		AS VARCHAR(MAX)	

SET @NewOwner = 'NouveauOwner'

DECLARE CURSORLISTCHEMA CURSOR FOR SELECT 'ALTER AUTHORIZATION ON SCHEMA::['+ SCHEMA_NAME +'] TO ['+ @NewOwner +']' 
			FROM INFORMATION_SCHEMA.SCHEMATA WHERE NOT (SCHEMA_OWNER LIKE 'db_%' 
					OR SCHEMA_OWNER = 'INFORMATION_SCHEMA' 
					OR SCHEMA_OWNER = 'guest' OR SCHEMA_OWNER = 'sys')
					AND NOT (SCHEMA_OWNER = @NewOwner)

OPEN CURSORLISTCHEMA
FETCH NEXT FROM CURSORLISTCHEMA INTO @SQLCMD
WHILE (@@fetch_status >= 0) 
	BEGIN 
		PRINT @SQLCMD
		EXECUTE(@SQLCMD)
		FETCH NEXT FROM CURSORLISTCHEMA INTO @SQLCMD
	END
CLOSE CURSORLISTCHEMA
DEALLOCATE CURSORLISTCHEMA