SQL SERVER 2000 installation full Raiders 1 (new installation)

Server| Raiders


to Beginners: (old bird will be free to see, don't laugh!) ）





for users who have used SQL SERVER 2000, it is generally known that the version and the previous version of the larger difference between the system is also more picky, for the installation is indeed relatively simple, but often have to install the loser, in the forum to see a lot of questions on the issue, the manuscript for reference.





installation System recommended: Windows SERVER, Windows ADVANCED Server (MSDE and Personal Edition can be installed in Windows XP);


WINDOWS 2000 installation is not introduced here, relatively simple, there are wizards, but pay special attention to the following points. Emphasis: Recommended file system format: NTFS, high security, installation of high success rate, FAT32 can also, but often some inexplicable problems. If the installation is not using NTFS, you can convert it with tools such as PowerQuest PartitionMagic. (superfluous, more than I know); there is also a DOS command that can be easily implemented: CONVERT; users installed under XP, it is recommended that you use MSDE.


in fact, the installation process of SQL SERVER 2000 is also very simple, Microsoft's Guide does have a certain level. However, the key for the following database connection to provide a prerequisite for the first mention. The following is installed under Windows Server:





Insert SQL SERVER 2000 CD, the interface appears:











Select "Install SQL Server 2000 Components",











Select "Install Database Server",











"Next";











here, on the local computer;











default;











If you install MSDE, select Client-only tools, where default ... Go down to the following, choose the blending mode, fill in the password (my password is 123), next (here in the installation is completed, you can modify in the "Enterprise Manager"):











the number of devices or processors to be filled in according to license,











Finally, the installation is complete.











SQL SERVER 2000 unloading load points:





If SQL SERVER 2000 is uninstalled normally, you will never succeed if you want to reinstall it. Delete the \program Files\Microsoft SQL Server\80 directory in the original installation path, then reload on it, of course, if you uninstall before the database is useless, will \program Files\Microsoft SQL The server is all deleted, which is the equivalent of a new installation. We are now only deleting \program Files\Microsoft SQL Server\80.





refer to "SQL SERVER 2000 installation Strategy 1" after the installation is complete, enter the start-> program->microsoft SQL server-> Enterprise Manager, the left tree layer open to the "database" right click, pop-up menu: All Tasks- > Additional database:











Select the appropriate file in the attached database form (default in the \program Files\Microsoft SQL Server\MSSQL\Data Directory, depending on the choice of the library), OK, Fix it! Some netizens here suggest to delete some registration information, I installed and reinstall several times, did not move the registration information, installation is normal, hope that we verify.











makes it easy to maintain and manipulate databases using SQL Server 2000 's own tools, creating databases and tables easily: On the database right-click menu, create a new database











Enter the database name (MyDatabase) in the edit box after the name, and then check to see if the data file and transaction log settings meet your requirements (this is the default) and then OK.










After the
database was successfully established, you can see the new database:











Next you can build the table, on the "table" right click, select "New Table" and then in the pop-up dialog box to fill out the table's field content, and then exit, the system prompts whether to save, and then enter the table name (here named student) can:











OK, a student table is set up.





the same method to build a class table;











Modify Table structure: Right-click student, select "Design Table", in the pop-up dialog box, change the name data type to varchar, length 16, close and save.











using SQL, you can write and run the SQL statement from the main menu: Tool->sql Query Analyzer, open.











Enter the statement in the previous figure and press F5 to run it. Then enter the Enterprise Manager to refresh the interface, the original student table was deleted, the new set up a students table.





Currently, we are building two tables with class and students.





SQL SERVER 2000 connection to SQL Explorer:


after opening SQL Explorer, Ctrl + N, the following dialog box pops up:








OK, and then fill in the related items (mostly database name, USER name, SERVER name):











Enter the actual after ctrl+a,apply, then double-click MyDatabase, enter the password, completed.