Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
SQL command needed to edit table dataI 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
Post Follow-up to this message
Re: SQL command needed to edit table dataYou didn't give us the column with the reportname table. It'll go something like: update reportname set MyCol = 'HHARBR2' where MyCol = 'HHARBR' -- Tom ---------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinpub.com . "News East" <Methu969@yahoo.com> wrote in message news:cX7Lf.171257$WH.96105@dukeread01... 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
Post Follow-up to this message Re: SQL command needed to edit table dataNews 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/pr...oads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodin...ions/books.mspx
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
