NAVIGATION
CATEGORIES
REFERRENCE
LINKS
SQL command needed to edit data in a table
1 answers - 824 bytes -
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 nameNo.1 | | 901 bytes |
| 
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?
QUESTION ON "Databases"
- Need help with a Sybase script to set the number of open objects.......HELP
- how to avoid procedure recompile
- Stored procedure
- Random fixed length string in mysql?
- Looking for a good log parser/notifier for Sybase
- Any ideas regarding SQL procedure?
- how to access locked SA login to which password is also not known
- Not getting isql prompt
- how to access locked SA login to which password is also not known
- database design
- Huge number of tables?
- Free Databases with GUI Interface
- Sybase Query Tree
- Database or store to handle 30 Mb/sec and 40,000 inserts/sec
- get all rows that have status < 3
- Choosing "a SQL" or "an SQL"
- How to retrieve the date part of a DATETIME column via (T-)SQL?
- Need a way to maintain sorted records for long periods of time. "select into" temp table?
- Need to reconnect to ISQL
- What is wrong with this simple SQL code