Activity overview
Latest activity by sbenson
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...
I re-activated it and that fixed it. / comments
I re-activated it and that fixed it.
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?
Same issue here.
Shawn. / comments
Same issue here.
Shawn.
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...
Anu Deshpande wrote:
Thanks for your post.
I was trying to replicate the issue with reference to the query you have posted above.
I found some issues with the alias you used dbo.Audit_Suppliers cas and the alias in Join condition as.StagingID do not match.
Could you kindly elaborate more on this issue along with the query?
Sorry, changed a table name and thus the alias for the post. Basically, for any update query that invloves an alias, SQL Prompt is not providing suggestions. Another sample is provided below. Again, if I type the alias and the period after it, i would expect suggested columns to come up. nothing happens. This worked in version 3.x, so not sure if is a setting or a bug. My setting are pretty much default.
UPDATE mi
SET mi.input_item_records = ii.records,
FROM #mi mi
JOIN ( SELECT mid ,
COUNT(*) AS records
FROM #ii
GROUP BY mid
) ii ON mi.MID = ii.MID / comments
Anu Deshpande wrote:
Thanks for your post.
I was trying to replicate the issue with reference to the query you have posted above.
I found some issues with the alias you used dbo.Audit_Suppliers c...
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...
The repair option fixed it, thanks.
SQL Prompt v3.9.3.303 is the version that is installed.
SSMS (2008) version 10.0.1600.22
Yes, there was another version3 installed, not sure which. This is a new laptop, so it would have been the latest available for download. The version above was the one released to help with VPN issues.
No other add-ins are installed.
Version 4 did remove itself. I had to remove the menu option from SSMS though.
I may try version 4 (EAP) again if an update is released that fixes some of the issues with syntax error checking and supports linked servers; otherwise I’ll probably wait for release. Lack of linked server support is the one thing I can’t live without.
Thanks again for the support,
Shawn. / comments
The repair option fixed it, thanks.
SQL Prompt v3.9.3.303 is the version that is installed.
SSMS (2008) version 10.0.1600.22
Yes, there was another version3 installed, not sure which. This is a ne...
Big Bill in TN wrote:
Try this.
Mouse over the tool bar and right click > Customize
When the Customize dialog box opens drag the SQL Prompt Button off the tool bar and drop it anywhere. It should be gone next time you start.
Has work for me.
Thanks,
That gets rid of version 4, or at least the menu option for it, but does not re-enable version 3. It is still installed but does not show up. I was hoping to avoind re-installing version 3, but may have to try that. / comments
Big Bill in TN wrote:
Try this.
Mouse over the tool bar and right click > Customize
When the Customize dialog box opens drag the SQL Prompt Button off the tool bar and drop it anywhere. It should...