Views are not supported but will work up until you get to a point where an upgrade to IMail needs to modify the table (add columns, etc). So unless you want to check after every update and make manual changes to the view and underlying table(s) do not use views.
Eric S ----- Original Message ----- From: "Smart Business Lists" <[EMAIL PROTECTED]> To: "Lostboy" <[EMAIL PROTECTED]> Sent: Wednesday, August 21, 2002 7:52 PM Subject: Re: [IMail Forum] MSSQL and Views > Wednesday, August 21, 2002 you wrote: > L> Ok, I know I am going to sound like an idiot but, How in Imail do I > L> set the Domain to look at a View instead of a Table? > > I know this has been discussed and several admins have reported > successfully using views. You might search the archives. I don't > think this was too long ago. > > Surely someone else will reply but in the meantime you might try > putting brackets around the view name and check to see if your view > names are owned by the dbo user so they don't need to be qualified. > Maybe you can qualify them in the IMAIL table name too but I don't > know. > > Terry Fritts > > > To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html > List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ > Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/ > To Unsubscribe: http://www.ipswitch.com/support/mailing-lists.html List Archive: http://www.mail-archive.com/imail_forum%40list.ipswitch.com/ Knowledge Base/FAQ: http://www.ipswitch.com/support/IMail/
