What method uses Subset to access the MS SQL Server database

Situation

DATPROF Subset accesses the source database from the target database using various techniques, such as ad hoc queries or linked servers. Which method does Subset use?


Explanation

DATPROF Subset uses the "Ad hoc queries" to access the remote database.

Both OPENROWSET and OPENDATASOURCE are used.

To allow for these connectiontypes the database should have "Ad hoc queries" enabled.


https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/ad-hoc-distributed-queries-server-configuration-option?view=sql-server-2017