Mini sql2000 small database 1.29 Green version

Introduction to mini sql2000 database functions

MSSQL2000 database service opening and closing control

Mini sql2000 database can realize basic database operations (change password, create new database, delete, detach, attach, backup, restore)

Log and connection information, simple firewall, self-starting settings, scheduled tasks (automatic backup and execution), etc.

Mini sql2000 database installation steps

1. Download the mini sql2000 database software package from Huajun Software Park.

2. Unzip the software package and find the execution program in the folder as shown below:

3. Double-click to open the execution program, fill in the corresponding instance name and service port, and click "Open" to use it.

How to use mini sql2000 database

Run the program>Set instance name>Set port>Enable.

If you need the program to automatically start the service, please check Automatically start. Start at startup means it starts with the OS.

Ways to distribute it with your software

Run the mini sql2000 database program;

Check automatic startup, startup and service guard;

Package the software and accompanying files into your installation program.

You can also directly attach or restore the database used by the software you need to distribute to this software, thereby eliminating the need to restore the database.

Regarding the problem that UAC cannot be started automatically when UAC is not disabled in vista/win7/win8, please follow the steps below to solve the problem.

Run this program, set the instance name and service port, and check automatic startup and service guarding;

Open Start>Control Panel>System and Security>Scheduled Tasks;

Create task>General>Enter name>check the box below and run with highest privileges;

Trigger》Start task Select At Login》Settings Select All Users》Advanced Settings Check Enable;

Operation》Operation Select Startup Program》Program or Script Select sql2k.exe in the mini-SQL2000 directory;

After the above settings are completed, click OK to save, and then you can restart win7 for testing.

Mini sql2000 database frequently asked questions

How to uninstall mini sql2000?

1. Delete the SQL installation directory under Program files (if there is important data here, please back it up first) C:Program FilesMicrosoft SQL Server80Tools. C:Program FilesMicrosoft SQL ServerMSSQL.

2. Delete the relevant information in the registry: HKEY_LOCAL_MACHINESOFTWAREMicrosoftMSSQLServer. HKEY_LOCAL_MACHINESystemCurrentControlSetServicesMSDTC.

3. Find the PendingFileRenameOperations project in HKEY_LOCAL_MACHINESYSTEMCurrentControlSetControlSession Manager and delete it. This will clear the installation pending items.

4. HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsCurrentVersionsetup Delete ExceptionComponents There may be a lot of content under this project. Only when the above methods fail, use this method (be careful not to delete them all) and read the content description before deleting the content.

5. The Sqlstp.log file in the Windows directory, which lists details of the operations performed by the installer and contains any errors encountered during installation. By examining this file, you can learn more about where and why the installation failed.

6. The error information during SQL installation is saved in a log file called Errorlog. By default, this file is located in the Program FilesMicrosoft SQL ServerMssqlLog directory. This error log contains errors encountered by SQL-Server when the installer attempts to start SQL-Server. This information can help you check the cause of the error in depth.

7. Another component to check is the Microsoft Data Access Components (MDAC) installer, which is started as part of the SQL-Server2000 installer. The SQL-Server2000 installation program will install MDAC2.6. The MDAC installer creates a separate log file named Dasetup.log; you can review this log file and make sure there are no problems with the MDAC installer.

Precautions for mini sql2000 database

1. This software must define the instance name and port, and the database in this software has no directory restrictions;

2. Create, attach and restore the database. These operations will save or transfer the database to the DATA directory of the directory where the software is located, and will also adjust the physical file name and logical name of the database file;

3. When deleting or detaching a database, the user connections of the target database will be automatically cleared;

4. The firewall only implements the connection and disconnection operation based on the network card address connected to the PC.

5. The scheduled task will only write to the configuration file when checked, and the task will be read and started after the service is started. If the database defined in the scheduled task is deleted or separated, the task will be automatically canceled;

6. If you need to use the default instance, please do not publish it to a machine that has MSSQL installed and uses the default instance. This will cause MSSQL on the target machine to not work properly;

7. The default password of the administrator account SA is 593106. Please enter this password when unlocking for the first time, and then change the password on the database page.

SQL Server 2000 compared with other databases

SQL Server 2000 is a small and medium-sized database:

Advantages:

It is easy to use, provides rich functions, and has better performance than databases such as ACESS and MySql.

Disadvantages:

1. It is not free to use. Of course, if you use pirated copies and don’t worry about copyright issues, then there is nothing to say;

2. The performance is not as good as that of large databases, such as SQL2008, ORACLE, DB2, etc.;

3. The support for .net is not as good as SQL2005 or above;

4. It cannot be transplanted to LINUX and can only be run in Windows. The security is not high enough and its 1433 port is often attacked.

The editor summarizes: Everyone should choose the appropriate database management software to download according to their own needs. The editor thinks that the mini sql2000 software is very easy to use, convenient and practical, and can realize general functions. If you need it, you may wish to download it and give it a try.

Mini sql2000 database update log

Allow the use of empty passwords when changing passwords to facilitate the connection of some software that requires empty passwords

Fixed the problem that the query analyzer lacks dynamic libraries and syntax highlighting is not activated under win10

Added support for large-capacity data access, added bcp command, allowing the use of bcp command in SQL to import and export big data

Add support for data batch processing SQL commands such as BULK INSERT and OPENROWSET

Fixed an error when the list is empty when editing or deleting user views, stored procedures, and user functions in View My Table

Add the ability to export table structures, indexes, views, stored procedures, and user functions as SQL statements in View My Table.