access to sql conversion problem

insert registration: error solved
by editing the table design thru enterprise manager. you have to make the column author_id in table author to integer with auto increment = 1

delete error solved
I just uploaded the file delete_post.asp again and it worked. that is strange though because the old file worked fine with the access version !!!

I still have the error of DB statistics (I uploaded the file again but doesn't work)

new error New user
A new registered user gets problems while try to do these things:
- view the profile
- send pm or read pm that new user send
- post new message
and more problems

all those problems seems occurs because of default values in table author like join_date = now() and it should be getdate() for ms-sql
same thing with column no of posts etc...
I fixed the problem with new registration by editing table desing my self,  is there an better way to convert the table author into ms-sql?? instead of having to edit all columns manually??  are there other tables that will need editing??

thanks in advance