I'm using MS-SQL management studio and added linked server on my environment.
I can use openquery for my linked server.
select * from openquery(linked_server, 'SELECT * FROM [LIB_NAME].[PF_NAME]')
It works fine.
But, I wanna know if I can change the above expression like this.
select * from [linked_server].[LIB_NAME].[PF_NAME]
Of course, I failed.. Please let me know how this can work.