How can we help you today? How can we help you today?

SQL Search 2

I did face the same problem when I installed it for the first time, the search was fast enough compared to its predecessor(Sql Search V1), however it consumes the whole processing and leaves us no choice other than killing the process through task manager.

Solution:
Repair the SSMS Integration Pack Framework & Sql Search 2 through the Control Panel MMC Snap-in(appwiz.cpl) and restart the ssms process again. It shouldn't freeze now :)

P.S: The solution proposed by me is temporary, it might be resolved by red-gate team soon in the new versions.
sarisetty
0

Comments

6 comments

Sort by
  • yshmidt
    I tried sarisetty solution to repair SSMS Integration Pack Framework & Sql Search 2. I also downloaded the latest version of sql search 2. Uninstalled a installed again, to no avail
    Help please.
    yshmidt
    0
  • vbmark
    I have this problem too.

    I can do a repair of both programs and sometimes get it working for several days.

    Then today, nothing I do fixes it and whenever I click the search button SSMS freezes and I have to kill the process.

    I would switch back to version 1 but I can't find the install executable.
    vbmark
    0
  • yshmidt
    Same here, "Search" can work for a day or a couple of hours and then freezes. I am going through the same steps; uninstall, re-install and hopping that it will work. Sometimes takes couple of times to do that. It became a game of sorts, click on the SQL Search and hold my breath.
    Which SQL Server version are you using? I think that SQL Search 1 doesn't work with SQL 2014.
    yshmidt
    0
  • vbmark
    yshmidt wrote:
    ...click on the SQL Search and hold my breath.
    Heh, yup.
    yshmidt wrote:
    Which SQL Server version are you using?
    2012
    vbmark
    0
  • asalspammer
    We dropped a table and then removed it from all the Stored Procedures that called it. When we search for the name of the table it is still showing up. I have tried to click Reindex and manually deleted the Indexes in my user folder. Can anybody please help?
    asalspammer
    0
  • oregonmusicman
    The only way I have been able to resolve this issue is to close SQL Server Management Studio, then delete the index files at the following location (WIndows XP):
    C:Documents and Settings*USERNAME*Local SettingsApplication DataRed GateSQLSearch 2Indexes
    These files are re-created the first time you perform a search.
    oregonmusicman
    0

Add comment

Please sign in to leave a comment.