SQL-DMO errors are categorized, roughly 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 Handling SQL-DMO Errors 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 | DistributionDatabase property 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 EnumFixedDatabaseRole Permission 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 master to 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 Column object that references a column in a table not full-text indexed. |
| SQLDMO_E_ACTIVATEFULLTEXT | 0x5054 | Attempt to set the FullTextIndex property of a Column object 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 Columns collection 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 or named pipe 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, or Pipes 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 TransSubscription object 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 View object, 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 LogFiles collection 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 RemoteServer object 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 BulkCopy argument 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_WIN95REQUIRESCONN | 0x5402 | Returned by SQL-DMO methods that start, stop, or pause a service. When a SQL-DMO client runs on Microsoft Windows® 95, service control methods operate successfully against services running on the local computer or a computer running Microsoft Windows NT®, only. |
| SQLDMO_E_NOTONWIN95 | 0x5403 | Returned by SQL-DMO methods, such as EnumNTDomainGroups, that cannot successfully execute on Windows 95. |
| 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_WIN95REQUIRESSQL60 | 0x540B | 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 creates 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. |