Bulk modifying the schema of SQL Server 2008

--Modify the schema in bulk. All tables with the name Xjadminatt are modified to dbo----Copy the result of the execution to the command line and execute the command--Declare @namesysnameDeclareCsr1cursor    for   Selecttable_name frominformation_schema. TABLESOpenCSR1FETCH NEXT  fromCsr1 into @name    while(@ @FETCH_STATUS=0)   BEGIN   SET @name='Xjadminatt.' + @name   Print 'ALTER SCHEMA dbo TRANSFER' + @name   Fetch Next  fromCsr1 into @name   END   CLOSECsr1

Bulk modifying the schema of SQL Server 2008