> > If you create a database object under a sysadmin user, the object's > canonical name is <database>.dbo.<object>. If created by any other > kind of user, the object's name is <database>.<username>.<object>.
This is what I surmised because it added the username to the end of the table in <> > you reference an unqualified object name, SQL first qualifies it with > your username (or dbo if you are a sysadmin), then under dbo. So it is > completely possible to have multiple objects with the same unqualified > name, but not with the same canonical name. This is no doubt how the > view was created--one of the logins involved had sysadmin permissions, > and the other did not. The view was created in EM under a different logon as the Imail logon. Thanks for the xplain. David Please visit http://www.ipswitch.com/support/mailing-lists.html to be removed from this list. An Archive of this list is available at: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Please visit the Knowledge Base for answers to frequently asked questions: http://www.ipswitch.com/support/IMail/
