Use the SQL Server Database Editor to define options for a database in a SQL Server 2008 physical model.
To define SQL Server 2008 database options
The SQL Server Database Editor opens.
Note: Use the Enter filter text box to filter a very large list of databases to quickly locate the one that you want to define.
Specifies whether the cursor scope is LOCAL or GLOBAL. If the cursor scope is LOCAL, unless the cursor is defined as GLOBAL, the cursor scope is local to the batch, stored procedure, or trigger where the cursor was created. If the cursor scope is GLOBAL, the scope of the cursor is global to the connection.
Specifies whether the cursor is closed or remains open when a transaction is committed or rolled back.
Specifies when to roll back incomplete transactions when the database is transitioned to a different state.
Defines how long (in seconds) after a state change in the database before it rolls back. Enter a value in this field.
Note: You must set the termination option to TIME to use this option.
Specifies user access to the database.
Specifies whether database updates are permitted.
Specifies whether SQL Server maintains correlation statistics between any two tables in the database that are linked by a FOREIGN KEY constraint and have datetime columns.
Note: When this option is selected, only a single connection to the database is allowed.
Determines how queries are parameterized, whether based on the default behavior of the database, or if all queries are parameterized.
Specifies whether the database is closed and all resources freed when the last user exits.
Specifies whether SQL Server automatically creates missing statistics needed for a query or if they must be made manually.
Specifies if the database is a candidate for periodic shrinking.
Specifies if any outdated statistics required by a query are automatically updated during query optimization.
Specifies whether the query that initiated an update to the statistics waits for the statistics to update before compiling.
Specifies the recovery option set for the database. If the recovery option is not specified, the default is set to the recovery model of the model database in SQL Server. Select the recovery type from the drop-down list.
Specifies if torn pages can be detected by the SQL Server database engine.
Determines if and how a database page was damaged by disk I/O errors.
Database options are defined and the SQL Server Database Editor closes.
Copyright © 2013 CA.
All rights reserved.
|
|