SQL Pilot 1.0.1

Bug fixes + perf for SSMS 20 users.

Install

SqlPilotInstaller-v1.0.1.zip — one-click installer. Extract, double-click, pick SSMS versions, Install, restart SSMS, Ctrl+D.

Already running v1.0.0? The WPF installer shows an upgrade banner on startup; re-run it to update.

Fixes

• SSMS 20: Enter on stored procedures / views / functions was showing "Could not retrieve definition" instead of opening the ALTER script. SSMS 20 emits `multiple active result sets` (keyword with spaces) in its connection strings, which the underlying `System.Data.SqlClient` rejects. Connection strings are now sanitized — any keyword SqlClient doesn't recognise is dropped before being handed to SMO.
• Indexing is faster for servers with more than 8 databases. The per-server concurrency cap went from 8 to 20, so a typical dev-box server with ~15–20 databases now indexes fully parallel instead of queueing the tail behind the first batch.

Everything else (unchanged from v1.0.0)

Modern, keyboard-driven quick-search for SSMS 18, 20, and 22. Fuzzy-match any table, view, stored procedure, or function across every database on every connected server. See the v1.0.0 release notes for the full feature list.

Full Changelog: v1.0.0...v1.0.1