User profile for Dan_J

Hi @vjacob1 Thank you for your update on this, I'm sorry that my suggestion did not help on this occasion. Just to let you know that I will be attempting to reproduce this issue again tomorrow by creating a VPN scenario with SQL Search. I will get back to you as to the outcome of that as soon as possible. / comments

Hi @vjacob1 Thank you for your update on this, I'm sorry that my suggestion did not help on this occasion. Just to let you know that I will be attempting to reproduce this issue again tomorrow by...

0 votes

Hi @vjacob1 Thank you for update on this, our apology for the delay in responding to you! I wondered if you could please try the following: in SSMS, disconnect from your server, reopen the SQL Search tab, then reconnect to your server (via VPN), does SQL Search work then? / comments

Hi @vjacob1 Thank you for update on this, our apology for the delay in responding to you!I wondered if you could please try the following: in SSMS, disconnect from your server, reopen the SQL Sear...

0 votes

Hi @vjacob1 My sincere apology for the delay in getting back to you on this. I am currently struggling to reproduce the issue you are seeing here, and I wondered if it might be possible for you to try a remote connecting (RDP) to a machine that is on the other side of your VPN that has SSMS and SQL Search installed? If so, it would be good to see if you experience the same issue then? Also, I have been made aware that one of our other products (SQL Source Control) can cause performance issues with SSMS when a VPN connection is involved. If you do have SQL Source Control installed, would it be possible to try temporarily removing it to see if you continue to see the same issue in SQL Search? Also, one final thing to check, do the search results ever show? It would be interesting to know if they do after leaving SQL Search to run for a few minutes. / comments

Hi @vjacob1 My sincere apology for the delay in getting back to you on this.I am currently struggling to reproduce the issue you are seeing here, and I wondered if it might be possible for you to ...

0 votes

Hi @vjacob1 My apology again for the delay in responding to you on this! Thank you for highlighting that this could be related to you using a VPN. Firstly, can you please try launching SQL Search before connecting to the server to see if that helps at all? If not, it would be greatly appreciated if you can you send me all of the log files from the following directory: C:\Users\your username\AppData\Local\Red Gate\Logs / comments

Hi @vjacob1 My apology again for the delay in responding to you on this!Thank you for highlighting that this could be related to you using a VPN. Firstly, can you please try launching SQL Search...

0 votes

Hi @vjacob1 My sincere apology for the delay in responding to you on this! After some research on this I have been made aware of a current bug within SQL Search that may relate to the issue you are seeing. Until a fix is released the following workaround may help: Disconnect from the SQL Server in SSMS you want to search Close and reopen SQL Search Reconnect the SQL Server If this does not work for you, please can you attempt a re-installation of SQL Search? We suggest using Revo uninstaller (https://www.revouninstaller.com/revo-uninstaller-free-download/) to remove any residual files before then reinstalling the latest version of SQL Search. Again, if this does not resolve the issue, it may be worth trying to install a slightly older version of SQL Search. Version 3.5.0 can be downloaded here: https://download.red-gate.com/checkforupdates/SQLSearch/SQLSearch_3.5.0.2590.exe Please let me know the outcome of these suggestions. / comments

Hi @vjacob1 My sincere apology for the delay in responding to you on this!After some research on this I have been made aware of a current bug within SQL Search that may relate to the issue you are...

0 votes

Hi @vjacob1 Thank you for your update on this, my apology for the delay in responding to you! It is interesting that rolling back to a slightly older version of SQL Search allows for some, but not all, functions to work. I don't appear to have asked you this before now, but when did you start seeing this issue? Was it following any particular action/update? Also, what connection method do you use to connect to your database(s)? / comments

Hi @vjacob1 Thank you for your update on this, my apology for the delay in responding to you!It is interesting that rolling back to a slightly older version of SQL Search allows for some, but not ...

0 votes

Hi @vjacob1, I'm sorry to hear about the issues you are experiencing with SQL Search! Thanks for reaching you to us regarding this. Just to check, what version of SSMS are you currently running? Regarding the log files, if you navigate to the Help menu (within SQL Search) ->Logging ->Locate log files do you see any log files located there? If not, it could be that the logging level is set to 'No logging' (I think it is by default). If you change this to Verbose you should then see full log files created: [image] / comments

Hi @vjacob1,I'm sorry to hear about the issues you are experiencing with SQL Search! Thanks for reaching you to us regarding this.Just to check, what version of SSMS are you currently running?Regar...

0 votes

Hi pponzano Thanks for reaching out to us regarding this. Just to clarify my understanding, are you asking if Style's in SQL Prompt learn from your syntax writing style? / comments

Hi pponzano Thanks for reaching out to us regarding this.Just to clarify my understanding, are you asking if Style's in SQL Prompt learn from your syntax writing style?

0 votes

Hi @pponzano My sincere apology for the delay in responding to you on this! Unfortunately SQL Prompt Styles do not learn as you type, you are required to set your style options/settings manually within the Active Style menu. Please refer to the following documentation for all SQL code formatting and style features: https://documentation.red-gate.com/sp/sql-code-formatting-and-styles I hope this helps. / comments

Hi @pponzano My sincere apology for the delay in responding to you on this!Unfortunately SQL Prompt Styles do not learn as you type, you are required to set your style options/settings manually wit...

0 votes

Hi @....strauss Reading about this online, it appears various keywords were chosen by Microsoft and placed into a list within the query editor syntax coloring file, hence password, delay, and object are highlighted in blue. You could apply square brackets around those words to stop them being highlighted, but of course that isn't ideal. / comments

Hi @....strauss Reading about this online, it appears various keywords were chosen by Microsoft and placed into a list within the query editor syntax coloring file, hence password, delay, and obj...

0 votes

How can we help you today?

Dan_J

Comments