News West wrote:
> I have an existing SQL 7 server named HHARBR. HHARBR has a database named
> SPR with a table named "reportname" in it, the table has the name HHARBR
> embedded the table data.
>
> I migrated the HHARBR database SPR to a second server called HHARBR2. When I
> look into the table in HHARBR2 I still see the name HHARBR in the data.
>
> What command can I run on HHARBR2 to change the table entries of HHARBR to
> the new server name of HHARBR2?
>
> I prefer something I can run in the Query Analyzer
>
> Source server: HHARBR
> Source Database: SPR
> Source Datbase Table: reportname
>
> Destination Server: HHARBR2
> Destination Databse: SPR
> Destination Table: reportname
>
> Summary:
> Change wrong server name in destination server to reflect the destinations
> server name
>
>

have you considered to get some training first?