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


The information in this article applies to:

  • Microsoft SQL Server 7.0
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.
Modification Type:MajorLast Reviewed:10/16/2002
Keywords:kbBug KB201044
©2002 Microsoft Corporation. All rights reserved.