Alteryx 2020.2 is not reading the SQL Stored Procedures

[aniket11]

• Connected to Microsoft SQL Server ODBC connection.
• I can read the Stored Procedure with the same connections/permissions in SSMS but cannot read the same in Alteryx.

[randreag]

Hi @aniket11 

I also faced the same problem and for me the solution consist in include this 3 pre requisites

1. Oldb connection from alteryx

2. In the sp it has to be the statement SET NOCOUNT ON

3. It has to have a select (any select at the end, I was updating and wihtout the select it didn't work, I had to added a simple select)

You can try this.

I hope it helps

[aniket11]

I already have all the mentioned 3 pre-requisites and the issues are still the same.

Thanks for the info. though.

[aniket11 · Accepted solution]

Changed the connection to OLeDB from ODBC and it worked. Now showing all the associated SP.