Red Gate forums :: View topic - Removed Items From The Database Are Still There
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Search 2
SQL Search 2 forum

Removed Items From The Database Are Still There

Search in SQL Search 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
nwallaceedoc



Joined: 21 Aug 2014
Posts: 2

PostPosted: Thu Aug 21, 2014 9:28 pm    Post subject: Removed Items From The Database Are Still There Reply with quote

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?
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 692
Location: Cambridge

PostPosted: Mon Aug 25, 2014 3:06 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
nwallaceedoc



Joined: 21 Aug 2014
Posts: 2

PostPosted: Mon Aug 25, 2014 3:53 pm    Post subject: Re: Reply with quote

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.
Back to top
View user's profile Send private message
Anu Deshpande



Joined: 20 Apr 2009
Posts: 692
Location: Cambridge

PostPosted: Thu Aug 28, 2014 11:47 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group