Comments
Sort by recent activity
meklembl wrote:
SQL Prompt 4.0.4.14? The last I can find on your site is 4.0.3.12.
They have a cumulative update that you can download from here. (Currently 4.0.4.19) / comments
meklembl wrote:
SQL Prompt 4.0.4.14? The last I can find on your site is 4.0.3.12.
They have a cumulative update that you can download from here. (Currently 4.0.4.19)
I second this suggestion. Though I would add that it might make sense to leave out aggregate fields from the SELECT clause. (Though it wouldn't be a big deal to delete them manually.) As it is now I usually select, copy, and paste the fields from the SELECT portion of the statement for the GROUP BY and ORDER BY. / comments
I second this suggestion. Though I would add that it might make sense to leave out aggregate fields from the SELECT clause. (Though it wouldn't be a big deal to delete them manually.) As it is now ...
If you search you will find a number of people have complained about this. SQL Prompt only searches x characters before the cursor and y characters after the cursor, so once your query/batch gets big it isn't seeing enough to give suggestions.
If you contact support they can give you instructions on adjusting how many characters it looks at, but I have found if I set them large enough to work that SQL Prompt gets too slow and it is worse than not getting suggestions at all. / comments
If you search you will find a number of people have complained about this. SQL Prompt only searches x characters before the cursor and y characters after the cursor, so once your query/batch gets b...
I just confirmed that disabling SQL Prompt and re-enabling it causes it to refresh a portion of the cache.
It appears to clear the cache for the connected server, but not for linked servers. i.e. I was creating a query in DB1 that referenced tables in DB2, I added a table to DB2 and SQL Prompt didn't see it. After a disable/enable cycle SQL Prompt saw it.
On the other hand it didn't make SQL Prompt refresh the cache from a linked server DB.
So it won't solve this problem. / comments
I just confirmed that disabling SQL Prompt and re-enabling it causes it to refresh a portion of the cache.
It appears to clear the cache for the connected server, but not for linked servers. i.e. I...
I am using SQL Prompt 4.0.4.14, yes linked server support is enabled, and the linked server in question is SQL Server.
It works, it is just a pain that I have to cancel all running processes, restart SSMS, and then re-open everything and get it back to the same state if I need the cache for the linked server updated. / comments
I am using SQL Prompt 4.0.4.14, yes linked server support is enabled, and the linked server in question is SQL Server.
It works, it is just a pain that I have to cancel all running processes, resta...
Brain,
Can you confirm if disabling and then re-enabling SQL Prompt would clear the cache, and this particular error? / comments
Brain,
Can you confirm if disabling and then re-enabling SQL Prompt would clear the cache, and this particular error?
Will you post the SP number once it has been assigned to make it easier to get the status in the future? Thanks! / comments
Will you post the SP number once it has been assigned to make it easier to get the status in the future? Thanks!
Yes, it does appear to have fixed the problem. I think that is the best turn-around I have seen on a bug fix so far. Thanks!
Is this issue really the only other issue fixed in 4.0.4.14? (Everything else that is listed was fixed in 4.0.4.11.) / comments
Yes, it does appear to have fixed the problem. I think that is the best turn-around I have seen on a bug fix so far. Thanks!
Is this issue really the only other issue fixed in 4.0.4.14? (Everything...
I'm not sure the second issue is the same issue as the first. Suggestions in the FROM normally work for CTE tables, but not if the CTE contains a FOR XML PATH query. Even in a much simpler query: WITH Rolled AS (SELECT
(SELECT 'Test'
FOR XML PATH(''), TYPE
).value('.[1]','varchar(max)') AS Sample_Rollup)
SELECT
*
FROM <CURSOR>
/ comments
I'm not sure the second issue is the same issue as the first. Suggestions in the FROM normally work for CTE tables, but not if the CTE contains a FOR XML PATH query. Even in a much simpler query:WI...
Can I assume by the SP number that this issue has been logged for a very long time and hasn't been added through a number of versions of SQL Prompt? / comments
Can I assume by the SP number that this issue has been logged for a very long time and hasn't been added through a number of versions of SQL Prompt?