Modifying a SP generates "This object requires rebuilding ..."

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
papker
Posts: 4
Joined: Mon 06 Feb 2017 18:44

Modifying a SP generates "This object requires rebuilding ..."

Post by papker » Tue 07 Feb 2017 19:07

Since the last upgrade, I am receiving a warning "The object requires rebuilding, this may result in the loss of some properties." any time I make a small change to a stored procedure.

At first I thought the message wasn't really relevant because the change I was making was very minor, however after doing some testing, it appears that security rights are being removed.

This has rendered the tool virtually unusable for managing any stored procedures.

I tried to submit a support incident yesterday, however I never receive any notification or feedback since then.

dbForge Profession for SQL version 5.4.211
Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (X64)
• Standard Edition (64-bit) on Windows NT 6.0 <X64> (Build 6001: Service Pack 1) (Hypervisor)

alexa

Re: Modifying a SP generates "This object requires rebuilding ..."

Post by alexa » Wed 08 Feb 2017 12:15

We are aware of this issue and will fix it in one of the next product builds. We will notify you once it's available for downloading.

alexa

Re: Modifying a SP generates "This object requires rebuilding ..."

Post by alexa » Fri 10 Feb 2017 14:26

We would like to let you know that we have released dbForge Studio for SQL Server, v5.4.215 where the issue you reported is fixed https://www.devart.com/dbforge/sql/studio/download.html

Thank you for your help in improving dbForge Studio for SQL Server.

Post Reply