• yujinagata72 (8/17/2016)


    Hi,

    Is there any way to find out what tables have been disabled for lock escalation in the database?

    Thanks,

    sys.tables has this information:

    https://msdn.microsoft.com/en-us/library/ms187406.aspx

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service