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
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 "Caroline" wrote in message news:1191483266.895728.306380@19g2000hsx.googlegroups.com... > 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 >
