sp_dboption

Adaptive Server 15.7 ESD #3 introduces a new parameter for the sp_dboption system procedure.

deallocate first text page
The values for deallocate first text page are:
  • false – default, do not deallocate the first text page after a NULL update.
  • true – deallocate the first text page after a NULL update.
For example:
use master
go
sp_dboption mydb, "deallocate first text page", true 
go