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-18 : 08:05:24
|
| ayat writes "IS there any way to separate the SQL engine from its database to be on two different linked servers?" |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-07-18 : 09:26:52
|
| I mam not quite sure what you are asking. If you setup a linked server and use the four part server name I believe the the query uses the "SQL Engine" on the SQL Server you are connected to. If you use OPENQUERY I believe the query is processed on the server you are linking to.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own.I am available for consulting work. Just email me through the forum. |
 |
|
|
|
|
|
SQL Engine and Database