How to return a list of tables that were used from a linker server database in my Stored Procedure

Question

In my DB, we have all Stored Procedures that selecting data from tables of linked server database.

For example: the Employee table in our SP_Employee Stored Procedure in our server is extracting data from:
select * from [LinkedServer].[IBM].[dbo].[Employee] em left join [LinkedServer].[IBM].[dbo].[HR] hr on em.ID=hr.ID.

So right now, if i just want to get a list of those 2 linked server table names: 'Employee' &' HR' from my Stored Procedure, how to do that? write a script or cursor to extract those 2 names from my SP_Employee? thanks

question from:https://stackoverflow.com/questions/65853277/how-to-return-a-list-of-tables-that-were-used-from-a-linker-server-database-in-m

Answer 1

Waitting for answers