Comments
Sort by recent activity
Hi @mdullni1, I assume in that situation you have some text immediately after the open bracket? The "Match whole words only" is designed to only match entire words; that is, match text beginning and ending with whitespace. So if you had an object where the definition was "lngRcrdSttsID IN ( MyObject" we would expect the "Match whole words only" option to correctly display this result when searching for "lngRcrdSttsID IN (". If however the object definition didn't have a space between the bracket, for example "lngRcrdSttsID IN (MyObject" then we wouldn't expect the "Match whole words only" option to display this. This result would be shown, however, when searching for "lngRcrdSttsID IN", or "lngRcrdSttsID IN (MyObject". Does this match what you are seeing? Are there many situations you have where it is necessary to search for something like "lngRcrdSttsID IN (" and searching for either "lngRcrdSttsID IN" or "lngRcrdSttsID IN (MyObject" instead wouldn't be suitable? Thanks, Asha / comments
Hi @mdullni1,I assume in that situation you have some text immediately after the open bracket? The "Match whole words only" is designed to only match entire words; that is, match text beginning and...
Hi @mdullni1, That's interesting, I am trying with statement "ID = 3" and I am successfully getting a match. [image] Can you provide me with an example script for an object where you're seeing this problem? Thanks, Asha / comments
Hi @mdullni1,That's interesting, I am trying with statement "ID = 3" and I am successfully getting a match.Can you provide me with an example script for an object where you're seeing this problem?T...
Hi, Thanks for reaching out with your feedback; it's very helpful and I can certainly understand your use case! If the "Match whole words only" option ignored commas - that is, it would find "[column 1]," if you only searched for "column 1" - would that solve your problem? Or are there other reasons you find the "Match whole words only" option unsuitable? For example, any other punctuation that isn't a comma being treated as part of the word? Thanks again for your feedback on this! Asha / comments
Hi,Thanks for reaching out with your feedback; it's very helpful and I can certainly understand your use case!If the "Match whole words only" option ignored commas - that is, it would find "[column...
Hi, We have found a potential issue that could be stopping SQL Search from working. We recently introduced some functionality where SQL Search would remember some of your preferences and store this in an xml file to carry those preferences forward. It seems this file can end up corrupted and in some cases this stops SQL Search from working. We haven't tracked down the cause yet, but in the meantime you can rectify this by deleting the file at "C:\Users\<username>\AppData\Local\Red Gate\SQLSearch 3\SavedSettings.xml". Hopefully on the next startup SQL Search will appear again. Sorry about this, I hope this works for you! Asha / comments
Hi,We have found a potential issue that could be stopping SQL Search from working. We recently introduced some functionality where SQL Search would remember some of your preferences and store this ...
Hi Mario, Have you set any non-default options in the SQL Server connection you are currently connected to? For instance, are you using an encrypted connection or not trusting the server certificate? Thanks, Asha / comments
Hi Mario,Have you set any non-default options in the SQL Server connection you are currently connected to? For instance, are you using an encrypted connection or not trusting the server certificate...
Also can you confirm the version of SQL Search you are using? The most recent version should be v3.1.6.2042. Thanks, Asha / comments
Also can you confirm the version of SQL Search you are using? The most recent version should be v3.1.6.2042.Thanks,Asha
Hm interesting. Has anyone used a previous version of SQL Search and had it work normally? If so it looks like this could have been a problem introduced in the latest version. / comments
Hm interesting. Has anyone used a previous version of SQL Search and had it work normally? If so it looks like this could have been a problem introduced in the latest version.
Hi Mario, Have you opened any server connections? SQL Search can use any connections you have open, if you try to connect to a SQL Server instance the boxes should stop being greyed out. Thanks, Asha / comments
Hi Mario,Have you opened any server connections? SQL Search can use any connections you have open, if you try to connect to a SQL Server instance the boxes should stop being greyed out.Thanks,Asha
That's good to know - thanks very much! [image] / comments
That's good to know - thanks very much!
Hi Hrvoje, Thanks for your post, sorry to hear you were having an issue! I shall raise this with the developers and let you know any outcomes. In the meantime, there has been a newer version released recently that is available for download using the below link: ftp://support.red-gate.com/patches/SQLSearch/29Mar2018/SQLSearch_3.1.2.1997.exe From your screenshot it doesn't look like you're on this version. If you upgrade to this version do you still see the same issue? Thanks, Asha / comments
Hi Hrvoje,Thanks for your post, sorry to hear you were having an issue!I shall raise this with the developers and let you know any outcomes. In the meantime, there has been a newer version released...