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
@soutamo 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 .