Error creating a new resource

From: Veroniq (anonymous_at_discussions.microsoft.com)
Date: 09/14/04


Date: Tue, 14 Sep 2004 04:04:31 -0700

Hallo Claudia,
have you apllied a SP1 on SQL server (and STS) too?
The service packs can be found at
http://support.microsoft.com/?kbid=830240.
Hope this helps.

Veroniq

>-----Original Message-----
>Hello,
>I have upgraded my Project Server to SP1 and very soon
after that when
>I try to create a new resource from Project Professional
I get this
>SQLServer error message and the resource pool file results
>checked-out, the error is the following:
>
>[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 rows resulting from the operation did not qualify
under the CHECK
>OPTION constraint.
>
>I tried to create a new resource from PWA and I get the
following
>message:
>VBScript: Microsoft Office Project Web Access 2003: An
error occurred
>while completing the operation.
>
>Does anyone have experienced something similar? Can
anyone help?
>
>Thanks,
>
>Claudia
>.
>



Relevant Pages

  • Error creating a new resource
    ... I have upgraded my Project Server to SP1 and very soon after that when ... I try to create a new resource from Project Professional I get this ... SQLServer error message and the resource pool file results ... update failed because the target view either specifies WITH CHECK ...
    (microsoft.public.project.pro_and_server)
  • Re: Fulltext failure on a 2 node cluster
    ... No cluster resource for that cluster has shown as failed. ... There are NO error messages in SQL Server or the event log. ... Server full-text search resource online: ...
    (microsoft.public.sqlserver.clustering)
  • Error installing SQL Server 2000 (MDAC failure - "element not found")
    ... SQL Server 2005 features work great. ... 10:21:42 End Action ShowDialogsHlpr ... Progress: Loading Resource Library. ... : InstallSection.NT = DefaultInstall ...
    (microsoft.public.sqlserver.setup)
  • Re: Passive node starting the SQL Server services - services set t
    ... Possible owners list is not sorted, I.E. the order does not matter. ... lost the IP ADDRESS resource long enough to start a failover or restart ... both settings are the same). ... drive not being available - the server name is the SQL Server Network ...
    (microsoft.public.sqlserver.clustering)
  • Re: Passive node starting the SQL Server services - services set t
    ... "Geoff N. Hiten" wrote: ... Preferred owners list IS sorted by most preferred owner first. ... lost the IP ADDRESS resource long enough to start a failover or restart ... drive not being available - the server name is the SQL Server Network ...
    (microsoft.public.sqlserver.clustering)