How to create a DEFAULT object (Enterprise Manager)

How to Install SQL Server 2000

How To

How to create a DEFAULT object (Enterprise Manager)

To create a DEFAULT object

  1. Expand a server group, and then expand a server.

  2. Expand Databases, and then expand the database in which to create the DEFAULT object.

  3. Right-click Defaults, and then click New Default.

  4. In Name, enter a name for the DEFAULT object.

  5. In Value, enter the value for the DEFAULT object. The value can be a constant, expression, or variable.

  6. Optionally, click:
    • Bind UDTs to bind the new DEFAULT object to a user-defined data type.

    • Bind Columns to bind the DEFAULT object to an existing column in a table.

See Also

Creating and Modifying DEFAULT Definitions