SQL server command needed

[Methu969]

I have an existing SQL 7 server named SERVER1. SERVER1 has a database with some tables in it, the tables have the name SERVER1 in them.

I migrated the database to a second server called SERVER2. When I look into the tables in SERVER2 I still see the name SERVER1 referenced.

What command can I run on SERVER2 to change the references that still show the name SERVER1 in the table called "reportname".

I prefer something I can run in the Query Analyzer.

[degsy]

Welcome :)

It is field names or rows that contain SERVER1?

[Methu969]

The name SERVER1 is actually in a column in the table itself.

[Methu969]

Column1 Column2

\\SERVER1\Reports
\\SERVER1\Reports


I need to change server1 to say server2 for example.