Hello,
I have a query which works properly and returns value in MS SQL. But when the same query is executed via DB connect , its returning no rows returned.
Below is the sample of that query not the original one
SELECT * FROM (SELECT abc.row, abc.rsa, abc.desc, CASE WHEN resTyp = 'OBJECT' THEN objNa(abc.rsa) ELSE objNa(pt.OBJECT_ID) END AS objNa, abc.resTyp, abc.reqMod, abc.reqStat FROM sys.abc LEFT JOIN sys.pt ON pt.hobt_id = abc.rsa WHERE rsa > 0 AND resource_database_id = DB_ID('Database1')) as locks ORDER BY objNa
The same is returning rows in MS SQL not in db connect. Please help what is causing the issue in above query
Did you run this in search app? If yes, please check errors in search.log by inspecting search job. Thanks.
Hi
are you running those as same user on both way? Check which user is used in identity definition.
r. Ismo
Which version you have:
Have you a working connection and any working queries?
@isoutamo Yes its a working connection and we have executed many queries which are working properly in db connect. But certain queries are not working like I have posted before and even the stored procedures are not working. The DB connect is installed in Enterprise Splunk .
Can you tell those version infos?