You're supposed to use the object id of the trigger, not the table.

select objectproperty(object_id('name of trigger'), 'ExecIsTriggerDisabled')