SSMS 2008 / Sql Server 2008 returning no results for 1 database

cmdixon

I've seen other people mention this problem, but haven't seen any specific to SSMS 2008. We have 1 database that rarely gives results when we run a search. This only started happening with version 2.4 (specifically, we are using 2.4.0.1203). Sometimes we can close and reopen sql search and it will yield results, but most of the time it will not. We've tried deleting the index files as suggested in other posts. We've also tried deleting those files, then rebooting the pc. Still no results.

I'm pasting a copy of my log file from this morning below. Can anyone point me in the direction of getting this to work again?

Thank you for any help.

Colleen

22 May 2017 09:46:57.247 [1] INFO RedGate.SQLSearch.Addin - Starting new SQLSearch 2 session
22 May 2017 09:46:57.262 [1] INFO RedGate.SQLSearch.Addin - Location C:\ProgramData\Red Gate\SQL Search\Active\RedGate.SQLSearch.Addin.dll
22 May 2017 09:46:57.262 [1] INFO RedGate.SQLSearch.Addin - Assembly version: 2.4.0.1203
22 May 2017 09:46:57.294 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'mscorlib' 'V2.0.0.0' key='B7-7A-5C-56-19-34-E0-89'
22 May 2017 09:46:57.294 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'AppIDPackage' 'V10.0.0.0' key='89-84-5D-CD-80-80-CC-91'
22 May 2017 09:46:57.309 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'System' 'V2.0.0.0' key='B7-7A-5C-56-19-34-E0-89'
22 May 2017 09:46:57.309 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.SqlTools.VSIntegration' 'V10.0.0.0' key='89-84-5D-CD-80-80-CC-91'
22 May 2017 09:46:57.309 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Shell.Interop' 'V7.1.40304.0' key='B0-3F-5F-7F-11-D5-0A-3A'
22 May 2017 09:46:57.325 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.OLE.Interop' 'V7.1.40304.0' key='B0-3F-5F-7F-11-D5-0A-3A'
22 May 2017 09:46:57.325 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'System.Windows.Forms' 'V2.0.0.0' key='B7-7A-5C-56-19-34-E0-89'
22 May 2017 09:46:57.325 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'System.Drawing' 'V2.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
22 May 2017 09:46:57.341 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'SqlWorkbench.Interfaces' 'V10.0.0.0' key='89-84-5D-CD-80-80-CC-91'
22 May 2017 09:46:57.356 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.SqlTDiagM' 'V10.0.0.0' key='89-84-5D-CD-80-80-CC-91'
22 May 2017 09:46:57.372 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Instapi' 'V10.0.0.0' key='89-84-5D-CD-80-80-CC-91'
22 May 2017 09:46:57.372 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'EnvDTE' 'V8.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
22 May 2017 09:46:57.372 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Shell' 'V2.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
22 May 2017 09:46:57.387 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.VisualStudio.Shell.Interop.8.0' 'V8.0.0.0' key='B0-3F-5F-7F-11-D5-0A-3A'
22 May 2017 09:46:57.387 [1] INFO RedGate.SQLSearch.Addin.ObjectExplorer.SSMS.SsmsObjectExplorer - Assembly 'Microsoft.SqlServer.Management.SDK.SqlStudio' 'V10.0.0.0' key='89-84-5D-CD-80-80-CC-91'
22 May 2017 09:47:25.687 [1] WARN RedGate.SQLSearch.Addin.Connect - Could not set window state for tab
System.ArgumentException: Value does not fall within the expected range.
at EnvDTE80.Window2.set_WindowState(vsWindowState plWindowState)
at RedGate.SIPFramework.PluginManagement.ServicesToPlugins.Windows.SsmsWindow.set_WindowState(WindowState value)
at RedGate.SQLSearch.Addin.SearchTabToolWindow.Initialise(HostEnvironment hostEnvironment, ObjectExplorerWatcher objectExplorerWatcher, IUsageHelper usageHelper, IRawUsageHelper rawUsageHelper, IUsageOptOut usageOptOutProvider, ISsmsFunctionalityProvider6 ssmsFunctionalityProvider, ILicensingStateProvider licensingStateProvider)
22 May 2017 09:47:26.130 [1] INFO RedGate.SQLSearch.Addin.Tab.SearchConfigBar - Adding companion product SQL Compare as a preferred program supporting contexts 'None' at 'C:\Program Files (x86)\Red Gate\SQL Compare 10\RedGate.SQLCompare.UI.exe'
22 May 2017 09:47:26.146 [1] INFO RedGate.SQLSearch.Addin.Tab.SearchConfigBar - Adding companion product SQL Data Compare as an installed program supporting contexts 'None' at 'C:\Program Files (x86)\Red Gate\SQL Data Compare 10\RedGate.SQLDataCompare.UI.exe'
22 May 2017 09:47:26.146 [1] INFO RedGate.SQLSearch.Addin.Tab.SearchConfigBar - Adding companion product SQL Dependency Tracker as an installed program supporting contexts 'None' at 'C:\Program Files (x86)\Red Gate\SQL Dependency Tracker 2\RedGate.DependencyViewer.UI.exe'
22 May 2017 09:47:57.001 [22] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Exception while re-indexing GC_AppsDB on 54.234.185.170,15000:
Exception: database is locked
database is locked
22 May 2017 09:47:57.081 [9] ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: 'GC_AppsDB on 54.234.185.170,15000' is not indexed
22 May 2017 09:47:57.081 [19] ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: 'GC_AppsDB on 54.234.185.170,15000' is not indexed
22 May 2017 09:56:23.058 [25] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Exception while re-indexing GC_AppsDB on 54.234.185.170,15000:
Exception: database is locked
database is locked
22 May 2017 09:56:23.074 [24] ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: 'GC_AppsDB on 54.234.185.170,15000' is not indexed
22 May 2017 09:56:23.074 [28] ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: 'GC_AppsDB on 54.234.185.170,15000' is not indexed
22 May 2017 09:56:23.203 [27] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Exception while re-indexing GC_AppsDB on 54.234.185.170,15000:
Exception: database is locked
database is locked
22 May 2017 09:56:23.218 [29] ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: 'GC_AppsDB on 54.234.185.170,15000' is not indexed
22 May 2017 09:56:23.218 [30] ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: 'GC_AppsDB on 54.234.185.170,15000' is not indexed

Jessica R

Hi Colleen,

Sorry to hear you're running into an issue!

I've seen the "database is locked" error before and it has helped to:

1) Open SSMS but do not connect to a Database Engine.

2) Open SQL Search2

3) Connect to your database engine

4) Use SQL Search

Can you please see if this helps?

cmdixon

Hi Jessica -

Thanks for the reply. Yes, that actually does work. Do you know if this is a bug that will be fixed? It's a little inconvenient to have to close all my work, close the connection to the server, then open SQL Search and then open everything back up?

Colleen