Error Constants (SQLDMO_ERROR_TYPE)

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新しい開発作業では、この機能の使用を避け、現在この機能を使用しているアプリケーションは修正するようにしてください。

SQL Distributed Management Objects (SQL-DMO) errors are categorized, grouping errors returned by source or process. SQL-DMO defines the macro SQLDMO_ECAT_MASK, which can be used to determine the error category. For more information about using SQLDMO_ECAT_MASK, see SQL-DMO エラーの処理 (SQL-DMO) and Helpful Macros.

The following table documents SQL-DMO error categories.

Constant

Value

Description

SQLDMO_ECAT_/INVALIDCONTEXT

0x5000

Method call, property get, or property set is not valid in context.

SQLDMO_ECAT_INVALIDOBJECT

0x5100

SQL-DMO object is not valid.

SQLDMO_ECAT_/INVALIDOBJECTDEFINITION

0x5200

Microsoft SQL Server component creation failed due to error in definition of component.

SQLDMO_ECAT_/INVALIDPARAMETER

0x5300

Invalid argument value on method call or property set.

SQLDMO_ECAT_/INVALIDPLATFORM

0x5400

Invalid version of SQL Server or an invalid version of SQL-DMO.

SQLDMO_ECAT_ITEMNOTFOUND

0x5500

Collection item dereferencing errors (item not locatable by name or ordinal position out of range).

SQLDMO_ECAT_/UNPRIVILEGEDLOGIN

0x5600

Login used for SQLServer object connection does not have sufficient privilege to perform the requested operation.

SQLDMO_ECAT_EXECUTION

0x5700

Errors indicating a query execution error or an inaccessible database.

SQLDMO_ECAT_CONNECTION

0x5800

SQLServer object failed an automatic reconnect attempt. A connection cannot be restored.

SQLDMO_ECAT_RESOURCE

0x5900

Insufficient resources either locally or on the server.

Errors masked by SQLDMO_ECAT_INVALIDCONTEXT include the following.

Constant

Value

Description

SQLDMO_E_ALREADYCONN

0x5000

Attempt to use the Connect method of a connected SQLServer object.

SQLDMO_E_ALREADYCOLL

0x5001

Attempt to add an object redundantly to its containing collection.

SQLDMO_E_NOTCONN

0x5002

SQLServer object is not connected.

SQLDMO_E_CANTDROPSERVER

0x5003

Reserved.

SQLDMO_E_NOCOMPLEXALTER

0x5004

Attempt to modify a property not changeable on an existing SQL Server component.

SQLDMO_E_PROPNEEDSCREATE

0x5005

Property or method not available until the object (or its parent, if appropriate) references an existing SQL Server component.

SQLDMO_E_COLTYPEFIXED

0x5006

Data type is fixed length; no length can be specified.

SQLDMO_E_COLTYPENONNULL

0x5007

Data type does not allow NULL value.

SQLDMO_E_CANTCHANGEUDDT

0x5008

Attempt to set the AllowNulls, BaseType, Length, NumericPrecision, or NumericScale property of a UserDefinedDatatype object referencing an existing user-defined data type.

SQLDMO_E_BASETYPEFIXED

0x5009

Base data type is fixed length; no length can be specified.

SQLDMO_E_BASETYPENONNULL

0x500A

Base data type does not allow NULL values.

SQLDMO_E_ENUMORDINAL

0x500B

Reserved.

SQLDMO_E_CANTRENAMEUSER

0x500C

Attempt to set the Name or Login property of a User object referencing an existing user.

SQLDMO_E_CANTRENAMEGROUP

0x500D

Reserved.

SQLDMO_E_CANTRENAMELOGIN

0x500E

Attempt to set the Name property of a Login object referencing an existing login.

SQLDMO_E_CANTRENAMEDEVICE

0x500F

Attempt to set the Name, PhysicalLocation, SkipTapeLabel, or Type property of a BackupDevice object referencing an existing device.

SQLDMO_E_NOTDUMPPROP

0x5010

Reserved.

SQLDMO_E_NOSERVERASSOC

0x5011

Reserved.

SQLDMO_E_NOTCOLLTYPE

0x5012

Object type does not match the collection type on Add method call.

SQLDMO_E_/CANTMODIFYDRIINDEX

0x5013

Referenced index supports a declarative referential integrity constraint. Remove method of the Index object or Indexes collection fails, use Key object or Keys collection to drop the index.

SQLDMO_E_/CANTCHANGEPROCTYPE

0x5014

Attempt to set the Type property of a StoredProcedure object referencing an existing stored procedure.

SQLDMO_E_CANTMODIFYINDEX

0x5015

Attempt to set the FileGroup, IndexedColumns, NoRecompute, StatisticsIndex, or Type property, or attempt to use GenerateCreationSQL or GenerateSQL methods, of an Index object referencing an existing index.

SQLDMO_E_INVALIDPRIVOBJ

0x5016

Reserved.

SQLDMO_E_/CANTCHANGETRIGTYPE

0x5017

Reserved.

SQLDMO_E_NOVIEWCOLALTER

0x5018

Column object retrieved by using the ListColumns method of the View object cannot be used to modify the column referenced.

SQLDMO_E_/CANTRENAMELANGUAGE

0x5019

Reserved.

SQLDMO_E_CANTRENAMERSERVER

0x501A

Attempt to set the Name property of a RemoteServer object referencing an existing remote server.

SQLDMO_E_CANTRENAMERLOGIN

0x501B

Attempt to set the LocalName or RemoteName property of a RemoteLogin object referencing an existing remote login.

SQLDMO_E_MUSTBEDBDEV

0x501C

Reserved.

SQLDMO_E_NOINACTIVEMIRROR

0x501D

Reserved.

SQLDMO_E_NOACTIVEMIRROR

0x501E

Reserved.

SQLDMO_E_NOMIRROR

0x501F

Reserved.

SQLDMO_E_/SERVERDISCONNECTED

0x5020

SQLServer object DisConnect method has been called. Use Connect or ReConnect to reestablish connection.

SQLDMO_E_/CANTRENAMESERVER

0x5021

Attempt to set the Login, LoginSecure, LoginTimeout, Name, NetPacketSize, or Password property of a connected SQLServer object.

SQLDMO_E_CANTMODIFYTEXT

0x5022

Attempt to set the Text property of a Default or Rule object that references an existing component. Attempt to set the Text property of a StoredProcedure object that references an existing extended stored procedure.

SQLDMO_E_/CANTMODIFYSYSTABLE

0x5023

Attempt to set the Name property, or attempt to use BeginAlter, DoAlter, ImportData, Remove, or TruncateData method, of a Table object that references a SQL Server system table.

SQLDMO_E_/LOGINALREADYALIASED

0x5024

Error in alias reassignment performed by the SetOwner method.

SQLDMO_E_/LOGINALREADYUSER

0x5025

Error in user existence check performed by the SetOwner method.

SQLDMO_E_CACHENORESULTS

0x5026

Attempt to get or set a property or call a method on an empty QueryResults object.

SQLDMO_E_ALREADYCREATED

0x5027

Attempt to set a property or use the GenerateSQL method of an object that references an existing component.

SQLDMO_E_NOTDISCONN

0x5028

Attempt to call the ReConnect method of a connected SQLServer object.

SQLDMO_E_/CANTMODIFYARTTABLE

0x5029

Attempt to set the SourceObjectName or SourceObjectOwner property of an object that references an existing merge, transactional, snapshot, or distribution article.

SQLDMO_E_/PROPERTYCANNOTBEMODIFIED

0x502A

Attempt to set a property not changeable when the object references an existing replication component.

SQLDMO_E_/BASETYPENOTNUMERIC

0x502B

Attempt to set the NumericPrecision or NumericScale property of a Column or UserDefinedDatatype object that does not reference a fixed numeric precision and scale data type.

SQLDMO_E_/TOFILEBUTNOFILENAME

0x502C

Object scripting arguments specify a single file as output, and no file name is provided.

SQLDMO_E_CANTMODIFYKEY

0x502E

Attempt to set the Clustered, ExcludeReplication, FileGroup, Type, or ReferencedTable property of a Key object that references an existing primary or foreign key.

SQLDMO_E_LISTCANTREFRESH

0x502F

Attempt to use the Refresh method of a list object cannot complete. Re-call method returning the list object.

SQLDMO_E_NOCOLTABLE

0x5030

This column object is not associated with a table.

SQLDMO_E_MUSTBEINALTER

0x5031

Reserved.

SQLDMO_E_/CANTUNDEDICATELOGDEVICE

0x5032

Reserved.

SQLDMO_E_/CANTRENAMESERVERGROUP

0x5033

Attempt to set the Name property of a ServerGroup object that references an existing server group.

SQLDMO_E_/CANTRENAMEREGISTEREDSERVER

0x5034

Attempt to set the Name property of a RegisteredServer object that references an existing registered server.

SQLDMO_E_/INDEXREBUILDKEYTYPE

0x5035

RebuildIndex method called on a Key object that references a FOREIGN KEY constraint.

SQLDMO_E_/REBUILDINDEXOPTIONS

0x5036

Invalid IndexType argument specified on RebuildIndexes method call.

SQLDMO_E_/IMPERSONATEXPONLY

0x5037

Reserved.

SQLDMO_E_/CANTRENAMEPUBLICATION

0x5038

Attempt to set the Name property of an object that references an existing distribution, merge or transactional replication publication.

SQLDMO_E_/CANTMODIFYSPARTTYPE

0x5039

Attempt to change the ArticleType property of a TransArticle object that references stored procedure execution.

SQLDMO_E_INVALIDDISTDB

0x503A

DistributionDatabaseproperty of a DistributionPublisher object does not reference an existing database.

SQLDMO_E_CANTMODIFYTABLE

0x503B

Attempt to set the FileGroup or TextFileGroup property, or attempt to use the GenerateSQL method, of a Table object that references an existing table.

SQLDMO_E_/CANTDROPFILEGROUP

0x503C

Attempt to use the Remove method of the FileGroup object or FileGroups collection that indicates a file group that maintains indexes.

SQLDMO_E_/DEFAULTFILEGROUP

0x503D

Attempt to set the Name or ReadOnly property, or attempt to use the Remove method of the FileGroup object or FileGroups collection that indicates the primary file group.

SQLDMO_E_/NOTDEFAULTFILEGROUP

0x503E

Reserved.

SQLDMO_E_/CANTRESETLOGINTYPE

0x503F

Attempt to set the Type property of a Login object that references an existing login.

SQLDMO_E_/CANTRESETPASSWORD

0x5040

Attempt to set the AppRole or Password property of a DatabaseRole object that references an existing application role.

SQLDMO_E_PRESQL70

0x5041

Method or property no longer implemented.

SQLDMO_E_PROPBEFORECREATE

0x5042

Attempt to get the Password property of a DatabaseRole object or set the Role property of a User object that references an existing component.

SQLDMO_E_CANTRENAMEROLE

0x5043

Attempt to set the Name property of a DatabaseRole object that references an existing database role.

SQLDMO_E_/CANTDROPFIXEDROLE

0x5044

Attempt to use the Remove method of the DatabaseRole object or DatabaseRoles collection that indicate a system-defined database role.

SQLDMO_E_CANTADDTOAPPROLE

0x5045

Attempt to use the AddMember method of a DatabaseRole object that references an application role.

SQLDMO_E_CANTGETROLE

0x5046

Attempt to get the Role property of a User object that references an existing user. The Role property is read-write using the User object to create a user.

SQLDMO_E_USERDBROLE

0x5047

Attempt to use the ListDatabasePermissions or ListObjectPermissions method of a DatabaseRole object that references a system-defined database role.

SQLDMO_E_FIXEDDBROLE

0x5048

Attempt to use the EnumFixedDatabaseRolePermission method of a DatabaseRole object that references a user-defined database role.

SQLDMO_E_CANTMODIFYFILTER

0x5049

Reserved.

SQLDMO_E_INVALIDACTION

0x504A

Returned by the SQLBackup, SQLRestore, or SQLVerify method when the Action property of the object specifies an invalid operation.

SQLDMO_E_DBOPTION

0x504B

Attempt to use set the RecursiveTriggers property of a DBOption object that references the system database master.

SQLDMO_E_USEALTER

0x504C

Attempt to set the Text property of a StoredProcedure, Trigger, or View object that references an existing component. Use the Alter method to change component definition.

SQLDMO_E_CREATEDBPERM

0x504D

Attempt to use a Database object that does not reference the system database masterto grant, deny, or revoke permission to execute the CREATE DATABASE statement.

SQLDMO_E_CANTCHECKFK

0x504E

Attempt to set the Checked property of a Key object that references a primary key.

SQLDMO_E_NOTINMB

0x504F

Attempt to get the FileGrowthInKB property of a DBFile or LogFile object that references an operating system file expanded by percentage of current size calculation.

SQLDMO_E_/CANTRENAMELSERVER

0x5050

Attempt to set the Catalog, DataSource, Location, Name, ProductName, ProviderName, or ProviderString property of a LinkedServer object that references an existing linked server.

SQLDMO_E_/CANTRENAMELLOGIN

0x5051

Attempt to set the LocalLogin property of a LinkedServerLogin object referencing an existing linked server login.

SQLDMO_E_/CANTRENAMEFULLTEXT

0x5052

Attempt to set the FullTextCatalogName or UniqueIndexForFullText property of a Table object that references a full-text indexed table.

SQLDMO_E_NOFULLTEXT

0x5053

Attempt to set the FullTextIndexActive property of a Table object that references a table not full-text indexed, or attempt to set the FullTextIndex property of a Columnobject that references a column in a table not full-text indexed.

SQLDMO_E_ACTIVATEFULLTEXT

0x5054

Attempt to set the FullTextIndex property of a Columnobject that references a column in a table with full-text indexing active. Use the FullTextIndexActive property of the Table object to deactivate full-text indexing.

SQLDMO_E_/NOTFULLTEXTENABLED

0x5055

Database referenced by full-text indexing component is not enabled for full-text indexing.

SQLDMO_E_CANTDROPLOGFILE

0x5056

Reserved.

SQLDMO_E_CANTDROPLSLOGIN

0x5057

Attempt to use the Remove method of the LinkedServerLogin object or LinkedServerLogins collection that indicates a system-defined linked server login.

SQLDMO_E_SCRIPTPWD

0x5058

Attempt to use the Script method of a Login object to script a password to a non-Unicode file.

SQLDMO_E_/DISTRIBUTORNOTINSTALLED

0x5059

Reserved.

SQLDMO_E_CANTRENAMESTAT

0x505A

Attempt to set the Name property of an Index object that references an existing data distribution statistics index.

SQLDMO_E_/CANTDROPAUTOINDEX

0x505B

Attempt to use the Remove method of the Index object or Indexes collection that indicates a data distribution statistics index.

SQLDMO_E_FROMGUEST

0x505C

Reserved.

SQLDMO_E_/INVALIDPROPDISTNOTLOCAL

0x5060

Reserved.

SQLDMO_E_/CANTMODIFYNONTABLEARTTYPE

0x5064

You can change the type of an existing article only if it is a table article.

SQLDMO_E_CANTMODIFYARTTYPE

0x5065

You cannot change the type of an existing merge article.

SQLDMO_E_REGERROR

0x5066

Registry error occurred. Registry key may not exist.

SQLDMO_E_NOCOLUMNALTER

0x5067

Attempt to modify existing column not supported because data type cannot be altered after creation.

SQLDMO_E_INVALIDRESTORE

0x5068

BackupSetName property is not supported by the Restore object.

SQLDMO_E_/NONTRANSFERENCRYPTED

0x5069

You cannot transfer an encrypted stored procedure using an instance of SQL Server 2000.

SQLDMO_E_UDFSCRIPTERR

0x506A

User-defined function text cannot be retrieved.

Errors masked by SQLDMO_ECAT_INVALIDOBJECT include the following.

Constant

Value

Description

SQLDMO_E_OBJECTDROPPED

0x5100

Object invalid due to Remove method call.

SQLDMO_E_NOTSQLDMOOBJECT

0x5101

OLE object passed to a SQL-DMO method is not a SQL-DMO object.

SQLDMO_E_OBJECTDETACHED

0x5102

Object invalid due to Refresh method call or other method forcing reference release.

SQLDMO_E_SERVERCLOSED

0x5103

Object invalid due to Close method call or other method of the SQLServer object forcing application reference release.

SQLDMO_E_CANTRENAMEUDF

0x5105

You cannot rename an existing user-defined function.

SQLDMO_E_PRESQL80

0x5106

OLE object passed to a SQL-DMO method is a pre-SQL Server 2000 object.

Errors masked by SQLDMO_ECAT_INVALIDOBJECTDEFINITION include the following.

Constant

Value

Description

SQLDMO_E_NOCOLUMNSADDED

0x5200

Attempt to add a Table object with an empty Columnscollection to the Tables collection of a Database object. DoAlter method of the Table object called and Columns collection is empty.

SQLDMO_E_COLUMNINCOMPLETE

0x5201

Attempt to add an incompletely defined Column object to its containing collection. Occurs when the IsComputed property of the Column object is False.

SQLDMO_E_TABLEINCOMPLETE

0x5202

Attempt to add a Table object with an empty Name property to its containing collection.

SQLDMO_E_UDDTINCOMPLETE

0x5203

Attempt to add an incompletely defined UserDefinedDatatype object to its containing collection.

SQLDMO_E_RULEINCOMPLETE

0x5204

Attempt to add an incompletely defined Rule object to its containing collection.

SQLDMO_E_DEFAULTINCOMPLETE

0x5205

Attempt to add an incompletely defined Default object to its containing collection.

SQLDMO_E_VIEWINCOMPLETE

0x5206

Attempt to add an incompletely defined View object to its containing collection.

SQLDMO_E_USERINCOMPLETE

0x5207

Attempt to add an incompletely defined User object to its containing collection.

SQLDMO_E_GROUPINCOMPLETE

0x5208

Reserved.

SQLDMO_E_PROCINCOMPLETE

0x5209

Attempt to add an incompletely defined StoredProcedure object to its containing collection.

SQLDMO_E_USERALREADYEXISTS

0x520A

Attempt to add a User object to a Users collection that exposes a user of the same name.

SQLDMO_E_/GROUPALREADYEXISTS

0x520B

Reserved.

SQLDMO_E_/COLUMNALREADYEXISTS

0x520C

Attempt to add a Column object to a Columns collection that exposes a column of the same name.

SQLDMO_E_/OBJECTALREADYEXISTS

0x520D

Reserved.

SQLDMO_E_/INDEXALREADYEXISTS

0x520E

Reserved.

SQLDMO_E_DBALREADYEXISTS

0x520F

Reserved.

SQLDMO_E_/LOGINALREADYEXISTS

0x5210

Attempt to add a Login object to a Logins collection that exposes a login of the same name.

SQLDMO_E_/DEVICEALREADYEXISTS

0x5211

Reserved.

SQLDMO_E_SKIPONLYTAPE

0x5212

Attempt to set the SkipTapeLabel property when using the BackupDevice object to define a disk backup device.

SQLDMO_E_DEVICEINCOMPLETE

0x5213

Attempt to add an incompletely defined BackupDevice object to its containing collection.

SQLDMO_E_/PROCALREADYEXISTS

0x5214

Reserved.

SQLDMO_E_/UDDTALREADYEXISTS

0x5215

Reserved.

SQLDMO_E_/TABLEALREADYEXISTS

0x5216

Reserved.

SQLDMO_E_/RULEALREADYEXISTS

0x5217

Reserved.

SQLDMO_E_/DEFAULTALREADYEXISTS

0x5218

Reserved.

SQLDMO_E_/VIEWALREADYEXISTS

0x5219

Reserved.

SQLDMO_E_INDEXINCOMPLETE

0x521A

Attempt to add an incompletely defined Index object to its containing collection.

SQLDMO_E_TRIGINCOMPLETE

0x521B

Attempt to add an incompletely defined Trigger object to its containing collection.

SQLDMO_E_/TRIGALREADYEXISTS

0x521C

Reserved.

SQLDMO_E_/LANGUAGEINCOMPLETE

0x521D

Reserved.

SQLDMO_E_/LANGUAGEALREADYEXISTS

0x521E

Reserved.

SQLDMO_E_LOGININCOMPLETE

0x521F

Attempt to create a login based on incomplete data. Logins are created by the Add method of the Logins collection, and by methods that implement replication.

SQLDMO_E_/RSERVERINCOMPLETE

0x5220

Attempt to add an incompletely defined RemoteServer object to its containing collection.

SQLDMO_E_/RSERVERALREADYEXISTS

0x5221

Reserved.

SQLDMO_E_/NULLRLOGINALREADYEXISTS

0x5222

Attempt to add a RemoteLogin object that defines an unnamed remote login to a RemoteLogins collection that exposes an unnamed remote login.

SQLDMO_E_/RLOGINALREADYEXISTS

0x5223

Attempt to add a RemoteLogin object to a RemoteLogins collection that exposes a remote login of the same name.

SQLDMO_E_/REMOTENEEDSLOCAL

0x5224

Attempt to add an incompletely defined RemoteLogin object to its containing collection.

SQLDMO_E_/BACKUPNEEDSDEVICE

0x5225

Attempt to use the SQLBackup method of an incompletely defined Backup object. Set the Devices, Files, Tapes property to specify a device.

SQLDMO_E_/NEEDMANUALFILTERNAME

0x5226

Attempt to add an incompletely defined TransArticle object to its containing collection.

SQLDMO_E_TASKINCOMPLETE

0x5227

Reserved.

SQLDMO_E_ARTINCOMPLETE

0x5228

Attempt to add an incompletely defined DistributionArticle, MergeArticle, or TransArticle object to its containing collection.

SQLDMO_E_PUBINCOMPLETE

0x5229

Attempt to add an incompletely defined DistributionPublication, MergePublication, or TransPublication object to its containing collection.

SQLDMO_E_SUBINCOMPLETE

0x522A

Attempt to add an incompletely defined DistributionSubscription or TransSubscriptionobject to its containing collection. Attempt to add an incompletely defined RegisteredSubscriber object to register a new Subscriber.

SQLDMO_E_ALERTINCOMPLETE

0x522B

Attempt to add an incompletely defined Alert object to its containing collection.

SQLDMO_E_/OPERATORINCOMPLETE

0x522C

Attempt to add an incompletely defined Operator object to its containing collection.

SQLDMO_E_NAMEMUSTMATCH

0x522D

Name of the SQL Server object, as specified in the Text property of a StoredProcedure, Trigger, or Viewobject, does not match the value of the Name property of the SQL-DMO object. Occurs when adding an object to its containing collection and when the Alter method is called.

SQLDMO_E_TRIGREQTABLENAME

0x522E

Table name cannot be found in the Text property of a Trigger object. Occurs when adding a Trigger object to its containing collection and when the Alter method is called.

SQLDMO_E_MUSTBESYNCTASK

0x522F

Reserved.

SQLDMO_E_/NOEVENTCOMPLETION

0x5230

Reserved.

SQLDMO_E_FKEYINCOMPLETE

0x5231

Attempt to add an incompletely defined Key object to its containing collection. Occurs when the Type property is SQLDMOKey_Foreign.

SQLDMO_E_KEYINCOMPLETE

0x5232

KeyColumns is empty, or Type property is not set when using the Key object to create a primary or foreign key.

SQLDMO_E_KEYALREADYEXISTS

0x5233

Attempt to add a Key object to a Keys collection that exposes a key of the same name.

SQLDMO_E_CHECKINCOMPLETE

0x5234

Attempt to add an incompletely defined Check object to its containing collection.

SQLDMO_E_/DRIDEFAULTINCOMPLETE

0x5235

Reserved.

SQLDMO_E_/CHECKALREADYEXISTS

0x5236

Attempt to add a Check object to a Checks collection that exposes an integrity constraint of the same name.

SQLDMO_E_/ONLYONEPRIMARYKEY

0x5237

Attempt to add a Key object defining a primary key to a Keys collection exposing a primary key.

SQLDMO_E_/NEEDMANUALVIEWNAME

0x5238

TransArticle object ArticleType property includes SQLDMORep_ ManualSyncView and no view specified. Occurs when adding the TransArticle object to its containing collection.

SQLDMO_E_/SERVERGROUPINCOMPLETE

0x5239

Attempt to add an incompletely defined ServerGroup object to its containing collection.

SQLDMO_E_/REGISTEREDSERVERINCOMPLETE

0x523A

Attempt to add an incompletely defined RegisteredServer object to its containing collection.

SQLDMO_E_/SERVERGROUPALREADYEXISTS

0x523B

Attempt to add a ServerGroup object to a ServerGroups collection that exposes a server group with the same name.

SQLDMO_E_/REGISTEREDSERVERALREADYEXISTS

0x523C

Attempt to add a RegisteredServer object to a RegisteredServers collection that exposes a server with the same name.

SQLDMO_E_/NEEDLOADTABLENAME

0x523D

Reserved.

SQLDMO_E_/DISTDBALREADYEXISTS

0x523E

Attempt to add a DistributionDatabase object to a DistributionDatabases collection that exposes a database with the same name.

SQLDMO_E_/DISTPUBALREADYEXISTS

0x523F

Attempt to add a DistributionPublisher object to a DistributionPublishers collection that exposes a publisher with the same name.

SQLDMO_E_/JOBSTEPINCOMPLETE

0x5240

Attempt to add an incompletely defined JobStep object to its containing collection.

SQLDMO_E_/TARGETSERVERINCOMPLETE

0x5241

Attempt to add an incompletely defined TargetServer object to its containing collection.

SQLDMO_E_/TARGETSERVERGROUPINCOMPLETE

0x5242

Attempt to add an incompletely defined TargetServerGroup object to its containing collection.

SQLDMO_E_JOBINCOMPLETE

0x5243

Attempt to add an incompletely defined JobSchedule object to its containing collection.

SQLDMO_E_MUSTBESYNCJOB

0x5244

Reserved.

SQLDMO_E_/JOBCATEGORYINCOMPLETE

0x5245

Attempt to add an incompletely defined Category object to its containing collection.

SQLDMO_E_REGPUBINCOMPLETE

0x5246

Reserved.

SQLDMO_E_REGSUBINCOMPLETE

0x5247

Attempt to add an incompletely defined RegisteredSubscriber object to its containing collection.

SQLDMO_E_DISTPUBINCOMPLETE

0x5248

Attempt to add an incompletely defined DistributionPublisher object to its containing collection.

SQLDMO_E_DISTDBINCOMPLETE

0x5249

Attempt to add an incompletely defined DistributionDatabase object to its containing collection.

SQLDMO_E_/FILEGROUPINCOMPLETE

0x524A

Attempt to add an incompletely defined FileGroup object to its containing collection.

SQLDMO_E_DBFILEINCOMPLETE

0x524B

Attempt to add an incompletely defined DBFile object to its containing collection. File(s) not specified when using the AttachDB or AttachDBWithSingleFile method of the SQLServer object.

SQLDMO_E_/LOGFILEINCOMPLETE

0x524C

Attempt to add an incompletely defined LogFile object to its containing collection.

SQLDMO_E_/FILEGROUPALREADYEXISTS

0x524D

Attempt to add a FileGroup object to a FileGroups collection that exposes a filegroup with the same name.

SQLDMO_E_/DATABASEINCOMPLETE

0x5250

Attempt to add an incompletely defined Database object to its containing collection.

SQLDMO_E_/DATABASEROLEALREADYEXISTS

0x5251

Attempt to add a DatabaseRole object to a DatabaseRoles collection that exposes a role with the same name.

SQLDMO_E_/DATABASEROLEINCOMPLETE

0x5252

Attempt to add an incompletely defined DatabaseRole object to its containing collection. Role not specified when using the IsMember method of the User object.

SQLDMO_E_/SERVERROLEINCOMPLETE

0x5253

Role not specified when using the IsMember method of the Login object.

SQLDMO_E_/DSNINFOINCOMPLETE

0x5254

ValidateDataSource method failed.

SQLDMO_E_FILTERINCOMPLETE

0x5255

Attempt to add an incompletely defined MergeSubsetFilter object to its containing collection.

SQLDMO_E_OWNERMUSTMATCH

0x5256

Owner of the SQL Server object, as specified in the Text property of a StoredProcedure, Trigger, or View, does not match the value of the Owner property of the SQL-DMO object. Occurs when adding an object to its containing collection and when the Alter method is called.

SQLDMO_E_BACKUPNEEDSFILE

0x5257

Attempt to use the SQLBackup method of an incompletely defined Backup object or the SQLRestore or SQLVerify method of an incompletely defined Restore. Occurs when the Action property is SQLDMOBackup_Files or SQLDMORestore_Files and the Files or FileGroups property is empty.

SQLDMO_E_/BACKUPNEEDSMEDIA

0x5258

Reserved.

SQLDMO_E_/COLUMNCOMPUTEDINCOMPLETE

0x5259

Attempt to add an incompletely defined Column object to its containing collection. Occurs when the IsComputed property of the Column object is True.

SQLDMO_E_/REMAPFILEINCOMPLETE

0x525A

Reserved.

SQLDMO_E_SMALLMAXSIZE

0x525B

Attempt to add an incorrectly defined DBFile or LogFile object to its containing collection. Occurs when the Size property specifies a value greater than that specified by the MaximumSize property.

SQLDMO_E_FILEALREADYEXISTS

0x525C

Attempt to add a DBFile or LogFile object to a DBFiles or LogFilescollection that exposes a file with the same logical name.

SQLDMO_E_BADFILEGROUPNAME

0x525D

Attempt to add an incorrectly defined FileGroup object to its containing collection. Occurs when the Name property of the FileGroup object is PRIMARY.

SQLDMO_E_/LINKEDSERVERINCOMPLETE

0x525E

Attempt to add an incompletely defined LinkedServer object to its containing collection.

SQLDMO_E_/LINKEDPROVIDERINCOMPLETE

0x525F

Attempt to add an incorrectly defined LinkedServer object to its containing collection. Occurs when the ProductName property specifies a value, and the ProviderName property is empty.

SQLDMO_E_/FULLTEXTINCOMPLETE

0x5260

Attempt to add full-text indexing to a table using an incorrectly defined Table object.

SQLDMO_E_/CATALOGALREADYEXISTS

0x5261

Attempt to add a FullTextCatalog object to a FullTextCatalogs collection that exposes a full-text catalog with the same name.

SQLDMO_E_/CATALOGINCOMPLETE

0x5262

Attempt to add an incompletely defined FullTextCatalog object to its containing collection.

SQLDMO_E_BACKUPINIT

0x5263

Attempt to use the SQLBackup method of an incorrectly defined Backup object. Occurs when the FormatMedia and Initialize properties are both True.

SQLDMO_E_/LINKEDSERVERLOGININCOMPLETE

0x5264

Attempt to add an incompletely defined LinkedServerLogin object to its containing collection.

SQLDMO_E_NOSERVERBCP6

0x5265

Attempt to set Use6xCompatible True when UseServerSideBCP is True. Attempt to set UseServerSideBCP True when Use6xCompatible is True.

SQLDMO_E_/JOBSTEPNAMEINCOMPLETE

0x5266

Attempt to add an incompletely defined JobStep object to its containing collection.

SQLDMO_E_UDFINCOMPLETE

0x5268

User-defined function property settings are incomplete or incorrect.

SQLDMO_E_/FULLTEXTCOLUMNINCOMPLETE

0x5269

Full-text column property settings are incomplete or incorrect.

SQLDMO_E_/CANTADDREGSUBTOSQLDISTPUBSHR

0x5270

Attempted to add RegisteredSubscriber object to a SQL Server DistributionPublisher object instead of to a Publisher object.

SQLDMO_E_/SNAPSHOTPUBCANNOTPUBWIN

0x5271

ConflictPolicy property cannot be set to SQLDMOConflictPolicy_PublisherWin for a queued snapshot publication.

SQLDMO_E_/DYNAMICSNAPSHOTJOBINCOMPLETE

0x5272

Attempted to create MergeDynamicSnapshotJob without setting DynamicSnapshotLocation property.

Errors masked by SQLDMO_ECAT_INVALIDPARAMETER include the following.

Constant

Value

Description

SQLDMO_E_BADCOLLEN

0x5300

Attempt to add an incorrectly defined Column or UserDefinedDatatype object to its containing collection. Occurs when the Length property specifies an out of range value.

SQLDMO_E_INVALIDPERFMONSET

0x5301

Attempt to set the PerfMonMode property of the Registry object to an invalid value.

SQLDMO_E_BADDEVICETYPE

0x5302

Attempt to set the Type property of a BackupDevice object to an invalid value.

SQLDMO_E_SIZEGREATERTHAN0

0x5303

Attempt to set the Size property of a DBFile or LogFile object to a value less than zero.

SQLDMO_E_/RESULTSETOUTOFRANGE

0x5304

Attempt to set the CurrentResultSet property of a QueryResults object to an out of range value.

SQLDMO_E_/OUTPUTPARAMREQUIRED

0x5305

Attempt to get a property or call a method without providing an argument required for property or method return value.

SQLDMO_E_PROPTEXTNONNULL

0x5306

Attempt to set a property that incorrectly specifies an empty string.

SQLDMO_E_BADPROCTYPE

0x5307

Attempt to set the Type property of a StoredProcedure object to an invalid value.

SQLDMO_E_BADFILLFACTOR

0x5308

Attempt to set the FillFactor property of an Index or Key object to an out of range value. FillFactor argument out of range when RebuildIndexes method called.

SQLDMO_E_INVALIDINDEXTYPE

0x5309

Attempt to set the Type property of an Index object to an invalid value.

SQLDMO_E_INVALIDPRIVTYPE

0x530A

Deny, Grant, or Revoke method called that specifies a Privilege argument value invalid for the SQL Server object type referenced.

SQLDMO_E_BADTRIGTYPE

0x530B

Reserved.

SQLDMO_E_INVALIDDAYOFWEEK

0x530C

Attempt to get the Day property of a Language object that specifies an out of range value.

SQLDMO_E_INVALIDMONTH

0x530D

Attempt to get the Month property of a Language object that specifies an out of range value.

SQLDMO_E_BADDAYCOUNT

0x530E

Reserved.

SQLDMO_E_BADMONTHCOUNT

0x530F

Reserved.

SQLDMO_E_BADCONFIGVALUE

0x5310

Attempt to set the CurrentValue property of a ConfigValue object to an out of range value.

SQLDMO_E_INVALIDPARAMINDEX

0x5311

Attempt to get a SQL-DMO object or a string from a container object specifying an out of range value.

SQLDMO_E_/INVALIDPARAMRANGE

0x5312

Attempt to set a SQL-DMO property to an out of range value.

SQLDMO_E_INVALIDDBOBJTYPE

0x5313

ObjectType argument invalid when GetObjectByName or ListObjects method of Database object called.

SQLDMO_E_/ROWCOLOUTOFRANGE

0x5314

Row or column coordinate out of range for QueryResults object property or method.

SQLDMO_E_NONUNIQUENAME

0x5315

GetObjectByName method of the Database object would return more than a single object. Qualify SQL Server object selection by using the ObjectType and/or Owner argument.

SQLDMO_E_NOTIMESTAMPUDDT

0x5316

Attempt to set the BaseType property of a UserDefinedDatatype object to the invalid value timestamp.

SQLDMO_E_INVALIDNAME

0x5317

Name property of SQL-DMO object is not a valid SQL Server identifier. Occurs when setting the Name property of SQL-DMO objects that reference database objects.

SQLDMO_E_INVALIDCOMPLETION

0x5318

Invalid value used to set Job object completion status property (e.g. NetSendLevel).

SQLDMO_E_NAMETOOLONG

0x5319

Name property of SQL-DMO object is too long for a valid SQL Server identifier. Occurs when setting the Name property of SQL-DMO objects that reference database objects.

SQLDMO_E_INVALIDFREQTYPE

0x531A

Reserved.

SQLDMO_E_/INVALIDFREQSUBDAY

0x531B

Reserved.

SQLDMO_E_/INVALIDFREQRELINTERVAL

0x531C

Reserved.

SQLDMO_E_/BADWEEKLYINTERVAL

0x531D

Reserved.

SQLDMO_E_/BADMONTHLYINTERVAL

0x531E

Reserved.

SQLDMO_E_/BADMONTHLYRELINTERVAL

0x531F

Reserved.

SQLDMO_E_/INVALIDSRVOPTION

0x5320

Option argument invalid when SetOptions method of LinkedServer or RemoteServerobject called.

SQLDMO_E_INVALIDRUNPRIORITY

0x5321

Reserved.

SQLDMO_E_DBNAMEREQUIRED

0x5322

Required object property or method argument that specifies source or target database is empty. Occurs when adding a SQL-DMO object, such as a MergeSubscription, to a containing collection or when using a method such as SQLBackup.

SQLDMO_E_PUBNAMEREQUIRED

0x5323

Required object property or method argument that specifies source publication is empty. Occurs when adding a SQL-DMO object, such as a MergePullSubscription, to a containing collection or when using a method such as EnableTransSubscription.

SQLDMO_E_/PROPINDEXOUTOFRANGE

0x5324

Attempt to get a SQL-DMO Property object from a Properties collection that specifies an out of range value.

SQLDMO_E_INVALIDNOTIFYTYPE

0x5325

Attempt to set the IncludeEventDescription property of an Alert object to an invalid value. NotificationType argument invalid when AddNotification, EnumNotifications, or UpdateNotification method of Alert object called.

SQLDMO_E_INVALIDENUMNOTIFYTYPE

0x5326

EnumNotifyType argument invalid when EnumNotifications method of Alert object called.

SQLDMO_E_INVALIDWEEKDAY

0x5327

Attempt to set the PagerDays property of an Operator object to an invalid value.

SQLDMO_E_INVALIDOBJECTTYPE

0x5328

OLE object that supplies a method argument value is invalid. For example, object supplied in the BulkCopyargument of the ImportData method of the Table object is not a SQL-DMO BulkCopy object.

SQLDMO_E_OBJECTREQUIRED

0x5329

SQL-DMO method requiring an object called with an empty object variable.

SQLDMO_E_INVALIDEVENTTYPE

0x532A

Reserved.

SQLDMO_E_/INVALIDCOMPLETIONTYPE

0x532B

Reserved.

SQLDMO_E_INVALIDKEYTYPE

0x532C

Attempt to set the Type property of a Key object to an invalid value.

SQLDMO_E_/TABLEMUSTBECREATED

0x532D

Table object in Table argument of GenerateCreationSQL method must reference an existing table.

SQLDMO_E_INVALIDPREARTICLE

0x532E

Attempt to set the PreCreationMethod property of a MergeArticle or TransArticle object to an invalid value.

SQLDMO_E_/INVALIDSECURITYMODE

0x532F

Attempt to set the SecurityMode property of an IntegratedSecurity object to an invalid value.

SQLDMO_E_INVALIDPREC

0x5330

Attempt to set the NumericPrecision property of a Column or UserDefinedDatatype object to an out of range value.

SQLDMO_E_/INVALIDDEPENDENCYTYPE

0x5331

DependencyType argument invalid when EnumDependencies method called.

SQLDMO_E_/INVALIDVERIFYCONNTYPE

0x5332

ReconnectIfDead argument invalid when VerifyConnection method called.

SQLDMO_E_/INVALIDSTATUSINFOTYPE

0x5333

Attempt to get or set the StatusInfoRefetchInterval property of a SQLServer object that specifies an out of range value.

SQLDMO_E_/INVALIDFORWARDINGSEVERITY

0x5334

Attempt to set the ForwardingSeverity property of an AlertSystem object that specifies an invalid value.

SQLDMO_E_/INVALIDFORWARDINGSERVER

0x5335

Attempt to set the ForwardingServer property of an AlertSystem object that specifies the name of the local instance of SQL Server.

SQLDMO_E_/INVALIDRESTARTINTERVAL

0x5336

Reserved.

SQLDMO_E_/INVALIDHISTORYROWSMAX

0x5337

Reserved.

SQLDMO_E_NAMETOOSHORT

0x5338

Reserved.

SQLDMO_E_UNEXPECTED

0x5339

Severe error. Error not trapped by normal SQL-DMO error handling.

SQLDMO_E_/INVALIDHISTORYROWSPERTASKMAX

0x533A

Reserved.

SQLDMO_E_/INVALIDOBJSORTTYPE

0x533B

SortBy argument invalid when ListObjects method called.

SQLDMO_E_INVALIDEXECTYPE

0x533C

ExecutionType argument invalid when ExecuteImmediate method called.

SQLDMO_E_/INVALIDSUBSETFILTER

0x533D

Reserved.

SQLDMO_E_/INCOMPATIBLEPROPS

0x533E

BulkCopy object properties that specify data file format set incorrectly. For example, the DataFileType property is SQLDMODataFile_UseFormatFile, and the FormatFilePath property is empty.

SQLDMO_E_FILEPATHREQUIRED

0x533F

SQL-DMO object property that specifies a file name required and not filled. For example, the DataFilePath property of a BulkCopy object is empty when the object is used in an ExportData or ImportData method call.

SQLDMO_E_INVALIDPROPALTER

0x5340

SQL-DMO object property cannot be changed when owning object is in a BeginAlter...DoAlter block.

SQLDMO_E_/INVALIDALTERDISTINSTALLED

0x5341

Attempt to set the DistributionServer property of a Distributor object that references an installed Distributor.

SQLDMO_E_/SERVERNAMEREQUIRED

0x5342

Required property that specifies a replication source or target server is empty.

SQLDMO_E_/DISTSERVERNAMEREQUIRED

0x5343

Install or Uninstall method of a Distributor object called and DistributionServer property is empty.

SQLDMO_E_/WORKINGDIRREQUIRED

0x5344

Attempt to add an incorrectly defined DistributionPublisher object to its containing collection. Occurs when the DistributorLocal property of the containing Distributor object is True, and the DistributionWorkingDirectory property of the DistributionPublisher object is empty.

SQLDMO_E_DISTDBREQUIRED

0x5345

Install method of a Distributor object called, and the DistributionDatabases collection is empty.

SQLDMO_E_/INVALIDHISTORYROWSPERJOBMAX

0x5348

Reserved.

SQLDMO_E_INVALIDPUBATTRIB

0x5349

Attempt to set the PublicationAttributes property of a SQL-DMO replication publication object that specifies an invalid value for the publication object type.

SQLDMO_E_/INVALIDREPLICATIONTYPE

0x534A

ReplicationType argument invalid when EnumPublications method called.

SQLDMO_E_/INVALIDSCHEMAOPTION

0x534B

Attempt to set the CreationScriptOptions property of a TransArticle object incorrectly. Occurs when ArticleType property is SQLDMORep_ProcExecution or SQLDMORep_SerializableProcExecution, and CreationScriptOptions is not SQLDMOCreationScript_PrimaryObject or SQLDMOCreationScript_DisableScripting.

SQLDMO_E_/INVALIDFORREMDISTRIBUTOR

0x534C

Reserved.

SQLDMO_E_/INVALIDARTICLETYPE

0x534D

Attempt to use the AddReplicatedColumns or RemoveReplicatedColumns method of a TransArticle that references a transactional article that replicates stored procedure execution. Attempt to set the ArticleType property of a MergeArticle to SQLDMORep_ProcExecution or SQLDMORep_SerializableProcExecution.

SQLDMO_E_/SIZEGREATERTHANNEG

0x534E

Attempt to set the FileGrowth property of a DBFile or LogFile object incorrectly. Prior to referenced file creation, the property accepts -1 to specify default value. When object references an existing file, -1 is not allowed.

SQLDMO_E_INVALIDLOGINTYPE

0x534F

Attempt to set the Type property of a Login object to an invalid value.

SQLDMO_E_/CANTMODIFYAFTERCREATE

0x5350

Property cannot be set for SQL-DMO object that references an existing SQL Server component.

SQLDMO_E_INVALIDDSN

0x5351

ValidateDataSource method failed.

SQLDMO_E_INVALIDNAME70

0x5352

Reserved.

SQLDMO_E_MUSTEVEN

0x5353

Attempt to set the RelocateFiles property of a Restore object incorrectly.

SQLDMO_E_MISSINGALTER

0x5354

Transact-SQL batch supplied in the str argument of the Alter method of a StoredProcedure, Trigger, or View object does not begin with the keyword ALTER.

SQLDMO_E_NOTGUID

0x5355

GetColumnGUID method called that indicates data not selected from a uniqueidentifier type column.

SQLDMO_E_/DESTSERVERREQUIRED

0x5356

DestServer property is required when using the Transfer object in the Transfer method of the Database object.

SQLDMO_E_CANTSHRINK

0x5357

Attempt to set the Size property of a DBFile or LogFile object incorrectly. When the SQL-DMO object references an existing file, set Size to a larger value to grow the file. Use the Shrink method to reduce operating system file size.

SQLDMO_E_CANTDEFAULTOFF

0x5358

Attempt to set the Default property of a FileGroup object incorrectly. Default may be set True only.

SQLDMO_E_INVALIDNTNAME

0x5359

SQL-DMO property that specifies an operating system file is empty or contains invalid characters.

SQLDMO_E_/INVALIDOUTCOMETYPE

0x535A

Attempt to set the OutcomeTypes property of a JobHistoryFilter object incorrectly.

SQLDMO_E_/NEEDSCOLUMNNAME

0x535B

Reserved.

SQLDMO_E_/INVALIDHYPOINDEXTYPE

0x535C

Attempt to set the Type property of an Index object to an invalid value (SQLDMOIndex_Hypothetical).

SQLDMO_E_INVALIDPING

0x535D

PingSQLServerVersion method failed.

SQLDMO_E_/USEFTPORALTFOLDER

0x535E

AltSnapshotFolder and UseFTP properties cannot be specified at the same time.

SQLDMO_E_/INTERNETENABLEDORALTFOLDER

0x535F

AltSnapshotFolder property and InternetEnabled publication attribute cannot be specified at the same time.

SQLDMO_E_NOTSQLVARIANT

0x5361

Referenced column in call to GetColumnSQLVariant is not of type SQLVariant.

SQLDMO_E_/CANTCONVERTVARIANT

0x5362

Referenced column in call to GetColumnSQLVariantToString cannot be converted.

SQLDMO_E_/USEFTPORDYNAMICSNAPSHOT

0x5363

DynamicSnapshotLocation and UseFTP properties cannot be set at the same time.

SQLDMO_E_/ALTSNAPSHOTFOLDERORDYNSNAP

0x5364

DynamicSnapshotLocation and AltSnapshotFolder properties cannot be set at the same time.

Errors masked by SQLDMO_ECAT_INVALIDPLATFORM include the following.

Constant

Value

Description

SQLDMO_E_BACKUPSQL60ONLY

0x5400

Reserved.

SQLDMO_E_MSSQLONLY

0x5401

Reserved.

SQLDMO_E_SQL60ONLY

0x5404

Reserved.

SQLDMO_E_REPLSQL60ONLY

0x5405

Reserved.

SQLDMO_E_/STARTUPPROCSQL60ONLY

0x5406

Reserved.

SQLDMO_E_/NEEDSQLDMOPROCS

0x5407

SQL-DMO supporting system stored procedures are not installed.

SQLDMO_E_ALTERSQL60ONLY

0x5408

Reserved.

SQLDMO_E_/SORTEDDATAREORGSQL60ONLY

0x5409

Reserved.

SQLDMO_E_MSSQLNTONLY

0x540A

Reserved.

SQLDMO_E_BACKUPSQL65ONLY

0x540C

Reserved.

SQLDMO_E_SQL65ONLY

0x540D

Reserved.

SQLDMO_E_ALERTSQL65ONLY

0x540E

Reserved.

SQLDMO_E_REMOTESQL65ONLY

0x540F

Reserved.

SQLDMO_E_PIPEDEVSQL60ONLY

0x5410

Reserved.

SQLDMO_E_FKEYSQL65ONLY

0x5411

Reserved.

SQLDMO_E_/XPIMPERSONATESQL65ONLY

0x5412

Reserved.

SQLDMO_E_SQL70ONLY

0x5413

Reserved.

SQLDMO_E_FKEYSQL70ONLY

0x5414

Reserved.

SQLDMO_E_BACKUPSQL70ONLY

0x5415

Reserved.

SQLDMO_E_/NEEDSQLDMOUPGRADE

0x5416

Returned on an attempt to connect a SQL-DMO SQLServer object to an instance of SQL Server released prior to version 7.0.

SQLDMO_E_/NEEDSERVERBUILDUPGRADE

0x5417

Reserved.

SQLDMO_E_SQL80ONLY

0x5419

Requires SQL Server 2000 or later.

Errors masked by SQLDMO_ECAT_ITEMNOTFOUND include the following. Errors in this category indicate that an attempt to dereference, by name, an object from its containing collection failed. Using the Refresh method of the collection can correct the error condition.

Constant

Value

Description

SQLDMO_E_RULENOTFOUND

0x5500

Rule object not locatable in the Rules collection.

SQLDMO_E_DEFAULTNOTFOUND

0x5501

Default object not locatable in the Defaults collection.

SQLDMO_E_TYPENOTFOUND

0x5502

UserDefinedDatatype object not locatable in the UserDefinedDatatypes collection. SystemDatatype object not locatable in the SystemDatatypes collection.

SQLDMO_E_LOGINNOTFOUND

0x5503

Login object not locatable in the Logins collection.

SQLDMO_E_GROUPNOTFOUND

0x5504

Reserved.

SQLDMO_E_LANGNOTFOUND

0x5505

Language object not locatable in the Languages collection.

SQLDMO_E_DBNOTFOUND

0x5506

Database object not locatable in the Databases collection.

SQLDMO_E_DEVICENOTFOUND

0x5507

BackupDevice object not locatable in the BackupDevices collection.

SQLDMO_E_COLUMNNOTFOUND

0x5508

Column object not locatable in the Columns collection of a Table object or the SQLObjectList object returned by the ListColumns method of the View object.

SQLDMO_E_ORDOUTOFRANGE

0x5509

Ordinal value used to dereference an item in a collection or object list is out of range.

SQLDMO_E_NAMENOTFOUND

0x550A

Object not locatable by name.

SQLDMO_E_USERNOTFOUND

0x550B

User object not locatable in the Users collection.

SQLDMO_E_NAMENOTINCACHE

0x550C

Returned when an attempt to call the DoAlter method fails because the object no longer exists in its containing collection.

SQLDMO_E_/PROPNAMENOTFOUND

0x550D

Property object not locatable in the Properties collection.

SQLDMO_E_IDNOTFOUND

0x550E

Returned when the ItemByID method fails to locate an object.

SQLDMO_E_/DATABASEROLENOTFOUND

0x550F

DatabaseRole object not locatable in the DatabaseRoles collection.

SQLDMO_E_NAMENOTFOUNDQI

0x5510

Returned when an object is not locatable by name and quoting identifier parts is applicable.

SQLDMO_E_SERVERNOTFOUND

0x5512

Server not locatable by name.

Errors masked by SQLDMO_ECAT_UNPRIVILEGEDLOGIN include the following.

Constant

Value

Description

SQLDMO_E_MUSTBESAORDBO

0x5600

Login used for SQLServer object connection must be a member of the sysadmin or db_owner role to enable successful execution of property get or set or method call.

SQLDMO_E_MUSTBESAORLOGIN

0x5601

Login used for SQLServer object connection must be a member of the sysadmin role or the login referenced by the Login object, to successfully set a Login object property.

SQLDMO_E_MUSTBESA

0x5602

Login used for SQLServer object connection must be a member of the sysadmin role to enable successful execution of property get or set or method call.

SQLDMO_E_/MUSTBESAORSECORLOGIN

0x5603

Login used for SQLServer object connection must be a member of the sysadmin or securityadmin role, or the login referenced by the Login object, to enable successful execution of property get or set or method call.

Errors masked by SQLDMO_ECAT_EXECUTION include the following.

Constant

Value

Description

SQLDMO_E_SYSPROCERROR

0x5700

Reserved.

SQLDMO_E_CACHEEXECERROR

0x5701

QueryResults object row fetch failed.

SQLDMO_E_INACCESSIBLEDB

0x5702

Database referenced by object or method is not accessible (offline, loading, and so on).

SQLDMO_E_/BATCHCOMPLETEWITHERRORS

0x5703

Command batch execution completed, errors raised.

SQLDMO_E_BCPCOLFMTFAILED

0x5704

Bulk copy column formatting failed. Returned by the ExportData or ImportData method when data file format interpretation fails.

SQLDMO_E_SUSPENDINDEX

0x5705

Attempt to suspend indexing prior to bulk copy operation failed. Returned by the ImportData method.

SQLDMO_E_RESUMEINDEX

0x5706

Attempt to resume indexing suspended prior to bulk copy operation failed. Returned by the ImportData method.

SQLDMO_E_BCPEXECFAILED

0x5707

Bulk copy operation failed. Returned by the ExportData or ImportData method.

SQLDMO_E_BCPINITFAILED

0x5708

Bulk copy operation initialization failed. Returned by the ExportData or ImportData method.

SQLDMO_E_BCPCONTROLFAILED

0x5709

Bulk copy operation parameter setting failed. Returned by the ExportData or ImportData method.

SQLDMO_E_USERABORTED

0x570A

Returned by the SQLBackup, SQLRestore, SQLVerify, ImportData, ExportData, or Transfer method when the Abort method is called to terminate object processing.

SQLDMO_E_QIERROR

0x570B

Attempt to set the QuotedIdentifier property of the SQLServer object failed.

SQLDMO_E_REGIONALERROR

0x570C

Attempt to set the RegionalSetting property of the SQLServer object failed.

SQLDMO_E_SINGLEUSERDB

0x570D

Database referenced by object or method is in single-user mode.

SQLDMO_E_/CANNOTCREATEARTICLEVIEW

0x570E

Attempt to create the synchronization object for an article to be filtered vertically or horizontally failed.

SQLDMO_E_/CANNOTCREATEARTICLEFILTER

0x570F

Attempt to filter data to be published failed.

Errors masked by SQLDMO_ECAT_CONNECTION include the following.

Constant

Value

Description

SQLDMO_E_CANTRECONNDEADCONN

0x5800

Attempt to reestablish automatically a SQLServer object connection failed.

Errors masked by SQLDMO_ECAT_RESOURCE include the following.

Constant

Value

Description

SQLDMO_E_OUTOFMEMORY

0x5900

Insufficient memory on the client.

SQLDMO_E_NOMOREDEVNOS

0x5901

Reserved.

SQLDMO_E_SERVERLOCKTIMEDOUT

0x5902

Attempt to obtain a lock on a server resource failed.

SQLDMO_E_APPLOCKTIMEDOUT

0x5903

Attempt to obtain a lock on a local resource failed.