Custom changes to ROB-EX Server

This paragraph explains areas of ROB-EX Server customization outside those handled by the configuration file

Changing size of database fields

ROB-EX Multiuser server supports change of the default column size for selected database fields. The following columns may be changed:

To manually change the column sizes for selected columns the SQL command

ALTER TABLE <Table> ALTER COLUMN <Column> <Type>(<Size>)

must be executed for each column going to be changed. The values <Table>, <Column>, <Type> and <Size> must be taken from the table listed above.

To execute SQL command start the osql utility by selecting “Start/Run…” and enter the command “osql -U ganttAdmin”

Enter the ganttAdmin password and then enter the following commands in the sequence specified below:

USE GanttMultiuser
go

/* change column size for EOperation.Description to 200 rather than default of 100 */
ALTER TABLE EOperation ALTER COLUMN Description VARCHAR(200)
go
exit

To verify the existing size of a column use the build in sp_columns stored procedure. Example listing the settings of column “description”:

USE GanttMultiuser
go
/* Verify current column setting for table EOperation */
exec sp_columns @table_name='EOperation', @column_name='description'
go
exit

Clear/wipe existing multiuser database

If you delete a site from the Web-admin interface, data for this site remains in the database. However users can no longer connect to this site. To delete the data out of an existing GanttMultiuser database you will need to manually run this script from MS SQL Management Studio, on the database you want to clear. Remember to edit the script specifying what site to delete, before you run it.

ganttServerG2\install\sql\deleteSite.sql

Alternatively you can use this script on the database, to delete all sites.

ganttServerG2\install\sql\allclean.sql

Afterwards you need to restart the Multiuser service