sql-server-maintenance-solution icon indicating copy to clipboard operation
sql-server-maintenance-solution copied to clipboard
verified publisher icon olahallengren

IndexOptimize failing on Azure SQL Managed Instance when user tables exist in master

Open SelectDBA opened this issue 4 years ago • 0 comments

When running IndexOptimize against master on a Azure SQL Managed Instance, and if there are any user tables present in master, it fails with the following error:

Msg 50000, Level 16, State 1, Procedure dbo.IndexOptimize, Line 1912 [Batch Start Line 0] Msg 2573, Could not find table or object ID 1655676946. Check system catalog.

The object ID corresponds to the user table, which does exist when you check against sys.tables.

SelectDBA avatar Jan 04 '22 15:01 SelectDBA