The number of user connections controls the number of simultaneous connections to SQL Server. If users are reporting that they can not connect, you will need to increase this value. Since a single user will normally spawn multiple connections simply be starting qan application, this value should normally be set to about 150% of the maximum number of simultaneous users that you expect.

user options

The user options are used to set global defaults for users logging into the system. Each of these options can be overridden by an individual connection by issuing a set command.

Database Options

At the next level of option settings are those that can be applied to each database. On many production systems, you will never change these settings since they can have a significant impact on the recoverability of a database.

ANSI empty strings

ANSI empty stings allows you to store an empty string in the database. Many development tools and programming languages use an empty sting to represent the absence of data. Only in extreme cases you should turn this option on since it can cause problems in data retrieval and make it appear that data is getting "lost". If ANSI empty strings is disabled and an application attempts to place an empty string into a column, SQL Server translates this in three different ways:

• If the datatype is datetime or smalldatetime, 1/1/1900 will be stored.
• If the datatype is character in nature, a space will be stored.
• If the datatype is numeric in nature, a zero will be stored.

ANSI null default

When creating a table, you can define the nullability of each column. The ANSI nulls default option controls how SQL Server interprets the create table statement if an explicit nullability is not specified. Because this can be set differently than expected, make sure you explicitly specify the nullability of each column in the create table statement.

dbo use only

Turning on dbo use only disallows any user except the database owner from accessing a database. If this option is turned on while other users are already accessing a database, they will not be disconnected. But, new connections will be disallowed from all users except dbo. You would normally place a database in dbo use only when performing some sort of administrative action or for those databases reserved exclusively for administrative use.

default to local cursor

The default to local cursor sets the cursor scope of all declared cursors to local.

merge publish

The merge publish option allows a database to participate in merge replication. Turning this option on does not enable merge replication. Replication must be defined separately and this option is normally turned on during the set up of replication.

SQL Server 7.0 Server, Database, and Query options 1 2 3 4 5 6 7 8