SYSID_SP_* tables

Creation date: 06/12/2021 11:42 Updated: 06/12/2021 11:42

Question:

Hi Team,

Sir Jason is asking if you can investigate these tables as below image.

These tables are being created daily that seems abnormal, and there are more than a hundred right now.

He's asking if this is normal or not.

Regards,

Aubrey

Solution:

There is an issue in the Stored procedure (SP) - idseq.

The SP keeps generating temp table without clearing the old ones.

Edit the SP to delete the old temp table before creating new one.