Stored Procedure - Visibility

(0) Share

Report

Posted on by sushinee

Hello is there a trick to get your stored procedure visible using the SQL Stored Procedure connector?

When I use the connecting and connect to my DB I cant see any of my stored procedures listed.

I know it connects fine to the DB because Iʻm able to use GET ROWS on the same DB.

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Christopher S Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @sushinee

I just created a test Flow and I'm able to view my store procedures:
"procedure_name" is the name of my store procedure:
If you indicate that you are able to use Get Items then you are able to reach the database, can you please confirm if actually the store procedures are there? Also, please paste the error message you are getting.

Best Regards,
--
If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions help users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
sushinee 11 on at

Like (0)

Report
Copy link

Link copied!

Hi @chsanche

the procedure is in the DB. I can execute in SMSS. However I donʻt see it listed when I use the execute stored procedure (v2).

My work around is to have SQL agent create a table and Iʻve been using that table for my flow. However I would prefer if it I can just execute the procedure instead of doing an intermediary step through SQL agent.

Was this reply helpful? Yes No
Verified answer

sushinee 11 on at

Like (0)

Report
Copy link

Link copied!

update --- figured out the problem was.

My onprem connector using a sql account that mainly was db_reader... had to check off the other db_roles........ and I see the procedure.

Was this reply helpful? Yes No