Altering Databases - Advanced Tab

Specifies how locking is handled in the database and specifies the start ID for elements on new objects.

To open this window, on the File menu, choose Database, choose Alter, and then choose the Advanced tab.

Locking Options

Field Description

Lock timeout

Specifies whether a session waits to place a lock on a resource that has already been locked by another session.

If you clear this field, then the session waits indefinitely.

Timeout duration (sec)

Specifies the maximum length of time that a session waits to place a lock on a resource that has already been locked by another session. The default value is 10 seconds.

Designer Options

Field Description

Start ID (UidOffset)

Specifies the start ID for elements on new objects. When you create a new table, page, report, codeunit, query, or XMLport, the elements have IDs that are offset by the Start ID (UidOffset) value that you specify. Object elements include containers, groups, fields, parts, DataItems, columns, filters, variables, functions, or text constants.

You must specify an Integer that is greater than or equal to 0.

The default value is 1.

See Also

Tasks

How to: Alter Databases
How to: Specify the Start ID Offset of Elements on Objects

Concepts

Altering Databases - General Tab
Altering Databases - Database Files Tab
Altering Databases - Transaction Log Files Tab
Altering Databases - Collation Tab
Altering Databases - Options Tab
Altering Databases - Integration Tab