Modifying a SP generates "This object requires rebuilding ..."
Posted: 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)
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)