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:
- Make a full backup.
- Launch Microsoft SQL Server Manager.
- Run the following script against each of the company databases:
Grant Alter on pc90101 to DYNGRP