upgrading to sql server

with out a more detailed error message.

i can assome its the stored procedures as they aren't in the Access version. you need to run the MSSQL+Server_setup.asp file to create the stored procedures. you will have to edit the file so it wont cause errors, when trying to create the tables, that already will exist.

there is a pinned topic within the support forums about upgrading to SQL from access

what Version are you using (V7.9?)

in an old topic i saw this

 ""If you use dts to copy your tables make sure that you enable Identity insert in the table options.""

where is the table options i cannot find??

In a Nuthshell, like djair basically said, you create the empty db like you already did, run the setup file to have all tables and sp's. Then you import the tables using DTS in the right order meaning don't contradictforeign keys by i.e. importing forum groups before forums, go from bottom to top. In the DTS Wizard click on the Transform button and select 'Enable Identity Insert' and 'Delete rows in Destination Table' You may have to do more then one pass because DTS 8.0 does not let you sort the tables the way it's necessary.

and for the author table it says this error....

'INSERT STATEMENT conflicted with COLUMN FOREIGN KEY constraint tblAUTHOR_FK00

i am doing a common and mistake i think but its the first time i am related with SQL...i am sorry ...thanks for helping mee