Removed Items From The Database Are Still There

nwallaceedoc

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?

Anu D

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?

nwallaceedoc

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.

Anu D

Do you run SSMS as 'Run as' and change the user?

Can we have a quick remote session where I can see your screen?