Posted by Erland Sommarskog on 02/24/06 01:19

News East (Methu969@yahoo.com) writes:
> 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

Rather than having the servername in a table, you could @@servername.
As a compromise you could change the column to a computed column:

col AS @@servername


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

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

[Reply to this message]