How can we help you today?

Start a new topic
Discussions DbVisualizer Forums Support

Unable to execute as explain plan (mssql)

[This topic is migrated from our old forums. The original author name has been removed]

I'm trying to test the explain plan functionality, but i can't. While i do have a connection to an MS-SQL database and queries run fine, the option to 'Execute as explain plan' is disabled. DbVis version: 9.0.7 with an evaluation licence. Database: Microsoft SQL Server, version 10.50.2500 Driver: jTDS Type 4 JDBC Driver for MS SQL Server and Sybase, version 1.2.7
2 CommentsSorted by Oldest First
[This reply is migrated from our old forums.]

Re: Unable to execute as explain plan (mssql)
Hi, First make sure the Database Type setting in the Connection tab is set to "SQL Server". Please let us know if the explain button is still disabled after doing this. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Unable to execute as explain plan (mssql)
That was indeed the problem. The connection i created first was created as generic and later changed some parts of it's definition to mssql. This enabled some db-specific UI elements, but not the explain plan parts.
Comments to this discussion are now closed!
More topics in Support
See all 1297 topics