David,
You probably know this already but it took me forever to figure this
out so I thought I'd post it anyway in case someone else needs to
know.
If you want to alias another user as dbo for the database to avoid the
user_name issue on the database objects you can do the following:
----------------------------------------------------------
1) Create a user 'myloginname' and provide rights to the database
2) From the database remove the user
3) set the alias
a) open Query Analyzer
b) "use" the database
c) sp_addalias @loginame='myloginname', @name_in_db='dbo'
Terry Fritts
Monday, July 1, 2002 you wrote:
DS> The view was created in EM under a different logon as the
DS> Imail logon.
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/
