How can we help you today? How can we help you today?
Flimmer
Activity overview Badges (0) Posts (0) Comments (1)

Activity overview

Latest activity by Flimmer

Also having this issue with SQL Search 2 v 2.4.4.1453 on SSMS 2014. Deleting index folder contents didn't help. Tried Jessica R June 14 4-step method, works for the session but closing and opening SSMS brings the issue back. We work in a managed services environment so we can't get additional server rights to database msdb. Jobs are not allowed in our environment. Log file when SQL Search works: "Exception: The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'." followed by "ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: 'Jobs on dbxxxxx' is not indexed". Log files when SQL Search doesn't work filled with this: Exception: database is locked database is locked 16 Jun 2017 11:14:10.400 [52] ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: 'MyDBName on dbxxxxxx' is not indexed 16 Jun 2017 11:14:10.402 [52] ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: 'Jobs on dbxxxxxx' is not indexed 16 Jun 2017 11:14:10.401 [8] ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: 'MyDBName on dbxxxxxx' is not indexed 16 Jun 2017 11:14:10.407 [8] ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: 'Jobs on dbxxxxxx' is not indexed 16 Jun 2017 11:14:10.665 [63] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Exception while re-indexing MyDBName on dbxxxxxx: Exception: database is locked database is locked 16 Jun 2017 11:14:10.666 [49] ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: 'MyDBName on dbxxxxxx' is not indexed 16 Jun 2017 11:14:10.667 [49] ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: 'Jobs on dbxxxxxx' is not indexed 16 Jun 2017 11:14:10.667 [6] ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: 'MyDBName on dbxxxxxx' is not indexed 16 Jun 2017 11:14:10.670 [6] ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: 'Jobs on dbxxxxxx' is not indexed 16 Jun 2017 11:14:10.932 [65] ERROR RedGate.SQLSearch.Addin.LoggingErrorHandler - Exception while re-indexing MyDBName on dbxxxxxx: Exception: database is locked database is locked 16 Jun 2017 11:14:10.935 [47] ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: 'MyDBName on dbxxxxxx' is not indexed 16 Jun 2017 11:14:10.936 [47] ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: 'Jobs on dbxxxxxx' is not indexed 16 Jun 2017 11:14:10.935 [54] ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: 'MyDBName on dbxxxxxx' is not indexed 16 Jun 2017 11:14:10.964 [7] ERROR RedGate.SQLSearch.Addin.Tab.Controller - Search failed: 'Jobs on dbxxxxxx' is not indexed 16 Jun 2017 11:14:35.258 [1] INFO RedGate.SQLSearch.UsageReporting.ApplicationUsageHelper - The reporting of product and feature usage information did not complete in the allotted time during shutdown (this will not affect normal operation of the software) Regards and hope this helps, Greg / comments
  1. Community
  2. SQL Search
  3. No search results
Also having this issue with SQL Search 2 v 2.4.4.1453 on SSMS 2014. Deleting index folder contents didn't help. Tried Jessica R June 14 4-step method, works for the session but closing and opening...
0 votes
Total activity
2
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1