A free Management Studio add-in to search for SQL in your databases
Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Paul Stephenson, Michelle Taylor, Mike Upton, Adam, justin.caldicott
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.
- Posts: 13
- Joined: Thu Jan 27, 2011 8:31 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.
- 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