Populating tblAuthor from SQLServer 2K

There are posts regarding importing but my question is bit different (if not I'll accept a link as a response to this post )

I want to import a bunch of users from another sql2k db into tblAuthor. I am not using encrypted passwords and I want people to be automatically logged in.

If I do a simple insert statement or use the Enterprise Manager Import Utility will User_code automatically populate or does it get it's unique value after an insert is made into that column? Should i include it in my insert statement? I have the same question for the salt field. Is this the same for each user?

TIA!
Rich

Thanx for the info boRg.

I used a little script to loop through a recordset containing the results of my other members table and do an insert on each into tblAuthors. Inefficient but there's only about 90.

I put the username into the user_code field. After a user logs in the system appends a value to the user_code and we're off and running.

So far I have not encountered any problems with encrypted passwords being disabled. I'll post back here if I do though. Thanks again!