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 - 2006-09-22 : 10:23:02
|
| Matthew writes "I have a linked server to an AS400. For some reason I can not access some logical files on the AS400 (I only see a partial list). I have confirmed the logical files exists and that the linked server login has access to the logical files. Any ideas as to why I can not see all the files/logical files? Is there some SQL server limitation with linked servers?" |
|
|
TRACEYSQL
Aged Yak Warrior
594 Posts |
Posted - 2006-09-24 : 10:25:00
|
| On the login ....put the database you want to see ..not master else it only lists the tables in master.So if your database is called MYDATABASE set the default user login to this |
 |
|
|
|
|
|
Linked Server remote tables/views not accessible