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

SQL search doesn't give results anymore

I updated SQL search to version 3.9.2.6322

I'm using SSMS version 20.2.30.0

in the log I see these errors:

2025-12-10 07:42:31.966 +01:00 [Error]  [DatabaseObjectIndexer]: Exception while indexing database Ancor: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)
  at System.Data.SQLite.UnsafeNativeMethods.sqlite3_open_interop(Byte[] utf8Filename, Byte[] vfsName, SQLiteOpenFlagsEnum flags, Int32 extFuncs, IntPtr& db)
  at System.Data.SQLite.SQLite3.Open(String strFilename, String vfsName, SQLiteConnectionFlags connectionFlags, SQLiteOpenFlagsEnum openFlags, Int32 maxPoolSize, Boolean usePool)
  at System.Data.SQLite.SQLiteConnection.Open()
  at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.EnsureConnectionOpen()
  at RedGate.SQLSearch.Indexing.SQLite.SqliteDatabaseConnection.CreateCommand()
  at RedGate.SQLSearch.Indexing.SQLite.DatabaseObjectStorage.Initialise()
  at RedGate.SQLSearch.Indexing.DatabaseObjectIndexer.Index(CancellationToken token)

MenuGuy
3

Comments

3 comments

Sort by
  • Mike Patrick

    I opened a support request and got a pretty fast response:

    I've been advised that this is a bug when you're using SQL Search with SQL Prompt installed and it's been escalated to the developers.

    Using SSMS 21/22 or downgrading to SQL Prompt 11.2.0 will get around this issue for the time being.
    https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_11.2.0.19838.exe

    Downgrading SQL Prompt (from 11.2.1 to 11.2.0) resolved my issue.

    Note, from my preceding post, I'm on a fairly old OS and not-very-new SSMS, so YMMV.

    Mike Patrick
    0
  • MenuGuy

    IN SSMS 22 , SQL search is indeed working, but I had to delete SQL search first and re-install it.

    SQL prompt also isn't showing in SSMS 22, and I can't install it again, because SQL prompt is greyed out. But if I uninstall I will losse all my preferences I guess. Is there any easy way to keep those?

    For now I will work with SSMS 19 where the Toolbelt is working, and only use SSMS 22 for the Search

    MenuGuy
    0
  • Terry V.

    Same issue encountered. Uninstalled SQL prompt and re-installed SQL prompt v11.2.0 and getting search results now. 

    Terry V.
    0

Add comment

Please sign in to leave a comment.