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-01-04 : 08:45:54
|
| Nancy writes "Windows 2000 (SP4), SQL Server 2000 (SP3)I am trying to compare data on SQL Server 2000 to a "linked server" on SQL Server 6.5. I thought my syntax was correct, however I keep getting the error "Invalid object name 'dbo.testdb65.testx'."select * from testdb65.dbo.testxwhere testfield not in (select testfield from testdb2000.dbo.testy)" |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2005-01-04 : 09:11:03
|
| compare'dbo.testdb65.testx' and 'testdb65.dbo.testx' |
 |
|
|
TimS
Posting Yak Master
198 Posts |
Posted - 2005-01-04 : 10:29:47
|
| select * from linkservername.testdb65.dbo.testxwhere testfield not in(select testfieldfrom testdb2000.dbo.testy)"Tim S |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-01-04 : 10:46:24
|
| I don't think that's the code causing the problemAnd you can lose the dbo part...Did you create a login?Brett8-) |
|
|
|
|
|
|
Linked servers (MS SQL Server 2000)