Can't add new ressource - error save resglobal

[Caroline]

We are running Project Server 2003 with SP1.

I am the Project Server Admin and for the last week, when I try to
add
new resources to the global resource pool, I get a dialog box message
back stating:


[Microsoft][ODBC SQL Server Driver][SQL Server]The attempted insert
or
update failed because the target view either specifies WITH CHECK
OPTION or spans a view that specifies WITH CHECK OPTION and one or
more
row resulting from the operation did not qualify under the CHECK
OPTION
constraint.


Clicking the OK button produces another box:


Project Server was unable to find the specified resource.
If the problem continues, contact your server administrator.


The resglobal is then locked out and must be checked back in through
my
Web Access Admin account.


Do you have an idea about this problem?

Caroline

 

[Mike Glen]

Hi Caroline,

Try posting on the server newsgroup as this one is closing down. Please see
FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful
Project information can be seen at this web
address:http://project.mvps.org/faqs.htm .

Mike Glen
Project MVP