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 |
|
PLITZKE
Starting Member
1 Post |
 Posted - 2011-08-16 : 04:09:50
|
| Hi,my name is Michel.I've got a question to linked servers.Is it possible to link from one sql to another sql db, the databases are on the same server.I tested the linked server from a sql to a db2 db (on one server), that's ok.Maybe, it's a security problem ?Thanks in advanceMichel |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2011-08-16 : 05:32:57
|
| If the databases are on the same instance, just use 3 part naming.SELECT * FROM DatabaseName.Owner.TableName |
 |
|
|
|
|
|
linked server