How can we help you today? How can we help you today?

Removed Items From The Database Are Still There

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?
nwallaceedoc
0

Comments

3 comments

  • 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?
    Anu D
    0
  • nwallaceedoc
    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.
    nwallaceedoc
    0
  • 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?
    Anu D
    0

Add comment

Please sign in to leave a comment.