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

ID: Q201044

The information in this article applies to:

Microsoft SQL Server version 7.0

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 version 7.0.

Additional query words: ent man entman err msg message

Keywords : SSrvEntMan kbbug7.00
Version : winnt:7.0
Platform : winnt
Issue type : kbbug