How To Change The Database Context And Modify Tables?

I have 30+ databases in sql 2000.

I want to dynalically loop though each of the databases and alter a column named 'EmpName' for all the 'Employees' tables in that database.

Here is my attempt.use Master

go

declare @SQLString Nvarchar(1000)

declare @DBName Nvarchar(100)

declare @SQL2 NVARCHAR(1000)declare @TABLE_NAME NVarchar(100)

DECLARE curDB CURSOR LOCAL FORWARD_ONLY STATIC FOR

SELECT name FROM sysdatabases

OPEN curDB

FETCH NEXT FROM curDB INTO @dbname

While @@FETCH_STATUS=0

Begin

      SET @SQL2 = 'USE ' + @DBNAME + ' ALTER TABLE ' + @TABLE_NAME + ' MODIFY EmpName varchar(100)'

     from information_schema.tables where table_type = 'BASE TABLE' and table_name like '%Employees%'      PRINT @SQL2

      EXECUTE SP_EXECUTESQL @SQL2

fetch next from curDB into @DBName

end

Close curDB

End

When i execute the above script in master, it says 'Query executed successfully' but when i see the all the Employees table in each of the database, the required change is not made.

Can anybody explain this or give an alternate solution?