Posted by News East on 02/23/06 03:09

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

• Next in forum: Script needed to edit open objects in Sybase
• Prev in forum: Re: Joing Multiple Columns
• Thread view: SQL command needed to edit table data

[Reply to this message]