Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-07-13 : 07:48:51
|
| akoni writes "I am a java programmer with the task of archiving a production database and sending the information to a separate archive database written in java. My delimma is trying to toggle between the two databases on the same server. Once I make the origianl connection to query the table to be copied I get an error when closing it and trying to open up another connection to the second database to be updated. Is this possible or am I wasting company time?" |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-07-13 : 08:07:30
|
| Cant you use DBname..TableName approach in your query?MadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Is it possible to switch between two different databases?