Return
-
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.
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.