SQL Server 2000 Lite version + green version

SQL Server 2000 SP4 Enterprise Edition Lite version 8 M

I used to download a lite version from the Internet, but I had to install too many things to destroy the original SQL on my machine. I modified my green SQL that I had been using some days ago, package and install the program,
The SQL Server 2000 query analyzer and client network utility are provided, and the performance is not bad. It has passed the trial on XP and 2000. No problem. I didn't want to release it, But I still hope it will be helpful, especially when testing the database.

:( The provided by the author is invalid! I uploaded it to the online storage)
Http://drag0n.qupan.com/463961.html
Http://www.ccmen.net/UploadFiles/download/2008-8/200883122412088933.rar

Including simple database management functions. If you find it useful, you can use it by yourself. If it is useless, you can delete it.

Internal functions starting with XP _ of SQL Server must be unavailable and file registration is required. However, as a database engine, there is no problem, but some management functions are missing.
Note:
IP address \ mysql
For example, 192.168.1.1 \ mysql
The local machine can use a decimal point such as. \ mysql

[From: http://bbs.winzheng.com/viewthread.php? Tid = 1570254]

 

========================================================== ========================

Sqlgreen edition from http://www.suisoft.cn/blog/is also very useful!

SQL Server Green Edition 6.2 (with built-in firewall)

Green SQLServer description

Copyright
---------------------------
Only GSQL is retained. EXE copyright. Other attached documents are copyrighted by Microsoft. This software is designed for technical research, delete the attached SQL Server File within 24 hours after downloading the software or replace it with the purchased genuine SQL Server File. Otherwise, the consequences will be borne by you. the author shall not assume any responsibilities for you.

Help
---------------------------
1. to connect to the server locally, use the text in the "server name" text box on the interface as the server name to connect to the server (the MDAC version must be 2.6 or later ).
Default User name: sa
Default password: admin

2. for remote connection, use "IP address and port". Disable the server firewall before connecting! (The port is displayed on the status page after the server is started .)
Example: 192.168.0.X: 7788

3. After the database is converted to a relative path, you need to restart the green SQL statement to move it at will.

4. database files (*. mdf + *. ldf) directly copy to the MYDB directory, restart the SQL, and then automatically attach it to SQLSERVER (the database name already exists, and the log files and database files are not ignored ).

5. The database can be restored using the database recovery tool provided by the software only in absolute path mode.

How to package and release the program together
---------------------------
1. Start SQL
2. Attach the corresponding database
3. Convert to relative path
4. Stop SQL statements
5. Start SQL
6. Stop SQL
7. On the SQL settings page, select auto start manager, auto start SQL, and hide after connection.
Hide to the tray. If it is a registered version, you can also choose to start in service mode.
8. Pay attention to running GSQL. EXE automatically after installation.
9 Completed

How to use a program to control SQL Start and Stop
---------------------------
Method 1
----------------
Const
MyMsg = WM_USER ++ $7788;
MyMsg_StartSql = $ FF0C;
MyMsg_CloseSql = $ FF0D;

// Handle is the Handle of the green SQL manager Main Window
// Start SQL
Postmessage (Handle, MyMsg, MyMsg_StartSql, 0 );
// Stop SQL
Postmessage (Handle, MyMsg, MyMsg_CloseSql, 0 );

Method 2
----------------
Simulate hotkey
Win + F4 (start SQL ).
Win + F5 (stop SQL ).

Version Upgrade history
---------------------------
2007. XX. XX
To solve the problem, we decided to rewrite all the green SQL code. Compare original
There are many new versions before version 5.63, as shown in the following code:
01. Added support for service startup.
02. Improve code efficiency.
03. Added support for custom interfaces after registration.
04. Enhance scheduled tasks.
05. added the library management function (very powerful ).
06. added the function of automatically registering servers in the Enterprise Manager.
07. Brand new interface brand new code
And so on. I will not list them one by one.
One thing. 2008 is a new green SQL

2008.01.30: 01. Modify the length of the split line.
02. When publishing is modified, the manager is enabled by default to automatically start SQL.
03. Change the password icon.
04. The text box input method is messy.
05. Remove U disk registration (too easy to forge ).
06. added an OEM form for the registered user.
07. Add a registered user to set whether to display the database management page.
08. added the option to disable scheduled tasks.
09. added a new version prompt.
10. Add the default SQL user name and password in the Help file.
11. Remove the registration server in the Enterprise Manager Registration

2008.01.31: 01. Added settings for OEM information in the Manager.
(Version 6.0) 02. Set the page registration display function to uneditable.
03. The current version is the official release version 6.0.

2008.02.12: 01. The BUG that the font background is transparent when the page is split.
(Version 6.1) 02. Added support for setting whether to display the settings page after registration.
03. An error occurred while modifying the registration of the query analyzer.
04. Modify the BUG that "register the server to Enterprise Manager" occupies 100% of the CPU.
05. added tool page tool sorting
06. Change the default port to 7788

2008.08.19: 01. Change the password to null (admin by default)
(Version 6.2) 02. Add to display the current connection list
03. added a string indicating successful connection.
04. free use of the registration function removed
05. modify the effect of the scroll bar on the settings page
06. added the firewall Function
07. added the connection method prompt
08. Optimized some code
09. Cancel the restrictions on starting the service mode (starting the service mode will automatically set the NT user to log on and start the manager to manage the database)

Unsolved Problems
---------------------------
1 because the firewall intercepts the TCP/IP protocol, it cannot intercept connections using the Shared Memory and Named Pipes protocols on the local machine, for example, "(local) \ Instance name ", any protocol used by other computers can be intercepted.
If you want to intercept all connections, you can set SQL to accept only TCP/IP connections (only IP and PORT connections can be used after the settings)
2 because the SQL proxy needs to register the service, it violates the purpose of the Green Edition, so this function is not used. To regularly execute tasks, you can use the scheduled tasks function of the manager.

Download address: http://www.powerip.net/download/GSQL6.4.rar

Many netizens asked me for Enterprise Edition patches! The Enterprise Edition cannot be green! Let me have a look!
The pure technology research directory is automatically deleted within 24 hours after the download. It's okay with me!
Enterprise Edition patch:

Http://www.powerip.net/download/Enterprise%20Edition%20SP4%20PACK.rar

(Decompress and delete the data binn directory of green SQL! Replace the two folders in the compressed package !)