I usually use Access to work with the data in my SQL Server 2000. Recently I used Enterprise Manager to add a field to a table, then populated the field with data by creating a SQL query in Enterpr...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_23290850.html