Skip to main content
Skip table of contents

What method uses Subset to access the MS SQL Server database

Situation

DATPROF Subset accesses the Source database from the Target database. There are several techniques for doing this, Ad hoc queries or linked server. What does Subset?


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




JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.