Posts
Sort by recent activity
Prompt trying to cache databases for closed sessions
SQL Prompt keeps haning and coming up with the error "unload all databases". Then I noticed that it is tyring to cache databases for sessions that I closed. Only workaround I found was to close S...
SQL Prompt - Format SQL
In versions previous to 5.2, I was able to highlight text and format just that block of text. Now when I hihgllight text and format, it un-highlites the text and trys to format everything is the a...
SQL Prompt 5 downgraded to standard edition
When I installed the 5.1.6.35 update to SQL Prompt I went from professional to standard edition. How do I get that fixed?
Once a PIVOT is used SQL Prompt will no longer respond
Example
SELECT [A],,[C],[G],[P],[Q],[R],,[Z],[N]
FROM
(
SELECT ISNULL(iie.ovr_ma_pricing_lookup_status,'N') as ovr_ma_pricing_lookup_status, count(*) as records
FROM ItemMaestroProdDSS_8_27_201...
Using an alias with an update does not show suggestions
In the example below, no suggestions are displayed for either alias. if I type tsip. I would expect to get sugestions. Instead, SQLPrompt does not display anything.
UPDATE tsip
SET tsip.SIV...
Un-install SQL Prompt v4 and re-enable V3
How do I remove SQL Prompt v4?
The notes indicate that "SQL Prompt v4 does not work in parallel with v3.x.
Installing SQL Prompt v4.0 will disable v3.x. To re-enable v3.x, uninstall v4. "
I have Un...