on 2020 Oct 01 12:03 PM
I have created a proxy table in my local DB as shown below. Using SQL Query I want to find to which Remote DB this Proxy Table PT is configured? I couldn't find this in sysobject table.
CREATE PROXY_TABLE PT AT 'REMOTE_SERVER.DB_NAME.dbo.TABLE_NAME'
Run in the database where proxy tables are created
exec sp_helpobjectdef for all proxy tables in a database
exec sp_helpobjectdef <tableName> for specific a table in a database
HTH
Avinash
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.