Larry, I have seen this happen before - I suspect that the original table was set up by a user account which is not the account that Imail is currently using to connect to SQL server. EG SA or the dbo account. Then, possibly during a period of high activity on your box or due to a dead lock the Imail was not able to access the table. Taking this to mean that the table did not exist it then created a new table with the same name but a different owner and now is using this table to reference against.
My bet is that an awful lot of users are not being able to log in right now on to that domain and emails are being bounced. Check that the two accounts from the new table exist in the old table and then delete the new table. This will allow the rest of the domain to function properly. To prevent the problem from happening again make sure that all your domain tables are owned by the user that Imail is using to access sql server. (sp_changeobjectowner should do the trick) Regards, Pat -----Original Message----- From: Larry Craddock [mailto:[EMAIL PROTECTED] Sent: 05 May 2004 16:08 To: [EMAIL PROTECTED] Subject: [IMail Forum] really strange sql occurence Running Imail 8.11 and MS SQL2K. Never seen anything like this before and didn't even realize it was possible. Yesterday morning email quit altogether for a specific domain only. I started poking around and couldn't find anything wrong until I looked at the Imail database with enterprise manager and found 2 tables with the exact same name for the domain that wasn't working. One had a creation date coincidental with the time email quit. It contained 2 user accounts and the root account. I renamed the new db and email instantly began working. I didn't think it was possible to have multiple tables with the same name in the same db??? Anyone ever seen anything like that before? Is it possible the webmail templates are susceptible to a sql injection and someone was trying to write over the table for that domain? Unfortunately only a couple of days prior I had set my sql logs to minimal info while working on backups and there is nothing there, or in the system event logs, or in the iis logs that look suspicious. Ideas? thanks, Larry Craddock 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/
