SQL Server stored procedures are not available

This forum can be browsed by the general public. Posting is limited to current SAPIEN license holders with active maintenance and does not offer a response time guarantee.
Forum rules
DO NOT POST SUBSCRIPTION NUMBERS, LICENSE KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
User avatar
rgruber3@msn.com
Posts: 2
Joined: Fri Jun 10, 2011 1:42 pm

SQL Server stored procedures are not available

Post by rgruber3@msn.com » Fri Jun 10, 2011 1:42 pm

Hello
With my sql server connection, the tables are enumerated, and I can query, but stored procedures and views are not enumerated. Why?

PrimalSQL 2011 / Windows 7 64 bit / SQL Server 2008 (on another machine)

Thanks in advance

User avatar
davidc
Posts: 5913
Joined: Thu Aug 18, 2011 4:56 am

SQL Server stored procedures are not available

Post by davidc » Mon Jun 13, 2011 3:43 am

For clarification, do you mean views and stored procedures are not showing up in the Query Builder or in the database browser? David
David
SAPIEN Technologies, Inc.

User avatar
rgruber3@msn.com
Posts: 2
Joined: Fri Jun 10, 2011 1:42 pm

SQL Server stored procedures are not available

Post by rgruber3@msn.com » Mon Jun 13, 2011 4:39 pm

Yes. In the tree view, with the database expanded, if you click on the "+" sign for the tables then it expands and shows the table. If you do the same for the stored procs or views, nothing is displayed. Thanks for you reply.

User avatar
davidc
Posts: 5913
Joined: Thu Aug 18, 2011 4:56 am

SQL Server stored procedures are not available

Post by davidc » Tue Jun 14, 2011 4:37 am

We are looking into this issue. What type of connection are you using to connect to the SQLServer? SQL, OLEDB, ODBC? Note that system views and system store procedures are not displayed. David
David
SAPIEN Technologies, Inc.

User avatar
OlleBrant
Posts: 1
Joined: Sun Mar 03, 2013 12:43 pm

SQL Server stored procedures are not available

Post by OlleBrant » Tue Sep 27, 2011 6:48 am

HelloI got the
same problem I can see tables and views but not stored procedures in the tree
views.PrimalSQL 2011 / Windows 7 64 bit / SQL
Server 2008R2 on Windows 2008R2, SQL 2000 on Windows 2003

User avatar
davidc
Posts: 5913
Joined: Thu Aug 18, 2011 4:56 am

SQL Server stored procedures are not available

Post by davidc » Tue Sep 27, 2011 8:35 am

The Query Builder doesn't support stored procedures so it doesn't show in the metadata. We will look into displaying the procedures in the Database Browser dispite this. David
David
SAPIEN Technologies, Inc.