Toad World® Forums

TSS-1361 Fixed?

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