[RESOLVED] can u help me for a simple quey probelm Sql server 2000

[raghunadhs]

Hi All,
I am practising Sql server 2000.
I have a table called "MetaTable" This "MetaTable" has only one field. that field name is "TableName" . and the records of the table are...

TableName
Student1
Student2
Student3

Here the Student1,Student2 are some other table names. and all these tables will have a field called "Sname". the size of this field is 50. Now i have to write a query in such a way that i should alter the size of "sname" as 70, for all the tablenames.(means, the size of "sname" for student1, student2,student3 should be changed from 50 to 70).

I tried a query as follows.....

ALTERTable (Select tableName from MetaTable) 
   ALTER COLUMN sname Varchar(70)

I know the above statement does not work. but i hope it will give u an idea.
If u know it, Pls help me.

Thanks,
raghunadhs.