Knowledge Base

BUG: Error 208: Create Trigger Statement Fails in SQL Enterprise Manager

Article ID: 201044

Article Last Modified on 10/16/2002

Microsoft SQL Server 7.0 Standard Edition

This article was previously published under Q201044

BUG #: 51314 (SQLBUG_70)

SYMPTOMS

If you set the focus on a table and attempt to create a trigger in SQL Enterprise Manager (SEM), it fails with the following error if two tables exist with the same name but different owners:

Error 208: Invalid object name 'table_name'.

CAUSE

This error occurs because SQL Enterprise Manager does not qualify the name of the table based on the owner, even though the specific table is selected.

WORKAROUND

To work around this problem, explicitly specify the owner of the table when creating the trigger.

STATUS

Microsoft has confirmed this to be a problem in SQL Server 7.0.

Additional query words: ent man entman err msg message

Keywords: kbbug kbpending KB201044