Thanks alot Steve, think in this case I'll go with DTS as we do have workflow.

Have a good weekend

If the log contains multiple physical log files, then the logical log will move through all of the physical log files before it wraps back to the start of the...

Is he using 2005 ?

use datbase name

update sysobjects set uid = 1 where uid = 6

This is writing straight to the system catalog which works perfectly but isn't advised by Microsoft.