SQL Server
United States (English)
Sign in
Home 2014 2012 2008 R2 2008 Previous Versions Library Forums
Export (0) Print
Expand All
TechNet Library
SQL Server
SQL Server 2014
Product Documentation
Developer Reference for SQL Server 2014
Developer Reference
Developer's Guide (Database Engine)
SQL Server Management Objects
SQL Server Management Objects Reference
Microsoft.SqlServer.Management.Smo
Database Class
Database Properties
ActiveConnections Property
ActiveDirectory Property
AnsiNullDefault Property
AnsiNullsEnabled Property
AnsiPaddingEnabled Property
AnsiWarningsEnabled Property
ApplicationRoles Property
ArithmeticAbortEnabled Property
Assemblies Property
AsymmetricKeys Property
AutoClose Property
AutoCreateIncrementalStatisticsEnabled Property
AutoCreateStatisticsEnabled Property
AutoShrink Property
AutoUpdateStatisticsAsync Property
AutoUpdateStatisticsEnabled Property
AvailabilityDatabaseSynchronizationState Property
AvailabilityGroupName Property
BrokerEnabled Property
CaseSensitive Property
Certificates Property
ChangeTrackingAutoCleanUp Property
ChangeTrackingEnabled Property
ChangeTrackingRetentionPeriod Property
ChangeTrackingRetentionPeriodUnits Property
CloseCursorsOnCommitEnabled Property
Collation Property
CompatibilityLevel Property
ConcatenateNullYieldsNull Property
ContainmentType Property
CreateDate Property
DatabaseAuditSpecifications Property
DatabaseEncryptionKey Property
DatabaseGuid Property
DatabaseOptions Property
DatabaseOwnershipChaining Property
DatabaseSegments Property
DatabaseSnapshotBaseName Property
DataSpaceUsage Property
DateCorrelationOptimization Property
DboLogin Property
DefaultDistributionPolicy Property
DefaultFileGroup Property
DefaultFileStreamFileGroup Property
DefaultFullTextCatalog Property
DefaultFullTextLanguage Property
DefaultLanguage Property
Defaults Property
DefaultSchema Property
DelayedDurability Property
EncryptionEnabled Property
Events Property
ExtendedProperties Property
ExtendedStoredProcedures Property
Federations Property
FileGroups Property
FilestreamDirectoryName Property
FilestreamNonTransactedAccess Property
FullTextCatalogs Property
FullTextStopLists Property
HasFileInCloud Property
HasMemoryOptimizedObjects Property
HonorBrokerPriority Property
ID Property
IndexSpaceUsage Property
IsAccessible Property
IsDatabaseSnapshot Property
IsDatabaseSnapshotBase Property
IsDbAccessAdmin Property
IsDbBackupOperator Property
IsDbDatareader Property
IsDbDatawriter Property
IsDbDdlAdmin Property
IsDbDenyDatareader Property
IsDbDenyDatawriter Property
IsDbManager Property
IsDbOwner Property
IsDbSecurityAdmin Property
ISfcSupportsDesignMode.IsDesignMode Property
IsFederationMember Property
IsFullTextEnabled Property
IsLoginManager Property
IsMailHost Property
IsManagementDataWarehouse Property
IsMirroringEnabled Property
IsParameterizationForced Property
IsReadCommittedSnapshotOn Property
IsSystemObject Property
IsUpdateable Property
IsVarDecimalStorageFormatEnabled Property
LastBackupDate Property
LastDifferentialBackupDate Property
LastLogBackupDate Property
LeadingColumnsForDistribution Property
LocalCursorsDefault Property
LogFiles Property
LogReuseWaitStatus Property
MasterKey Property
MemoryAllocatedToMemoryOptimizedObjectsInKB Property
MemoryUsedByMemoryOptimizedObjectsInKB Property
MirroringFailoverLogSequenceNumber Property
MirroringID Property
MirroringPartner Property
MirroringPartnerInstance Property
MirroringRedoQueueMaxSize Property
MirroringRoleSequence Property
MirroringSafetyLevel Property
MirroringSafetySequence Property
MirroringStatus Property
MirroringTimeout Property
MirroringWitness Property
MirroringWitnessStatus Property
Name Property
NestedTriggersEnabled Property
NumericRoundAbortEnabled Property
Owner Property
PageVerify Property
Parent Property
PartitionFunctions Property
PartitionSchemes Property
PlanGuides Property
PrimaryFilePath Property
QuotedIdentifiersEnabled Property
ReadOnly Property
RecoveryForkGuid Property
RecoveryModel Property
RecursiveTriggersEnabled Property
ReplicationOptions Property
Roles Property
Rules Property
Schemas Property
SearchPropertyLists Property
Sequences Property
ServiceBroker Property
ServiceBrokerGuid Property
Size Property
SnapshotIsolationState Property
SpaceAvailable Property
Status Property
StoredProcedures Property
SymmetricKeys Property
Synonyms Property
Tables Property
TargetRecoveryTime Property
TransformNoiseWords Property
Triggers Property
Trustworthy Property
TwoDigitYearCutoff Property
UserAccess Property
UserDefinedAggregates Property
UserDefinedDataTypes Property
UserDefinedFunctions Property
UserDefinedTableTypes Property
UserDefinedTypes Property
UserName Property
Users Property
Version Property
Views Property
XmlSchemaCollections Property
Expand Minimize

Database.NumericRoundAbortEnabled Property

SQL Server 2014

Gets or sets a value that specifies whether the NUMERIC_ROUNDABORT database option is active.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

C#
C++
F#
JScript
VB
Copy 
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase Or SfcPropertyFlags.Design Or SfcPropertyFlags.Matrix)> _
Public Property NumericRoundAbortEnabled As Boolean 
	Get 
	Set
'Usage
Dim instance As Database 
Dim value As Boolean 

value = instance.NumericRoundAbortEnabled

instance.NumericRoundAbortEnabled = value

Property Value

Type: Boolean
A Boolean value that specifies whether there is a loss of precision due to rounding in an expression causes an error. If True, an error is generated and no results are returned. If False (default), a warning is generated and a NULL is returned.

Implements

IDatabaseOptions.NumericRoundAbortEnabled

This option can also be changed by using the Transact-SQL ALTER DATABASE statement.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft