create table #temp(rs varchar(8000)) declare @str varchar(8000) , @i int set @i = 1 set @str = 'cd "C:\Program Files\Microsoft SQL Server\90\COM"' insert #temp values(@str) -- ============================================= -- Declare and using a READ_ONLY cursor -- ============================================= DECLARE cur CURSOR READ_ONLY FOR SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES DECLARE @name varchar(40) OPEN cur FETCH NEXT FROM cur INTO @name WHILE (@@fetch_status <> -1) BEGIN IF (@@fetch_status <> -2) BEGIN if @i = 1 begin set @str = 'tablediff -sourceserver "localhost\sql2000" -sourcedatabase "MuOnlineKor" -sourcetable "' + @name + '" -destinationserver "" -destinationdatabase "MuOnline" -destinationtable "' + @name + '" -q > c:\rs.txt' insert #temp values(@str) end else begin set @str = 'tablediff -sourceserver "localhost\sql2000" -sourcedatabase "MuOnlineKor" -sourcetable "' + @name + '" -destinationserver "" -destinationdatabase "MuOnline" -destinationtable "' + @name + '" -q >> c:\rs.txt ' insert #temp values(@str) end --insert #temp exec master..xp_cmdshell @str set @i = @i + 1 END FETCH NEXT FROM cur INTO @name END CLOSE cur DEALLOCATE cur select * from #temp drop table #temp