reindex not working on renamed stored procedure

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

reindex not working on renamed stored procedure

Postby jihohanbnpp » Fri Aug 08, 2014 7:28 pm

Using SQL 2005 Management Studio...

I renamed a stored procedure and clicked "reindex", it seemed to reindex. But when I search for the old name, the stored procedure is still returned in the result and has the old text (with the old name). Searching for the new name returns the same (with the old name after CREATE PROCEDURE). If I click "Select object in Object Explorer" it takes me to the renamed (now with new name) stored procedure in the object explorer.

I'm not sure if the lifetime of the index is for the duration of sql management studio but I haven't restarted mine so I can't confirm that.

Otherwise, this is a very simple and easy to use tool that offloads the work I have to do to search for terms in my procedures.


Microsoft SQL Server Management Studio 9.00.4035.00
Microsoft Analysis Services Client Tools 2005.090.4035.00
Microsoft Data Access Components (MDAC) 6.1.7601.17514 (win7sp1_rtm.101119-1850)
Microsoft MSXML 3.0 4.0 5.0 6.0
Microsoft Internet Explorer 9.0.8112.16421
Microsoft .NET Framework 2.0.50727.5477
Operating System 6.1.7601
Posts: 2
Joined: Fri Aug 08, 2014 7:17 pm

Postby Anu Deshpande » Mon Aug 11, 2014 12:38 pm

Thanks for your post and sorry for the issue you are having.

Can you please follow below mentioned steps:

1. Close SSMS

2. Delete contents of this index folder: C:\\Users\\<username>\\AppData\\Local\\Red Gate\\SQLSearch 2\\Indexes3. Open SSMS

4. Try to replicate the issue.

Does this helps?
Anuradha Deshpande
Product Support
Redgate Software Ltd.
Anu Deshpande
Posts: 839
Joined: Mon Apr 20, 2009 2:53 pm
Location: Cambridge

Return to SQL Search 2

Who is online

Users browsing this forum: No registered users and 0 guests