SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
SQL Server Programming Reference
Database Engine Administration Programming
SQL-DMO
SQL-DMO Reference
Properties (SQL-DMO)
I (SQL-DMO Properties)
ID Property
ID Property (DistributionArticle2)
Identity Property
IdentityIncrement Property
IdentityRangeThreshold Property
IdentitySeed Property
Impersonate Property
ImpersonateClient Property
ImportRowsPerBatch Property
InActiveDirectory Property
InAlter Property
IncludeDB Property
IncludeDependencies Property
IncludeEventDescription Property
IncludeIdentityValues Property
IncludeLogins Property
IncludeUsers Property
IndexedColumns Property
IndexOnTable Property
IndexSpaceUsage Property
IndexSpaceUsed Property
Initialize Property
InPrimaryKey Property
InsertCommand Property
InstanceName Property
InsteadOfTrigger Property
Isbulkadmin Property
IsClustered Property
IsComputed Property
Isdb_accessadmin Property
Isdb_backupoperator Property
Isdb_datareader Property
Isdb_datawriter Property
Isdb_ddladmin Property
Isdb_denydatareader Property
Isdb_denydatawriter Property
Isdb_owner Property
Isdb_securityadmin Property
Isdbcreator Property
IsDeleted Property
IsDeterministic Property
Isdiskadmin Property
IsDistributionPublisher Property
IsFullTextEnabled Property
IsFullTextInstalled Property
IsFullTextKey Property
IsNumeric Property
IsOnComputed Property
Isprocessadmin Property
IsRowGuidCol Property
IsSchemaBound Property
Issecurityadmin Property
Isserveradmin Property
Issetupadmin Property
Issysadmin Property
IsVariableLength Property
ItemCount Property
Expand Minimize
This topic has not yet been rated - Rate this topic

IncludeIdentityValues Property

SQL Server 2005

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

The IncludeIdentityValues property controls the handling of existing values for a column with the Microsoft SQL Server identity property when data is copied to the SQL Server table.

Copy 

object
.IncludeIdentityValues [= value]
object

An expression that evaluates to an object in the Applies To list

value

TRUE or FALSE

Boolean

Read/write

Copy 
HRESULT GetIncludeIdentityValues(LPBOOL pRetVal);
HRESULT SetIncludeIdentityValues(BOOL NewValue);

If TRUE, SQL Distributed Management Objects (SQL-DMO) runs a SET IDENTITY_INSERT ON statement when the ImportData method of a Table object is called.

If FALSE, SQL-DMO ignores any data values present for a column with the identity property. SQL Server generates data values for the column by using the column's setting for identity seed and increment. The default is FALSE.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.