I had to apply this index to tempdb (created by my missing index script).

CREATE INDEX [missingindex2019RG_AllObjects] ON [tempdb].[dbo].[RG_AllObjects] ([Expired]) INCLUDE ([DatabaseID], [ObjectType], [ObjectID])

This is a work-around until the DB service gets re-started and then I have to re-execute the statement because tempdb gets re-built.

Also, there is no way that I know of to disable Sql Prompt which was blocking the create index statement. The only way I got the index applied was to hop to another computer without Sql Prompt.

Index management in tempdb needs to be managed better.