Cannot Find the Object “pc90101” because it does not exist or you do not have Permissions.

This article replaces TK00090.

Error:

When you create an SOP routine in Project Cost, you receive the following error.

[Microsoft]SQL Server Native Client 10.0][SQL Server]Cannot find 
the object "pc90101" because it does not exist or you do not have 
permissions.

Cause:

The SQL group ‘DYNGRP’ does not have permission to alter the table pc90101.

Resolution:

  1. Make a full backup.
  2. Launch Microsoft SQL Server Manager.
  3. Run the following script against each of the company databases:
Grant Alter on pc90101 to DYNGRP