bulk custom field SQL update?

[david.dienes]

Hi All!

Is it possible to do a bulk custom field update through az SQL UPDATE command?

More precisely: I have a TaskEnterpriseText5 field used at each task. This should contain our external ERP (SAP) project number. We have about 100 open projects where this field should be polulated (about 500 tasks).

I can read this field like this, but not sure whether allowed to update anything in Project Server tables...

select distinct convert(varchar(50),TaskEnterpriseText5) from MSP_VIEW_PROJ_TASKS_ENT

Using Project Server 2003 and SQL Server 2000.

Thanks,
David