I had a problem with extractusers.exe and sql. I did the extract and then imported the users into MSSQL7 using MS DTS wizard on the fixed space text file. I thought it worked quite well until I couldn't log into web messaging because it would crash and in Imail Admin, the user list would come up, but no attributes like FULLNAME or mail address. As well, if I clicked on a user and then clicked on the Info Manager tab, Imail would close itself (sound familiar?)

I noticed there were spaces after the values in the varchar fields, to solve all these problems I trimmed the field columns with this: (note I am not that good with SQL, I only started using it yesterday)

UPDATE tablename set fieldname = rtrim(fieldname)

You have to do it for all the varchar fields.

I am not sure if you need to do this if you use the extractusers to enter it into the database at the same time. Hope this helps somebody save some time!

Craig.