No it gives the same error message

however i was just trying some commands and i found that the following works and returns all the tables.

exec sp_tables_ex @table_server = 'ORCNOTNS'

I dont understand what is wrong with select query.