How to correctly install sql2000 database under Win7 64-bit system

  
                                    

1, first open the Enterprise Manager, you may see several instances after opening, the instance of the newly built SQl2000 is also inside, and then it will find that it is not started by default, manually open;

2 Then open the Query Analyzer, this time you will find it is connected to the SQL2005 server, in order to make it properly connected to the SQl2000 server, you need to open the SQL server Server Manager to select your database instance, copy the entire name, copy to The SQL server implements the connection query;

3, and then implement the construction of the table in the database, the specific method is as shown below:

4, if successful, if successful, please Continue the following operations;

5, when there is a problem that can not be saved, click on the column name of any row in the header of the design table, and right click on the property, then you will see a box, in the table name Modify it to the desired table name, you can save it (the default is filled in Table1 and so on).

Copyright © Windows knowledge All Rights Reserved