[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
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.
almost 6 years ago
[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.