> Imail will create its own table with the same name as the view > (don't know how because this is not suppose to be allowed in MS SQL)
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>. If 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. -Sandy 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/
