What are the challenges you face when working across database platforms? Take the survey
Options

SQL Search FOR Visual Studio (2017) not returning any results

SQL Search is working on SSMS 2017 but not in VS 2017.

Things that I already tried:
  • Delete all content from the folder %LocalAppData%\Red Gate\SQLSearch for Visual Studio 3\Indexes
  • Update SQL Search and SQL Prompt to lastest version

Comments

  • Options
    ThadHThadH Posts: 2 New member
    SQL Search in VS2017 doesn't index or return any search results. This started with version 3.2.4.2262 on 03/14/2019.

    I had to revert to version 3.1.7.2062 and turn off Automatic updates until this can be fixed. 

    The error is:
    System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.InvalidOperationException: The calling thread cannot access this object because a different thread owns it.
       at System.Windows.Threading.Dispatcher.VerifyAccess()
  • Options
    Hi @ThadH

    We've identified a bug that we think might be causing this problem. We've released 3.2.5.2285 with a fix. Can you try this version to see if it fixes the problem?
    Software Engineer
    Redgate Software
  • Options
    ThadHThadH Posts: 2 New member
    Hi Rob, 3.2.5.2285 has fixed the problem.

    Thanks!
Sign In or Register to comment.