Marco,

> > You can perform a total of 254 metadata changes on a database object. As
> > soon as one object reaches this magic total, you won't be able to connect
> > to the database before backing up and restoring. This will restore the
> > change counts on all objects to zero.
>
> How can I see the actual counter for the database objects ?

The counter is related to relations, and for each relation
the metadata change counter is stored within the system
table rdb$relations.

Try:

select rdb$relation_name, rdb$format from rdb$relations


Where rdb$format is the actual counter.


HTH,
Thomas Steinmaurer
http://www.iblogmanager.com