User profile for Tianjiao_Li

Hi @kakins-tamus Sorry to hear you are having this issue. Can you upgrade to the latest version and test again? Here are few things you can try: 1- Check this page 2- Try unceck the last two options: [image] / comments

Hi @kakins-tamus Sorry to hear you are having this issue.Can you upgrade to the latest version and test again?Here are few things you can try:1- Check this page2- Try unceck the last two options:

0 votes

Hi @ncbaras Thanks for posting. You may find this page useful? Also as SSMS is a 32 bit program, so it may help if you make it Large Address Aware to increase the memory max. You can download the following utility to do this: https://www.techpowerup.com/forums/threads/large-address-aware.112556/ / comments

Hi @ncbaras Thanks for posting. You may find this page useful? Also as SSMS is a 32 bit program, so it may help if you make it Large Address Aware to increase the memory max. You can download the f...

0 votes

Hi derekt It seems that you are hitting a known bug SC-9192. It was because the target has two indexes which are functionally the same, but only one of them is in the source with a different name. We think in the engine it would be a rename and therefore ignore it not accounting for the fact there is only 1 of it in the source but two in the target. Can you please send in an example to confirm it? Thanks! / comments

Hi derekt It seems that you are hitting a known bug SC-9192. It was because the target has two indexes which are functionally the same, but only one of them is in the source with a different name....

0 votes

Hi @BrienKing I can't reproduce it in the latest Prompt, can you please upgrade and test again? Thanks. / comments

Hi @BrienKing I can't reproduce it in the latest Prompt, can you please upgrade and test again?Thanks.

0 votes

Hi @BrienKing Thanks for posting. It sounds a bug to us. Would you mind to send in a sample script to reproduce? Thanks. / comments

Hi @BrienKing Thanks for posting. It sounds a bug to us. Would you mind to send in a sample script to reproduce? Thanks.

0 votes

Unfortunately since version 8, SQL Prompt doesn't support SSMS 2008 and SSMS 2008 R2 or earlier versions. Here is the release note.Please upgrade SSMS. / comments

Unfortunately since version 8, SQL Prompt doesn't support SSMS 2008 and SSMS 2008 R2 or earlier versions. Here is the release note.Please upgrade SSMS.

0 votes

Hi @Matthew_Sontum Thanks for the complete script. If you uncheck 'Indent parentheses contents' , it should work as you expect. [image] / comments

Hi @Matthew_Sontum Thanks for the complete script. If you uncheck 'Indent parentheses contents' , it should work as you expect.

0 votes

Hi @Matthew_Sontum , Thanks for the style file. However, we still couldn't reproduce the issue. Can you please upgrade to the latest version if not already and test again? / comments

Hi @Matthew_Sontum , Thanks for the style file. However, we still couldn't reproduce the issue. Can you please upgrade to the latest version if not already and test again?

0 votes

Hi @Ruslan Sorry to hear you are having this issue. Does toggling "Enable suggestions" or clicking "Refresh suggestions" have any effect? Can you please check these settings: [image] / comments

Hi @Ruslan Sorry to hear you are having this issue. Does toggling "Enable suggestions" or clicking "Refresh suggestions" have any effect? Can you please check these settings:

0 votes

Hi @higgim We have this issue logged as SP-6242 in our internal bug tracking system. I'll speak to the development team and update you as soon as possible. Our apologies for the inconvenience caused. / comments

Hi @higgim We have this issue logged as SP-6242 in our internal bug tracking system. I'll speak to the development team and update you as soon as possible. Our apologies for the inconvenience caused.

0 votes

How can we help you today?

Tianjiao_Li

Comments