Alternative for dbo.SYSREMOTE_TABLES

[sahithyajayan7]

I could find this 
Function SYSREMOTE_TABLES has changed or does not longer exist after SQL Server 2005.

Can anyone suggest any alternative to use this in 2022 sql server. 

[#2]

Try use system stored procedure master.sys.sp_tables_ex like this: EXEC master.sys.sp_tables_ex @table_server= 'remote_server_name', @table_catalog= 'dbname' Check document https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-tables-ex-tra...