2011

Table Of Contents
Working with SQL Server Data
AutoCAD Map 3D supports SQL Server version 2005 and
SQL Server Spatial
(page 561). Both provide comprehensive data support, along with spatial
indexing, optimistic concurrency, and read-committed transaction isolation.
It uses a revision number for optimistic concurrency.
AutoCAD Map 3D supports SQL Server authentication for SQL Server data
stores. The
FDO (page 2062) User is mapped to the SQL Server login. Grant access
to the databases whose data you want to use.
NOTE This functionality affects geospatial feature data only. For information about
linking records in an external database to objects in a drawing, see
Overview of
Linking Database Records to Objects
(page 522).
What SQL Server Schemas Support
A SQL Server
schema (page 2073) can support the following:
Inheritance
Multiple schemas
Object properties (with limitations)
Association properties (with limitations)
Schema overrides
Auto ID generation
Default values
Inclusive value range constraints
Exclusive value range constraints
Value constraints list
Null value constraints
Unique value constraints
Composite unique value constraints
Spatial contexts
Working with SQL Server Data | 559