Microsoft KB Archive/201044

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

Article ID: 201044

Article Last Modified on 10/16/2002

-

APPLIES TO


 * 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 ' '.



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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.