Comments
Sort by recent activity
We did think of options but the trouble is SQL Prompt has loads of options and users tend to get confused having to navigate through such vast option items.
We are now planning for our next version and it’s too early to promise anything at this stage. But I will log your suggestion into our database and keep you posted with the updates [image]
Thanks,
Tanya / comments
We did think of options but the trouble is SQL Prompt has loads of options and users tend to get confused having to navigate through such vast option items.
We are now planning for our next version...
Hi,
SQL Prompt used to list the identity columns while choosing to auto-complete insert statements in the previous versions. However, since identity columns are usually auto-generated values many of our users thought it would be better if that was not listed in the auto-completion list which led to the current implementation!
Thanks,
Tanya / comments
Hi,
SQL Prompt used to list the identity columns while choosing to auto-complete insert statements in the previous versions. However, since identity columns are usually auto-generated values many o...
Hi ,
This looks like a case sensitivity issue.
NAME and LOW are written in uppercase while in the spt_values table they are written in lowercase. By changing both the columns (NAME and LOW) to lowercase you will see that they do get listed in the candidate list.
Thank you for reporting this issue.
Regards,
Tanya / comments
Hi ,
This looks like a case sensitivity issue.
NAME and LOW are written in uppercase while in the spt_values table they are written in lowercase. By changing both the columns (NAME and LOW) to lowe...
Hi,
All Red Gate products will eventually start using the new 'Check for updates' component for our future releases.
Ben and Simon - the masterminds behind the new 'Check for updates' will sure be excited to hear this [image]
Thanks,
Tanya / comments
Hi,
All Red Gate products will eventually start using the new 'Check for updates' component for our future releases.
Ben and Simon - the masterminds behind the new 'Check for updates' will sure be ...
Once you remove the query used to create the object and refresh the cache, SQL Prompt should show the updated object information. I did test that on the latest v3.8 build and it does work.
So in your case, once the SELECT INTO code is removed from the query window and the cache is refreshed New_Table, should display the altered structure of the table in the schema panel and in the object definition hints while you hover over the table.
Let me know if that works?
Thanks,
Tanya / comments
Once you remove the query used to create the object and refresh the cache, SQL Prompt should show the updated object information. I did test that on the latest v3.8 build and it does work.
So in yo...
Hi,
SQL Prompt caches the scripted objects information from the query window and that is how it shows the new table in the candidate list.
But unfortunately SQL Prompt fails to update the changes done on the object when the query used to create the object remains in the query window.
However if you remove the main query used to create the object from the query window and refresh the cache, you should get the updated information in the schema panel or when you hover over the object.
I hope that helps.
Thanks,
Tanya / comments
Hi,
SQL Prompt caches the scripted objects information from the query window and that is how it shows the new table in the candidate list.
But unfortunately SQL Prompt fails to update the changes d...
Hi Michael,
Are you referring to the yellow lines that come across on the left side of SSMS editor as you write any new queries or while modifying scripts?
If so, I am not actually able to replicate any scenario when the yellow line does not show up while using SQL Prompt to write those queries.
I tried using INSERT INTO and auto-completion did get the yellow lines on the query window for the inserted lines.
If my understanding of the issue is right the yellow lines is more of an editor feature and nothing should be affected on using SQL Prompt!
But please do correct me if I am wrong.
Thanks,
Tanya / comments
Hi Michael,
Are you referring to the yellow lines that come across on the left side of SSMS editor as you write any new queries or while modifying scripts?
If so, I am not actually able to replicat...
Hi Zac,
I am glad you liked the product.
Actually this was a feature that many of us were thinking about while working on v3.8 but given that we didn’t really do any user researches or ground work for this task we decided not to pursue it any further for v3.8.
But it’s a really cool suggestion and now that you have requested this feature we will log it in our database and probably get it done for our future versions.
Thank you for taking the time to send us your suggestion.
Regards,
Tanya / comments
Hi Zac,
I am glad you liked the product.
Actually this was a feature that many of us were thinking about while working on v3.8 but given that we didn’t really do any user researches or ground wor...
Thomas_Bouvet wrote:
I have another feature request concerning some of the same issue. I think it would be nice if the information stored in MS Description field for objects was shown here (like you do when hovering over a table-name).
We are using SQL Doc to generate databasedocumentation and have developed a small webapplication to enter structured information into this field.
If you could display this information when hovering over objects it would be great. That way our developers has the database-documentation right at hand when they are developing stored procedures etc..
Best regards
Thomas
MS descriptions for stored procs was supposed to be done for v3.8 but we slipped adding them for the release. We will get this sorted in our next version.
Thank you for your suggestions. We will keep you posted with the updates.
Regards,
Tanya / comments
Thomas_Bouvet wrote:
I have another feature request concerning some of the same issue. I think it would be nice if the information stored in MS Description field for objects was shown here (like...
I have tried using different configurations on the layout options menu and am still not successful with reproducing the issue!
Is there any possibility that you can try this on a different machine or a different editor so that we can check if this is related to some system or editor configuration at all? I am not really sure why that should happen but it would help if we can confirm that.
Thanks,
Tanya / comments
I have tried using different configurations on the layout options menu and am still not successful with reproducing the issue!
Is there any possibility that you can try this on a different machine ...