SQL Server 2000

I need to write a script that will find all tables that have a certain column field and change the datatype. Ex:
tblEmployee tblItem tblStore
NoID, Null NoID, Null NoID, Null
Address Address Address

I need to change NoID, Null to Not Null in all three tables. Can this be done with going through every single table one by one? But a nice script that will locate the fields in each table and make the changes.

 

I'll look for one, I'm sure it can be done. but by the time I find one or write one (and I don't have the time to right now) you could have manually changed the data-type contraints.