Running IndexOptimize and getting the following error (it's against the master database):
Msg 50000, Level 16, State 1, Procedure dbo.IndexOptimize, Line 1912 [Batch Start Line 0]
Msg 2573, Could not find table or object ID 1975678086. Check system catalog.
Not sure why I cannot see the table...it's there and even dropped and re-created it.
SQL Server version and edition
Microsoft SQL Azure (RTM) - 12.0.2000.8
Nov 16 2022 04:43:19
Copyright (C) 2022 Microsoft Corporation
Version of the script
Version: 2022-12-03 17:23:44
What command are you executing?
EXECUTE [dbo].[IndexOptimize]
@Databases = 'SYSTEM_DATABASES'
, @UpdateStatistics = 'ALL'
, @OnlyModifiedStatistics = 'y'
, @LogToTable = 'Y'
What output are you getting?
Msg 50000, Level 16, State 1, Procedure dbo.IndexOptimize, Line 1912 [Batch Start Line 0]
Msg 2573, Could not find table or object ID 1975678086. Check system catalog.
Running IndexOptimize and getting the following error (it's against the master database):
Msg 50000, Level 16, State 1, Procedure dbo.IndexOptimize, Line 1912 [Batch Start Line 0] Msg 2573, Could not find table or object ID 1975678086. Check system catalog.
Not sure why I cannot see the table...it's there and even dropped and re-created it.
SQL Server version and edition Microsoft SQL Azure (RTM) - 12.0.2000.8 Nov 16 2022 04:43:19 Copyright (C) 2022 Microsoft Corporation
Version of the script Version: 2022-12-03 17:23:44
What command are you executing? EXECUTE [dbo].[IndexOptimize] @Databases = 'SYSTEM_DATABASES' , @UpdateStatistics = 'ALL' , @OnlyModifiedStatistics = 'y' , @LogToTable = 'Y'
What output are you getting? Msg 50000, Level 16, State 1, Procedure dbo.IndexOptimize, Line 1912 [Batch Start Line 0] Msg 2573, Could not find table or object ID 1975678086. Check system catalog.