Anybody know if this bug has been fixed? It was posted in August of 2016 and I do not see a resolution yet.
https://support.quest.com/kb/210371
Title
Alter View window can cause table locking
-
Description
In the background, when doing an Alter View or Alter View as Script, Toad executes the following to get information about the table in a view
USE [YourDB];
BEGIN TRANSACTION;
SET FMTONLY ON;
SELECT * FROM tablename
COMMIT TRANSACTION;
SET FMTONLY OFF;The problem is that a COMMIT TRAN is issued in between the SET FMTONLY ON and OFF which means it will never be actually run. The COMMIT should be after the SET FMTONLY OFF command. This can cause long term blocking.
-
Resolution
WORKAROUND
none
STATUS
Waiting for fix in a future release of Toad for SQL Server