SQL Server based C/S database application System

SQL Server 6.5, as a network database service system for small and medium-sized enterprises, provides the same performance as many advanced database managers, and challenges the traditional database vendors. In program design: SQL Server 6.5 simplifies programming with a critical and novel symmetric structure, and Microsoft provides a good control for programmers in its Visual Basic visual programming language; In database management: SQL Server 6.5 handles multiple server transaction management in a manageable way, providing a way to extend the SQL Server system beyond the capabilities of a single computer. 

SQL Server 6.5 mainly has the following features:

Comprehensive data integrity protection, whether complex transaction support and advanced security, user-oriented database implicit parts, and data integrity protection;

Integrated with Windows NT, allows for thorough multithreading and symmetric processing in SMP (symmetric multiple processing) systems, and can be integrated into a distributed management environment;

Also has outstanding performance on the low cost platform;

Provide a first-class management tool for the system administrator;

Intrinsic support for multiprocessor "distributed" transactions. 

Here's how to use Microsoft SQL Server 6.5 to build a development environment on a Windows NT server to complete a general client/server application system. 

1. Create a data device on SQL SERVER 6.5 (you must create a storage device for the database before you create the database) 

(1) Open SQL EM from within the Microsoft SQL Server 6.5 utilties program group. 

(2) In Server Manager window, select the server that created the database. such as HFNM. 

(3) Select the Manage menu item and select the Database device option. The Manage Database device window appears. 

(4) Select the new Device button (first). The New Database device window appears. 

(5) Name: For the device name to be created; Location: You can choose where to create the device (such as: C:\databas e); Size (MB): Used to set the size of this device (typically 1.25 times times the database). 

(6) Click the Create Now button to create the device. 

Note: You must create two storage devices before creating the database, one is the physical device of the database, and the other is the logical device for the database. 

2. Create a database on SQL SERVER 6.5

(1) Open SQL EM from within the Microsoft SQL Server 6.5 utilties program group. 

(2) In Server Manager window, select the server that created the database. such as HFNM. 

(3) Select the Manage menu item and select the database option. The Manage Database window appears. 

(4) Select the new Database button (first). The New Database window appears. 

(5) The name item is the database name, the data Device is the database physical device name, the size is the storage space allocated by the physical device to the database (MB), the Logic Device is the database logical device name, and the size is the storage space (MB) that the logical device allocates for the database. Please do not check the default device option. 

(6) Press the Create Now button to formally create the database. 