February 23, 2016 at 2:22 pm
Hi,
We have a linked server setup. AS400.
We are using the option be made using this security context.
I can't able to see all the tables.
Clicked on Linkedserver then Catalogs then DB name then Tables. There is only one schema is available.
But I know there are other schema exists on the destination.
I can able to run the select using the 4 part name. Here the schema name is different what I can see under the linked servers but still I am getting the results.
So surely there are some other schema.tables that I can't able to see under the linked server.
sp_tables_ex linkedservername is giving the same what I can see under the linked servers.
http://www.sqlservercentral.com/Forums/Topic1287165-391-1.aspx
February 23, 2016 at 3:22 pm
When I run the the query
EXEC sp_tables_ex @table_server = 'LinkedServername', @table_catalog='DBName', @table_schema='Test'
I can see all the tables under the test schema
but when I run EXEC sp_tables_ex @table_server = 'LinkedServername', @table_catalog='DBName'
but when I run this I can see only one schema 'Test1' but not able to see the schema Test. This is the same schema that I can able to see from the SSMS also
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply