Page 1 of 1

SQL Server stored procedures are not available

Posted: Fri Jun 10, 2011 1:42 pm
by rgruber3@msn.com
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

SQL Server stored procedures are not available

Posted: Mon Jun 13, 2011 3:43 am
by davidc
For clarification, do you mean views and stored procedures are not showing up in the Query Builder or in the database browser? David

SQL Server stored procedures are not available

Posted: Mon Jun 13, 2011 4:39 pm
by rgruber3@msn.com
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.

SQL Server stored procedures are not available

Posted: Tue Jun 14, 2011 4:37 am
by davidc
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

SQL Server stored procedures are not available

Posted: Tue Sep 27, 2011 6:48 am
by OlleBrant
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

SQL Server stored procedures are not available

Posted: Tue Sep 27, 2011 8:35 am
by davidc
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