|
From: jan_bar <her...@ya...> - 2012-01-16 12:23:32
|
In article <MPG...@ne...>, her...@ya... says... Replying myself: > > 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? No, this is not implemented in MS SQL plugin, but it should be quite easy to implement: http://msdn.microsoft.com/en-us/library/ms345443.aspx Also the source can be seen: Right-clicking a procedure and selecting SQL Server brings up a submenu Script and Execute items. > > * 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. I cannot list the stored procedures even as SQLAdmin. The procedures are not in default "dbo" schema, they are in different schema. Listing procedures in dbo schema workf fine. > > * Sometimes I cannot list table names even if I can list them in MS SQL > Management Studio with the same user > > How can I debug what's going on? > > Thanks you, Jan > > > ------------------------------------------------------------------------------ > RSA(R) Conference 2012 > Mar 27 - Feb 2 > Save $400 by Jan. 27 > Register now! > http://p.sf.net/sfu/rsa-sfdev2dev2 |
