We dropped a table and then removed it from all the Stored Procedures that called it. When we search for the name of the table it is still showing up. I have tried to click Reindex and manually deleted the Indexes in my user folder. Can anybody please help?
Comments
3 comments
-
Thanks for your post.
So you deleted all the indexes files from here: C:\Users\<username>\AppData\Local\Red Gate\SQLSearch 2\Indexes\ from here?
Did you restart your SSMS after that? -
Anu Deshpande wrote:Thanks for your post.
So you deleted all the indexes files from here: C:\Users\<username>\AppData\Local\Red Gate\SQLSearch 2\Indexes\ from here?
Did you restart your SSMS after that?
Yes I deleted all the indexes from that directory and restarted SSMS. -
Do you run SSMS as 'Run as' and change the user?
Can we have a quick remote session where I can see your screen?
Add comment
Please sign in to leave a comment.