How much memory the server has? Do any other applications run in same server? How is memory be configuered in SQL Server? It looks like you have some memory shortage issue....

Import wizard will only transfer data from Access to SQL Server. You have to rebuild the keys and indexes manually.

You can use Access Upsize wizard to migrate the Access database to...

What did you try to do when you received this error? What is your locks Option setting? You can get it from sp_configure.

No idea why you got index id -1 here. What you can do is to rebuild the indexes and dbcc checktable back to see same error still occurs. If it...

How much memory are being used by SQL Server instances? Can you post the result of "select * from sysprocesses where waittime > 0 order by waittime desc"? If there...

No.

Alter table modifies a table definition by altering, adding, or dropping columns and constraints, or by disabling or enabling constraints and triggers. See BOL for complete syntax.

What indexes does the table have? Run dbcc checkdb to see whether you have any errors.

CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name

    ON { table | view } ( column [ ASC | DESC ] [ ,...n ] )

[ WITH...

What type of jobs are they? Any error messages regarding to the timeout - blocked, Lock_timeout, Server unavailavle etc? You have to try to find out why they are timeout.

Save the trace file into a table and let your manager to query the information from there.

SQL Server Profiler.

What is your checkpoint value? Any example?

Check function DATEDIFF in BOL.

In addition to memory configuration, you should monitor your application performance in SQL Server since adding more CPUs could change the query execution plan, for example, query is going to...

You can't administer SQL server 6.5 with 2000 EM.

It is a constraint. Check primary key ... in option tab.