Forum Discussion
Alternative for dbo.SYSREMOTE_TABLES
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.
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-transact-sql?view=sql-server-ver16