1.3. CLIENT-SERVER ARCHITECTURE

Client-Server, or two-tier, Architecture consists of a

  • client program— makes requests, e.g., Enterprise Manager, Query Analyzer, VB or C Program

  • server program— responds to those requests

The client program usually has a graphical user interface (GUI) and may run on the same computer, or machine or host, as the server program. The client may run on a different host than does the server as long as they have some network connection.

The server program often does not include a GUI as part of its program and is managed only by using a client. The MSS 2K database engine has no direct user interface and is managed through the Enterprise Manager GUI or an SQL client such as Query Analyzer, OSQL or ISQL. See Figure 1-2 ...

Get Transact-SQL Desk Reference now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.