On migrated installations of ServiceDesk R12, on running pdm_publish "ERROR 15 [Microsoft OLE DB Provider for SQL Server] [ SQL Code=1088 SQL State=42000] Cannot find the object "dbo.zXXXXX" because it does not exist or you do not have permissions." appears. This document explains the steps to resolve the issue.
When the error message stated in the summary appears, all the Web Screen Painter related files get updated with the new table name.
Ex: wsptbl, wspschema.log, wsp.mods
However, the table is not created in the MDB.
To resolve the issue:
This time it will create the table in the database and updates the wspschema.log file with the table name again.