Hi
Does anyone know if there are any restrictions in the workflow engine regarding the use of temporary tables in the CommservDBQuery activity? In the SSMS the query works fine.
![](https://uploads-eu-west-1.insided.com/commvault-eu/attachment/edd545a1-6e71-4632-954f-e91a882625b4.png)
When I run the above SQL query in the debug mode, I don’t get any output:
![](https://uploads-eu-west-1.insided.com/commvault-eu/attachment/2d993cfb-48d3-4df9-a751-7dfe06c1508a.png)
I also tried to use a table as variable, which did not work either.
The workflow engine runs on a dedicated server. Could this cause the issue?
Thanks for your inputs
Michael
Best answer by Yeshwanth
View original