Page 1 of 1

Stored procedures not visible if schema is other than dbo

Posted: Wed 27 Apr 2011 13:41
by hanneseklund
I have tons of stored procedures (SQL Server) that are under other schemas than dbo. I can't find them anywhere. Under procedures in Database Explorer, only dbo procedures are displayed.

Same in 3.2 and 3.5 beta. Is this a bug or is it just me ?

Posted: Wed 27 Apr 2011 15:54
by AndreyR
Please make sure that you have selected the Database Explorer -> Show All Objects button.

Posted: Thu 28 Apr 2011 05:39
by hanneseklund
"Show all Objects" makes no difference.

Posted: Thu 28 Apr 2011 12:51
by AndreyR
Thank you for the report, we have reproduced the issue.
I will let you know as soon as this error is fixed.

Posted: Tue 03 May 2011 11:22
by Shalex
The problem is fixed. Look forward to the next build of Entity Developer.

Posted: Thu 19 May 2011 10:42
by Shalex
New version of Entity Developer 3.50.128 is released!
It can be downloaded from http://www.devart.com/entitydeveloper/download.html (trial version) or from Registered Users' Area (for users with valid subscription only): http://secure.devart.com/ .

For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=21037 .

Posted: Mon 23 May 2011 06:26
by hanneseklund
The procedures are now showing in the interface, however when trying to create methods from them I get the error

"Failed to obtain metadata of procedure result set.
DeriveParameters requires the command to have a transaction when the connection assigned to the command is in a pending local transaction. The Transaction property of the command has not been initialized."

And the method is created with return type "None"

Posted: Mon 23 May 2011 07:24
by AndreyR
Thank you for the report, this issue was already fixed.
I will let you know when the fixed build is available.

Posted: Tue 31 May 2011 10:22
by AndreyR
We plan to release the fixed build in a week or so.

Posted: Wed 01 Jun 2011 16:58
by AndreyR
We have released the new 3.50.132 build of Entity Developer for SQL Server. This build can be dowloaded from here (the trial version) or from Registered Users' Area (for users with active subscription only).
For the detailed information about the improvements and fixes available in Entity Developer for SQL Server 3.50.132, please refer to this announcement.