Chapter 1 INTRODUCTION TO SQL SERVER 2000 27
Chapter 1 INTRODUCTION TO SQL SERVER 2000 27 Triggers can be used to validate the data being entered and to enforce data integrity. Database roles. Users can be assigned to various database roles that determine what access they have to which database objects. A role is a collection of users and permissions. Members of a role inherit the permissions associated with the role. A user may be a member of many roles, and the permissions are cumulative. Database diagrams. Database diagrams are graphically created outlines of how your database is structured. Database diagrams show how tables, and the fields that compose the table, are related. Constraints. A constraint is an attribute a column or table can take to restrict what users enter into your database. For example, you may want only unique values to be entered into a certain column. To do this, use a UNIQUE constraint. Indexes. An index is a database object that provides fast access to data in the rows of a table, based on key values. Indexes can also enforce uniqueness on the rows in a table. SQL Server supports clustered and nonclustered indexes. The Primary Key constraint of a table is automatically indexed. Each database object has its own properties that make it an important piece of the entire picture. this blog looks deep into the SQL Server object structure and looks independently at each part of SQL Server from multiple perspectives. Client Network Utility The Client Network utility is used to manage the client net-libraries and define server alias names. It can also be used to set the default The Client Network Utility This utility is installed in SQL Server by options used by DB-Library applications. This tool is not very diffi default. It can be installed on other cult to use. It can impact the connectivity of client computers computers if you execute a Network accessing SQL Server. For the client and server to run on the same Libraries Only installation, which computer, they must be running the same network library. The is done by selecting Connectivity Client Network utility is used to configure and even possibly change from the Installation Type the network library in use on the client. selection screen. In some cases, an instance of SQL Server may be configured to listen on alternate network addresses. If this is done, client applications NOTE
For high quality java hosting services please check java web hosting website.