SQL Search has stopped indexing stored procedures &functions

A free Management Studio add-in to search for SQL in your databases

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Adam, justin.caldicott, Mike Upton

SQL Search has stopped indexing stored procedures &functions

Postby georhill » Thu Jun 20, 2013 5:21 pm

I noticed that SQL Search was not returning all stored procedures that had certain words in them (for example, the word \"daily\") because I had just changed a bunch of them and added that word.

I tried refresh and force reindex without success. Based on another post, I deleted the index file for the one database that was having the problem.

Unfortunately this caused SQL Search to blow up when I tried to search, reindex or force index on that database. I got around this by copying and renaming a different index file for a database with the same schema.

SQL Search still does not appear to be indexing the contents of stored procedures in this database. Any workarounds or suggestions appreciated.
georhill
 
Posts: 13
Joined: Thu Jan 27, 2011 8:31 pm

Postby ckosti » Tue Jul 02, 2013 7:24 pm

I don't know exactly what you mean by \"blow up\", but if SQL Server Management Studio was running when you deleted the cache files, then SQL Search will throw errors like \"SQLite error: no such table: syscomments\" and \"SQLite error: no such table: meta\", even after you restart SSMS.
ckosti
 
Posts: 2
Joined: Tue Jul 02, 2013 6:47 pm


Return to SQL Search 1

Who is online

Users browsing this forum: No registered users and 0 guests