Search results for query: *

They are all already set to 1. I have tried to update all of them manually to 1 (just in case) and still no joy.

Thanks for that detailed explanation and I have tried this already - so have a couple of other PMs but to no avail. It sounds like your latter comment seems to be the issue. It may be some settings in the view that I have - either in the left pane or the Gantt Chart pane. Could you elaborate...

Hi, I have MS Project 2003. For some reason, the width of each line is double-width rather than single width. This is shown in the attached document. Someone else has MS Project 2000 and they have copied and pasted the plan with single-width. When I open the plan that they save, it comes up as...

Thanks.

Hi, I have started to use some of the Act Reports and they are fantastic - although it keeps on crashing when I try combinations of the out-of-the-box reports. I need help in getting a set of reports for my purpose. Any help appreciated. 1) I need to put into Act the Number of mailshots/Event...

Hi, I just saw a tutorial for Act 2009 which has Activities by user in it. Is this feature available in 2008 (10.0) Version 10.0.1.199? If so, how do you get to it. I want to see every employee and set targets and monitor them in Act Dashboard if possible. Regards, Vivek

Thanks Mike.

Hi, I can see there are Security Roles but in the Restricted security role, it gives them restricted functionaility to all the data. I wanted to know if there is anyway in which I can restrict access to a certain filtered data to a user? E.g. I only want one person to see Graphics Designers...

Thanks. I am so shocked that Sage do not provide this functionality though.

Please note that I have read the forums for similar questions and they all seem to point towards the itImport.Net tool. The problem is that I need to export the current state of History records, manipulate it outside by a third-party firm and then import with the new records. The standard export...

Hi, I want to be able to export data from within Act (including history) and create further history records and then import it back in. Is this possible? If not, is there another easy way of exporting the data and then modifying it externally (information relating to the customer) and then...

OMF is a huge topic and if you want to view the benefits, then have a look at https://cwisdb.cc.kuleuven.ac.be/ora10doc/server.101/b10739/omf.htm If you do not specify CONTROL_FILES parameter, then the filename of the control file and the location is specific to the Operating System. Please see...

What is the state of the package from SQL*Plus before and after you hit it using SQL*Plus and VB? In 9i the package is compiled on first hit - same as 8i - so I would not expect errors in respect to compilation. Regards, Vivek

Firstly, check the row count for TALS_LI_STG table, its table definition. If the row count is significantly different, then check when the primary key - PK_INSRD_LI_STG - was it last analyzed. Can you drop it and create it again before analyzing it. Let us know what you find. Regards, Vivek

Please provide declaration of cursor as well as the parameters used in the called procedure. Thanks, Vivek

Hi, This relates to the maximimum SGA allocated to Oracle which is allocated by ther server when Oracle is started up. You need to change a parameter in Oracle called sga_max_size in either your pfile or spfile. Within Oracle Enterprise Manager, go into the options: Instance -> Configuration...

You will need to increase the size of your undo tablespace. Find out which datafile UNDOTBS tablespace is using: select file_name from dba_data_files where tablespace_name = 'UNDOTBS'; Then resize that datfile: ALTER DATABASE DATAFILE '<name of file>' RESIZE 3000M; But Undo tablespace...

When you start the database, please explicitly state the init.ora file : startup pfile='/.././init.ora' This will ensure that the init.ora file you are looking at is the one the database is looking at.

Add an index to C_STDCODE_RES column and run the query: SELECT /*+ index (A DDUP_INDEX_NEW) */ A.* FROM NAPS_DDUP_PER_INDX_NEW A WHERE A.C_REF_NO <> '0713403128312' AND A.C_STDCODE_RES = '0671' ; Then run : SELECT /*+ index (A DDUP_INDEX_NEW) */ A.* FROM...

Add another undo tablespace UNDOTBS2 using Enterprise Manager. Take the original undo tablespace UNDOTBS1 offline. This should be sufficient but if you want to keep the name of your tablespace same as before, you can now create UNDOTBS1 and then offline and drop UNDOTBS2. Vivek