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 |
|
drp1drp
Starting Member
2 Posts |
 Posted - 2008-11-10 : 17:20:46
|
| Thanks in advance:I have two sql servers (2000) linked. I can run this query using the master db: select top 10 * from ServerName.Master.dbo.sysdatabases. However, if i try the same statement on another db and table i get the "Invalid Object Name". Here is the statement: select top 10 * from ServerName.[Db_Name].dbo.[IM2_InventoryItemWhseDetl] |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-10 : 17:40:26
|
| Does login has access to tables in other server? |
 |
|
|
drp1drp
Starting Member
2 Posts |
Posted - 2008-11-11 : 08:25:43
|
| Yes. Using a SA login on the sercurity of the Link. I am able to query tables in the Master db on that server. |
|
|
|
|
|
|
Linked Sql Server Invalid Object name