Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

clr_service_query

From version 8.0.2 clr_service_query, clr_bulkfile and their functions are deleted. Clr_bulkfile is not used that often, but clr_service_query is called on by using the function [dis].[f_remote_query], and is used by some clients to do selects against other databases.

The deletion of these assemblies means that the database does not need to be trustworthy anymore, but it also means that clients that uses these assemblies to make the selects against other databases can't do that anymore.

You can check if clr_service_query is used in the database by running the script:

exec app.p_findstring 'remote_query'

The script returns a list of procedures that use the function. The only procedures that should be shown are:

  • app.p_get_dataivew_enums.
  • dis.p_remote_query

If more procedures are displayed, the function is used and the assembly must be created by running a script from the Assemblies folder in DBWizard. Begin with running the script clr_service_query in the database where the function is needed. If needed, also run the other script clr_bulkfile from the folder Assemblies.
Published:

clr_service_query

From version 8.0.2 clr_service_query, clr_bulkfile and their functions are deleted. Clr_bulkfile is not used that often, but clr_service_query is called on by using the function [dis].[f_remote_query], and is used by some clients to do selects against other databases.

The deletion of these assemblies means that the database does not need to be trustworthy anymore, but it also means that clients that uses these assemblies to make the selects against other databases can't do that anymore.

You can check if clr_service_query is used in the database by running the script:

exec app.p_findstring 'remote_query'

The script returns a list of procedures that use the function. The only procedures that should be shown are:

  • app.p_get_dataivew_enums.
  • dis.p_remote_query

If more procedures are displayed, the function is used and the assembly must be created by running a script from the Assemblies folder in DBWizard. Begin with running the script clr_service_query in the database where the function is needed. If needed, also run the other script clr_bulkfile from the folder Assemblies.
For an optimal Community experience, Please view on Desktop
Powered by Zendesk