SQL Stored Procedures - incomplete list
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
I am successfully connecting to my SQL Server and able to see a lot of my stored procedures, but not ALL procedures are populating in the list. Would there be a reason for that?
Thanks,
Mary Tatum
Colorado Coalition for the Homeless
Solved! Go to Solution.
- Labels:
- Database Connection
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @mtatum
This could be related to permissions granted on the SPs in the database. Are you able to see the all the SPs if you connect using the same account with SSMS.
Dan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
Thanks for reaching out. I am connecting the with the same credentials in Alteryx as I do in SSMS. I can see them all in SSMS. I'm wondering if it's an issue with how large the stored procedure (sp) is? Looking into those that aren't on the list, they seem to be pretty large with a lot of dependencies. Are there any settings in Alteryx to allow for very large sp's or queries. On another note, yet relevent, when I just paste the large query that I'm working with into the SQL editor, it will paste all of the text, but when I try to run it, it truncates much of the query and errors out.
Thank you!
Mary
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
hi @mtatum
As far as stored procedures go, Alteryx doesn't care about size or complexity, as long as they return a single result set back(all of our stored procedures have SET NOCOUNT ON as their first line). Alteryx doesn't try to parse or understand them. It just tells SQL server to execute them and waits for the results.
I'm not aware of any limitation on the size of queries that you can put in the SQL Query editor and I haven't been able to find any posts on this topic either. We don't do a lot work directly in the query editor since most of our data comes through SPs for tracking and compliance purposes.
Dan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dan,
I wanted to let you know that once I switched from an ODBC to an OLEDB connection my stored procedure ran great. I just wanted to thank you for your time on this.
Mary
![](/skins/images/37684B556A01EB7D78DFEA23F58260E0/responsive_peak/images/icon_anonymous_message.png)