data_pgs command includes dbid parameter

The data_pgs command includes an optional parameter, dbid. You must re-create any stored procedures that use data_pgs.

The new syntax is:

data_pgs([dbid], object_id, {data_oam_pg_id | index_oam_pg_id}


For example:

Example 2

Pages = data_pgs(4,, i.doampg)
from pubs2..sysindexes i, pubs2.sysobjects o
where =
and > 100
and (indid = 1 or indid = 0)

For more information about the data_pgs command, see the Reference Manual.