On 12.01.2012 17:32, jan_bar wrote:
> Hi,
>
> I use SquirrelDB as my primary database tool for many different
> databases (PostgreSQL, DB2, Oracle, ...) and I like it. However with MS
> SQL it seems that the support is lacking. There are some issues:
>
> * I cannot see source of stored procedures - is this supposed to work?
The MSSQL Plugin supports scripting stored procedures. But there is no
source tab in the Object tree details the like they exist for some other
RDBMSes.
You may file a feature request here:
http://sourceforge.net/tracker/?group_id=28383&atid=393417
Or much better implement it yourself and make a patch of your changes
available here:
http://sourceforge.net/tracker/?group_id=28383&atid=393416
We regularly check for patches and integrate them into our source
repository.
>
> * I cannot see list of stored procedures. Current user doesn't have
> right to see procedure source but he can execute them. In MS SQL
> Management Studio I can list procedure names. This is quite unfortunate.
>
> * Sometimes I cannot list table names even if I can list them in MS SQL
> Management Studio with the same user
I cannot reproduce these problems though I admit that I have only very
limited access to MSSQL right now. Could you please give some more details.
>
> How can I debug what's going on?
Some information on how to build and program SQuirreL can be found here:
http://www.squirrelsql.org/index.php?page=programing
http://www.squirrelsql.org/#overview
If you have any further questions feel free to ask me or to post
messages to one of our mailing lists:
http://sourceforge.net/mail/?group_id=28383
Gerd
|