Unanswered

Exec SQL Query Not Returning Results

(1) Share

Report

Posted on by srduval

1,760 Moderator

I am having problems with exec Sql query not returning the results of an exec sp query. Anyone else having this issue today? I've used it numerous times and never once had it not return an output if there was records to be had. I've checked the same query in SSMS and it returns results.

I'm using an azure SQL database.

This will return records

SELECT * FROM dbo.sys_LiveQuery

this doesn't (but in SSMS it does)

EXEC dbo.Results_Core_Output

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Michael E. Gernaey 53,452 Super User 2025 Season 2 on at

Like (0)

Report

HI @srduval

I would suggest the following

1. Run SQL Profile and run a test, see who the connection comes in as, and the query runs, and the results it says you get, as the Connector itself, by proxy isn't going stop results unless something is configured wrong

2. Verify permissions. If you do step #1 you should easily see if the account running the query has permission to the table and can run etc etc.

3. Wrong instance of SQL Server/Database, just verify for sure you dont have multiple copies and that you are in fact hitting it correctly (which #1 will do as well)

Also, look at the flow run itself, are you certain the output is zero rows and not an issue with the rest of the flow?

Are you using SPNs? User Account? etc.

The biggest is simply #1 should take no more than a few moments then look and see what account/issues it might have had.

That or you are hitting the wrong instn

Was this reply helpful? Yes No
srduval 1,760 Moderator on at

Like (1)

Report

Thanks @Michael Appears the issue was something as simple as a duplicate column name in the output that I wasn't catching. You'd think MS would help us help ourselves to prevent something this simple.

Was this reply helpful? Yes No
Michael E. Gernaey 53,452 Super User 2025 Season 2 on at

Like (0)

Report

Glad you found the issue

Was this reply helpful? Yes No