SQLOLE_ERROR_TYPE

Values

SQLOLE_E_DBLIBFIRSTERROR
SQLOLE_E_DBLIBLASTERROR
SQLOLE_E_FIRSTERROR
SQLOLE_ECAT_MASK
SQLOLE_ECAT_
INVALIDCONTEXT
SQLOLE_E_ALREADYCONN This server object is already connected.
SQLOLE_E_ALREADYCOLL This object is already in a collection.
SQLOLE_E_NOTCONN This server object is not connected.
SQLOLE_E_CANTDROPSERVER You cannot drop a server. Use Server.Close when the object is no longer needed.
SQLOLE_E_NOCOMPLEXALTER Modifying or removing existing table columns, or inserting new ones prior to end of table, is not supported.
SQLOLE_E_PROPNEEDSCREATE This property or method is not available until the object (or its parent if appropriate) has been added to a collection.
SQLOLE_E_COLTYPEFIXED Column type '%s' is fixed length; no length may be specified.
SQLOLE_E_COLTYPENONNULL Column type '%s' may not be specified to allow NULL values.
SQLOLE_E_CANTCHANGEUDDT Cannot change the base type, length, or nullability of an existing User-defined datatype.
SQLOLE_E_BASETYPEFIXED Base datatype '%s' is fixed length; no length may be specified.
SQLOLE_E_BASETYPENONNULL Base datatype '%s' may not be specified to allow NULL values.
SQLOLE_E_ENUMORDINAL This is an enumeration-only list object and must be indexed by ordinal.
SQLOLE_E_CANTRENAMEUSER Existing User's User name and Login name cannot be changed.
SQLOLE_E_
CANTRENAMEGROUP
Existing Group name cannot be changed.
SQLOLE_E_
CANTRENAMELOGIN
Existing Login's name cannot be changed.
SQLOLE_E_
CANTRENAMEDEVICE
Existing Device's name, type, size, physical location, or label skipping cannot be changed.
SQLOLE_E_NOTDUMPPROP This property or method cannot be used with a dump device.
SQLOLE_E_NOSERVERASSOC No server has been associated with this object.
SQLOLE_E_NOTCOLLTYPE This object type does not match the collection's type. It cannot be added.
SQLOLE_E_
CANTMODIFYDRIINDEX
This index was generated by a DRI 'PRIMARY KEY' or 'UNIQUE KEY' CONSTRAINT and cannot be modified or dropped.
SQLOLE_E_
CANTCHANGEPROCTYPE
Existing StoredProcedure type cannot be changed.
SQLOLE_E_
CANTMODIFYINDEX
This property or method cannot be set or invoked after the index has been created.
SQLOLE_E_INVALIDPRIVOBJ This object type cannot have granted privileges.
SQLOLE_E_
CANTCHANGETRIGTYPE
Existing trigger type cannot be changed.
SQLOLE_E_NOVIEWCOLALTER Columns of a view cannot be modified. The base corresponding base table's column must be used.
SQLOLE_E_
CANTRENAMELANGUAGE
Existing language's name, months, short months, days, dateformat, and first day of week cannot be changed.
SQLOLE_E_
CANTRENAMERSERVER
Existing Remote Server's name cannot be changed.
SQLOLE_E_
CANTRENAMERLOGIN
Existing Remote Login's local name and remote name cannot be changed.
SQLOLE_E_MUSTBEDBDEV This method or property can only be used with a database device.
SQLOLE_E_
NOINACTIVEMIRROR
This device has no inactive mirror.
SQLOLE_E_NOACTIVEMIRROR This device has no active mirror.
SQLOLE_E_NOMIRROR This device has no active or inactive mirror.
SQLOLE_E_
SERVERDISCONNECTED
This server has been DisConnected. You must ReConnect to perform this operation.
SQLOLE_E_
CANTRENAMESERVER
You cannot change the name, login, password, login timeout, login security, or network packet size for a server object while it is connected.
SQLOLE_E_CANTMODIFYTEXT Modifying the text of an existing Rule, Default, Stored Procedure, View, or Trigger is not allowed. You must drop and recreate the object.
SQLOLE_E_
CANTMODIFYSYSTABLE
System tables cannot be altered, dropped, or otherwise modified.
SQLOLE_E_
LOGINALREADYALIASED
The Login '%s' is already aliased to user '%s' in this database.
SQLOLE_E_
LOGINALREADYUSER
The Login '%s' is already assigned to user '%s' in this database.
SQLOLE_E_CACHENORESULTS This cache contains no result sets, or the current result set contains no rows.
SQLOLE_E_ALREADYCREATED This object has already been created.
SQLOLE_E_NOTDISCONN This server is already Connected.
SQLOLE_E_
CANTMODIFYARTTABLE
You cannot change the Source Table of an existing Article.
SQLOLE_E_
CANTMODIFYSUBSERVER
You cannot change the Subscribing Server of an existing Subscription.
SQLOLE_E_
BASETYPENOTNUMERIC
Base datatype '%s' is not a numeric type; no precision or scale may be specified.
SQLOLE_E_
TOFILEBUTNOFILENAME
ScriptMode specified as ToFileOnly, but no filename specified -- recheck parameters.
SQLOLE_E_
MUSTBEDISTSERVER
The distribution server is either undefined or not the current server, so the Distribution Working Directory cannot be set.
SQLOLE_E_CANTMODIFYKEY You cannot modify an existing Key's Clustered, FillFactor, or ReferencedTable properties.
SQLOLE_E_LISTCANTREFRESH This object list cannot be refreshed; you must Release it and re-invoke the method which returned it.
SQLOLE_E_NOCOLTABLE This column object is not associated with a table.
SQLOLE_E_MUSTBEINALTER Modifying this property can only be done when the table is in Alter mode (BeginAlter has been called).
SQLOLE_E_
CANTUNDEDICATELOGDEVICE
Cannot undedicate a dedicated log device in this version of SQL Server.
SQLOLE_ECAT_
INVALIDOBJECT
SQLOLE_E_OBJECTDROPPED This object has been dropped from the server.
SQLOLE_E_NOTSQLOLEOBJECT The passed object is not a SQLOLE object.
SQLOLE_E_OBJECTDETACHED This object has been detached from SQLOLE, as the result of a refresh, automatic shutdown, error, or App.Quit.
SQLOLE_E_SERVERCLOSED This server object has been Closed. It can no longer be used.
SQLOLE_ECAT_
INVALIDOBJECTDEFINITION
SQLOLE_E_
NOCOLUMNSADDED
No new columns or constraints have been added to this table object
SQLOLE_E_
COLUMNINCOMPLETE
Column definition must include name, datatype, length if appropriate to datatype, and null specification if adding to an existing table.
SQLOLE_E_TABLEINCOMPLETE Table name not specified.
SQLOLE_E_UDDTINCOMPLETE Datatype definition must include name, base datatype, and length if appropriate to base datatype.
SQLOLE_E_RULEINCOMPLETE Rule definition must include name and text of rule.
SQLOLE_E_
DEFAULTINCOMPLETE
Default definition must include name and text of default.
SQLOLE_E_VIEWINCOMPLETE View definition must include name and text of view.
SQLOLE_E_USERINCOMPLETE User's Login name not specified.
SQLOLE_E_GROUPINCOMPLETE Group name not specified.
SQLOLE_E_PROCINCOMPLETE Stored procedure definition must include name and text (for Standard StoredProcedure) or libraryname (for Extended StoredProcedure).
SQLOLE_E_
USERALREADYEXISTS
User '%s' already exists.
SQLOLE_E_
GROUPALREADYEXISTS
Group '%s' already exists.
SQLOLE_E_
COLUMNALREADYEXISTS
Column '%s' already exists.
SQLOLE_E_
OBJECTALREADYEXISTS
User '%s' already owns an object named '%s' in this database.
SQLOLE_E_
INDEXALREADYEXISTS
Index '%s' on table '%s' already exists.
SQLOLE_E_DBALREADYEXISTS Database '%s' already exists.
SQLOLE_E_
LOGINALREADYEXISTS
Login '%s' already exists.
SQLOLE_E_
DEVICEALREADYEXISTS
Device '%s' already exists.
SQLOLE_E_SKIPONLYTAPE Skip option is only valid for tape dump devices.
SQLOLE_E_
DEVICEINCOMPLETE
Device definition must include logical name, physical name, device type, and size if defining a database device.
SQLOLE_E_
PROCALREADYEXISTS
StoredProcedure '%s' already exists.
SQLOLE_E_
UDDTALREADYEXISTS
UserDefinedDatatype '%s' already exists.
SQLOLE_E_
TABLEALREADYEXISTS
Table '%s' already exists.
SQLOLE_E_
RULEALREADYEXISTS
Rule '%s' already exists.
SQLOLE_E_
DEFAULTALREADYEXISTS
Default '%s' already exists.
SQLOLE_E_
VIEWALREADYEXISTS
View '%s' already exists.
SQLOLE_E_INDEXINCOMPLETE Index definition must include a name and at least one column to index.
SQLOLE_E_TRIGINCOMPLETE Trigger definition must include name and text.
SQLOLE_E_
TRIGALREADYEXISTS
Trigger '%s' on table '%s' already exists.
SQLOLE_E_
LANGUAGEINCOMPLETE
Language definition must include name, months, shortmonths, and days.
SQLOLE_E_
LANGUAGEALREADYEXISTS
Language '%s' already exists.
SQLOLE_E_LOGININCOMPLETE Login name not specified.
SQLOLE_E_
RSERVERINCOMPLETE
Remote Server name not specified.
SQLOLE_E_
RSERVERALREADYEXISTS
Remote Server '%s' already exists.
SQLOLE_E_
NULLRLOGINALREADYEXISTS
A NULL Remote Login already exists for this Remote Server.
SQLOLE_E_
RLOGINALREADYEXISTS
A Remote Login with the remote name '%s' already exists for this Remote Server.
SQLOLE_E_
REMOTENEEDSLOCAL
A Remote Login's Remote Name cannot be specified without also specifying a Local Name.
SQLOLE_E_
BACKUPNEEDSDEVICE
You must specify a backup device for Dump or Load.
SQLOLE_E_
NEEDMANUALFILTERNAME
Specifying the ManualSyncView ReplicationType requires supplying the name of an existing (manually-created) view.
SQLOLE_E_TASKINCOMPLETE You must specify a task name.
SQLOLE_E_ARTINCOMPLETE Article definition must include Article name and the name of the Table being published.
SQLOLE_E_PUBINCOMPLETE Publication definition must include Publication name.
SQLOLE_E_SUBINCOMPLETE Subscription definition must include the subscribing Remote Server's name.
SQLOLE_E_ALERTINCOMPLETE Alert definition must include name.
SQLOLE_E_
OPERATORINCOMPLETE
Operator definition must include name.
SQLOLE_E_NAMEMUSTMATCH The name specified in the Text property's 'CREATE ...' statement must match the Name property, and must be followed by valid TSQL statements.
SQLOLE_E_
TRIGREQTABLENAME
You must specify the Parent Table's name in the Text property's 'CREATE...' statement.
SQLOLE_E_MUSTBESYNCTASK Tasks created as a Publication's InitialSyncTask must have a 'SYNC' SubSystem.
SQLOLE_E_
NOEVENTCOMPLETION
Either of the EventTypes or CompletionTypes properties may be set, but not both.
SQLOLE_E_FKEYINCOMPLETE Foreign Key definition must include a referenced Table name and list of columns in the referenced Table which matches the number of columns in the Key Table.
SQLOLE_E_KEYINCOMPLETE DRI Key definition must include key type and a list of columns in the key.
SQLOLE_E_
KEYALREADYEXISTS
A Key with this name already exists on this table.
SQLOLE_E_CHECKINCOMPLETE DRI Check definition must include text of the data validation.
SQLOLE_E_
DRIDEFAULTINCOMPLETE
DRI Default definition must include text of the data value, which may be '' (a blank string) for NULL.
SQLOLE_E_
CHECKALREADYEXISTS
A Check with this name already exists on this table.
SQLOLE_E_
ONLYONEPRIMARYKEY
There is already a primary key in this table's key collection.
SQLOLE_E_
NEEDMANUALVIEWNAME
Specifying the ManualFilterProc ReplicationType requires supplying the name of an existing (manually-created) stored procedure.
SQLOLE_ECAT_
INVALIDPARAMETER
SQLOLE_E_
BADCOLLEN
Column length must be between 1 and 255 (0 is allowed for non-length datatypes).
SQLOLE_E_
INVALIDPERFMONSET
The PerfMonMode must be either Continuous or OnDemand.
SQLOLE_E_BADDEVICETYPE Invalid device type.
SQLOLE_E_
SIZEGREATERTHAN0
Size must be greater than 0.
SQLOLE_E_
RESULTSETOUTOFRANGE
Specified result set is outside the range of result sets returned by this query.
SQLOLE_E_
OUTPUTPARAMREQUIRED
You must specify an output parameter.
SQLOLE_E_PROPTEXTNONNULL The text for this property cannot be blank or NULL.
SQLOLE_E_BADPROCTYPE Invalid StoredProcedure type.
SQLOLE_E_BADFILLFACTOR Fill factor must be between 0 (use default) and 100.
SQLOLE_E_INVALIDINDEXTYPE Invalid index-type option.
SQLOLE_E_INVALIDPRIVTYPE Invalid privilege-type option for this object.
SQLOLE_E_BADTRIGTYPE Invalid trigger-type option.
SQLOLE_E_
INVALIDDAYOFWEEK
Day of week index must be between 1 and 7.
SQLOLE_E_INVALIDMONTH Month index must be between 1 and 12.
SQLOLE_E_BADDAYCOUNT You must enter exactly 7 day names.
SQLOLE_E_BADMONTHCOUNT You must enter exactly 12 month names.
SQLOLE_E_BADCONFIGVALUE New values for configuration option '%s' must be between %ld and %ld.
SQLOLE_E_
INVALIDPARAMINDEX
Invalid index parameter type; must be string or numeric ordinal, or an object; check documentation for this function.
SQLOLE_E_
INVALIDPARAMRANGE
Invalid parameter or parameter value out of range.
SQLOLE_E_INVALIDDBOBJTYPE Invalid database-object type.
SQLOLE_E_
ROWCOLOUTOFRANGE
Row or column specified is outside the range of the specified query result set.
SQLOLE_E_NONUNIQUENAME The object name '%s' is not unique.
SQLOLE_E_
NOTIMESTAMPUDDT
User-defined datatypes based on the 'timestamp' datatype are not allowed.
SQLOLE_E_INVALIDNAME The name '%s' is not a valid object identifier, or is not a valid format for this property or method.
SQLOLE_E_
INVALIDCOMPLETION
Assigned CompletionLevel must be Failure or Success.
SQLOLE_E_NAMETOOLONG Maximum string length for this property or method is %ld.
SQLOLE_E_INVALIDFREQTYPE FrequencyType must be Daily, Weekly, or Monthly.
SQLOLE_E_
INVALIDFREQSUBDAY
FrequencySubDay must be Hour, Minute, or Second.
SQLOLE_E_
INVALIDFREQRELINTERVAL
FrequencyRelativeInterval must be First, Second, Third, Fourth, or Last.
SQLOLE_E_
BADWEEKLYINTERVAL
Weekly Interval must be one or more WeekDay values; consult your documentation.
SQLOLE_E_
BADMONTHLYINTERVAL
Monthly Relative Interval must be a single MonthDay value; consult your documentation.
SQLOLE_E_
BADMONTHLYRELINTERVAL
Monthly Relative Interval must be a single First thru Fourth, or Last; consult your documentation.
SQLOLE_E_INVALIDSRVOPTION Invalid Remote Server option.
SQLOLE_E_
INVALIDRUNPRIORITY
Invalid Run Priority.
SQLOLE_E_DBNAMEREQUIRED Database name required.
SQLOLE_E_
PUBNAMEREQUIRED
Publication name required.
SQLOLE_E_
PROPINDEXOUTOFRANGE
Specified index is out of the range of properties for this object.
SQLOLE_E_
INVALIDNOTIFYTYPE
Property must be a valid SQLOLE_NOTIFY_TYPE.
SQLOLE_E_
INVALIDENUMNOTIFYTYPE
Property must be a valid SQLOLE_ENUMNOTIFY_TYPE.
SQLOLE_E_INVALIDWEEKDAY Weekday parameter must be a bitmask of SQLOLE_WEEKDAY_TYPE (1, 2, 4, 8, 16, 32, 64).
SQLOLE_E_
INVALIDOBJECTTYPE
The input object's type is invalid for this method.
SQLOLE_E_OBJECTREQUIRED An input object must be specified.
SQLOLE_E_INVALIDEVENTTYPE Invalid event type; must be a valid (non-Unknown) value in SQLOLE_EVENT_TYPE.
SQLOLE_E_
INVALIDCOMPLETIONTYPE
Invalid completion type; must be a valid (non-Unknown) value in SQLOLE_COMPLETION_TYPE.
SQLOLE_E_INVALIDKEYTYPE Invalid key type.
SQLOLE_E_
TABLEMUSTBECREATED
This property or method requires that the table object already be created on the server.
SQLOLE_E_
INVALIDPREARTICLE
Invalid article pre-creation method.
SQLOLE_E_
INVALIDSECURITYMODE
Invalid Security mode.
SQLOLE_E_INVALIDPREC Numeric precision must be greater than 0 and less than or equal to the maximum precision (%ld) specified for this server.
SQLOLE_E_
INVALIDDEPENDENCYTYPE
DependencyType must be a valid value from SQLOLE_DEPENDENCY_TYPE.
SQLOLE_E_
INVALIDVERIFYCONNTYPE
VerifyType must be a valid value from SQLOLE_VERIFYCONN_TYPE.
SQLOLE_E_
INVALIDSTATUSINFOTYPE
The StatusInfoType must be a non-Unknown member of the SQLOLE_STATUSINFO_TYPE enumeration.
SQLOLE_E_
INVALIDFORWARDINGSEVERITY
The ForwardingSeverity must be between 1 and 25, or 110, 120, 130, or 140.
SQLOLE_E_
INVALIDFORWARDINGSERVER
The ForwardingServer cannot be the current server.
SQLOLE_E_
INVALIDRESTARTINTERVAL
The RestartSQLServerInterval must be between 1 and 60 minutes.
SQLOLE_E_
INVALIDHISTORYROWSMAX
The LimitHistoryRowsMax must be greater than 1.
SQLOLE_E_NAMETOOSHORT Minimum string length for this property or method is %ld.
SQLOLE_E_UNEXPECTED Unexpected parameter value or other condition.
SQLOLE_ECAT_
INVALIDPLATFORM
SQLOLE_E_BACKUPSQL60ONLY Backup options other than UnloadTapeAfter, DumpInitDeviceBefore, LoadFileNumber, and single backup devices require Microsoft SQL Server Version 6.0 or later.
SQLOLE_E_MSSQLONLY This method or property is only available for Microsoft SQL Servers.
SQLOLE_E_WIN95REQUIRESCONN This method is not available to unconnected servers unless on Windows NT clients.
SQLOLE_E_NOTONWIN95 This method is only available on Windows NT clients.
SQLOLE_E_SQL60ONLY This property or method requires Microsoft SQL Server Version 6.0 or later.
SQLOLE_E_REPLSQL60ONLY Replication and Scheduling Management requires Microsoft SQL Server Version 6.0 or later.
SQLOLE_E_
STARTUPPROCSQL60ONLY
Specifying startup procedures requires Microsoft SQL Server Version 6.0 or later.
SQLOLE_E_NEEDSQLOLEPROCS This server has not installed version %ld.%ld or later of the Microsoft SQL-DMO (SQLOLE) stored procedures for its SQL Server version. The connection is denied.
SQLOLE_E_ALTERSQL60ONLY Changing this property after object creation requires Microsoft SQL Server Version 6.0 or later.
SQLOLE_E_
SORTEDDATAREORGSQL60ONLY
Specifying SQLOLEIndex_SortedDataReorg requires Microsoft SQL Server Version 6.0 or later.
SQLOLE_E_MSSQLNTONLY This version of the Microsoft SQL Distributed Managment Objects requires a Microsoft Windows NT SQL Server version 4.21 or later.
SQLOLE_E_
WIN95REQUIRESSQL60
This method or property is not available on a pre-6.0 version of Microsoft SQL Server when SQL-DMO is running on Windows 95.
SQLOLE_ECAT_
ITEMNOTFOUND
SQLOLE_E_RULENOTFOUND Rule '%s' not found.
SQLOLE_E_DEFAULTNOTFOUND Default '%s' not found.
SQLOLE_E_TYPENOTFOUND Data type '%s' not found.
SQLOLE_E_LOGINNOTFOUND Login '%s' not found.
SQLOLE_E_GROUPNOTFOUND Group '%s' not found.
SQLOLE_E_LANGNOTFOUND Language '%s' not found.
SQLOLE_E_DBNOTFOUND Database '%s' not found.
SQLOLE_E_DEVICENOTFOUND Device '%s' not found.
SQLOLE_E_COLUMNNOTFOUND Column '%s' not found in table '%s'.
SQLOLE_E_ORDOUTOFRANGE The passed ordinal is out of range of the specified collection.
SQLOLE_E_NAMENOTFOUND The name '%s' was not found in the specified collection.
SQLOLE_E_USERNOTFOUND User '%s' not found.
SQLOLE_E_NAMENOTINCACHE Internal error: Name not found in cache.
SQLOLE_E_
PROPNAMENOTFOUND
Specified name is not a property of this object.
SQLOLE_E_IDNOTFOUND The ID '%ld' was not found in the specified collection.
SQLOLE_ECAT_
UNPRIVILEGEDLOGIN
SQLOLE_E_MUSTBESAORDBO Only the System Administrator or Database Owner can perform this operation.
SQLOLE_E_MUSTBESAORLOGIN You must be logged in as 'sa' or this object's login to perform this operation.
SQLOLE_E_MUSTBESA You must be logged in as 'sa' to perform this operation.
SQLOLE_ECAT_EXECUTION
SQLOLE_E_SYSPROCERROR SQL Server message text.
SQLOLE_E_CACHEEXECERROR Error encountered on executing or updating associated query.
SQLOLE_E_INACCESSIBLEDB This database has been marked Inaccessible.
SQLOLE_E_
BATCHCOMPLETEWITHERRORS
SQL Server message text.
SQLOLE_ECAT_CONNECTION
SQLOLE_E_CANTRECONNDEADCONN This server connection has been unexpectedly broken and cannot be reconnected.
SQLOLE_ECAT_RESOURCE
SQLOLE_E_OUTOFMEMORY Out of memory.
SQLOLE_E_NOMOREDEVNOS The maximum of 256 devices already exists on this server.
SQLOLE_E_LASTERROR