Removed Items From The Database Are Still There

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

Moderator: dom.smith

Removed Items From The Database Are Still There

Postby nwallaceedoc » Thu Aug 21, 2014 9:28 pm

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
 
Posts: 2
Joined: Thu Aug 21, 2014 9:26 pm

Postby Anu Deshpande » Mon Aug 25, 2014 3:06 pm

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?
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Re:

Postby nwallaceedoc » Mon Aug 25, 2014 3:53 pm

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.
nwallaceedoc
 
Posts: 2
Joined: Thu Aug 21, 2014 9:26 pm

Postby Anu Deshpande » Thu Aug 28, 2014 11:47 am

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

Can we have a quick remote session where I can see your screen?
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Search 2

Who is online

Users browsing this forum: No registered users and 0 guests