N
Nigel
Hello,
I'm trying to find out whereabouts the nonproject time is
stored within Server 2002 and am hoping some kind soul
would point me in the right direction.
I can extract the categories of non-working time that I
have created from the database easily -> select * from
MSP_WEB_NONWORKING_CATEGORIES
However when I look at the stored non-working records
using -> select * from MSP_WEB_NONWORKING, I get nothing
returned, indicating that there isn't any data stored in
the DB.
I have read talk on this group about a built-in
Administrative project, but I have queried the DB for the
existing projects and only see the ones that I have
created. I can only assume that this is a Server 2003
feature that isn't in 2002.
When I log onto the server as a user and look at the
stored non-working time I can see time entered against
various non-working time categories.
When this time is entered an 'Update' cannot be done,
presumably because there is no project to update back to,
so a 'save' is done instead. The save stores the non-
working time but not in the database it would seem.
After writing all that I guess my question is, is the time
stored in the databse and I'm just looking in the wrong
place, or if it isn't stored in the DB where then is it
stored.
Thanks to anyone with useful advice.
Nigel
I'm trying to find out whereabouts the nonproject time is
stored within Server 2002 and am hoping some kind soul
would point me in the right direction.
I can extract the categories of non-working time that I
have created from the database easily -> select * from
MSP_WEB_NONWORKING_CATEGORIES
However when I look at the stored non-working records
using -> select * from MSP_WEB_NONWORKING, I get nothing
returned, indicating that there isn't any data stored in
the DB.
I have read talk on this group about a built-in
Administrative project, but I have queried the DB for the
existing projects and only see the ones that I have
created. I can only assume that this is a Server 2003
feature that isn't in 2002.
When I log onto the server as a user and look at the
stored non-working time I can see time entered against
various non-working time categories.
When this time is entered an 'Update' cannot be done,
presumably because there is no project to update back to,
so a 'save' is done instead. The save stores the non-
working time but not in the database it would seem.
After writing all that I guess my question is, is the time
stored in the databse and I'm just looking in the wrong
place, or if it isn't stored in the DB where then is it
stored.
Thanks to anyone with useful advice.
Nigel