Export (0) Print
Expand All

Chapter 12 - System Error Messages

The master.sysmessages table contains one row for each system error or warning that can be returned by SQL Server. These are the columns in the sysmessages table.

Column name

Data type

Description

error

int

Unique error number

severity

smallint

Severity level of the error

dlevel

smallint

Reserved. For internal use only

description

nvarchar(255)

Explanation of the error with placeholders for parameters

mslangid

smallint

System message group ID

These variables appear in the error message text provided with the system error message descriptions.

Symbol

Meaning

%d, %ld, or %D

Decimal integer

%x

Hexadecimal number

%ls or %.*ls

Character string

%S_type

SQL Server -defined structure

%c

Single character

%lf

Double floating-point number

Errors 1 - 999

Error

Severity

Description

1

10

Version date of last upgrade: 10/11/90.

21

10

Warning: Fatal error %d occurred at %S_DATE. Note the error and time, and contact your system administrator.

102

15

Incorrect syntax near '%.*ls'.

103

15

The %S_MSG that starts with '%.*ls' is too long. Maximum length is %d.

104

15

ORDER BY items must appear in the select list if the statement contains a UNION operator.

105

15

Unclosed quotation mark before the character string '%.*ls'.

106

16

Too many table names in the query. The maximum allowable is %d.

107

15

The column prefix '%.*ls' does not match with a table name or alias name used in the query.

108

15

The ORDER BY position number %ld is out of range of the number of items in the select list.

109

15

There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.

110

15

There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.

111

15

'%ls' must be the first statement in a query batch.

112

15

Variables are not allowed in the %ls statement.

113

15

Missing end comment mark '*/'.

114

15

Browse mode is invalid for a statement that assigns values to a variable.

116

15

Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

117

15

The %S_MSG name '%.*ls' contains more than the maximum number of prefixes. The maximum is %d.

118

15

Only members of the sysadmin role can specify the %ls option for the %ls statement.

119

15

Must pass parameter number %d and subsequent parameters as '@name = value'. After the form '@name = value' has been used, all subsequent parameters must be passed in the form '@name = value'.

120

15

The select list for the INSERT statement contains fewer items than the insert list. The number of SELECT values must match the number of INSERT columns.

121

15

The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns.

123

15

Batch/procedure exceeds maximum length of %d characters.

124

15

CREATE PROCEDURE contains no statements.

125

15

Case expressions may only be nested to level %d.

128

15

The name '%.*ls' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.

129

15

Fillfactor %d is not a valid percentage; fillfactor must be between 1 and 100.

130

16

Cannot perform an aggregate function on an expression containing an aggregate or a subquery.

131

15

The size (%d) given to the %S_MSG '%.*ls' exceeds the maximum. The largest size allowed is %d.

132

15

The label '%.*ls' has already been declared. Label names must be unique within a query batch or stored procedure.

133

15

A GOTO statement references the label '%.*ls' but the label has not been declared.

134

15

The variable name '%.*ls' has already been declared. Variable names must be unique within a query batch or stored procedure.

135

15

Cannot use a BREAK statement outside the scope of a WHILE statement.

136

15

Cannot use a CONTINUE statement outside the scope of a WHILE statement.

137

15

Must declare the variable '%.*ls'.

138

15

Correlation clause in a subquery not permitted.

139

15

Cannot assign a default value to a local variable.

140

15

Can only use IF UPDATE within a CREATE TRIGGER statement.

141

15

A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.

142

15

Incorrect syntax for definition of the '%ls' constraint.

143

15

A COMPUTE BY item was not found in the order by list. All expressions in the compute by list must also be present in the order by list.

144

15

Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.

145

15

ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

146

15

Could not allocate ancillary table for a subquery. Maximum number of tables in a query (%d) exceeded.

147

15

An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.

148

15

Incorrect time syntax in time string '%.*ls' used with WAITFOR.

149

15

Time value '%.*ls' used with WAITFOR is not a valid value. Check date/time syntax.

150

15

Both terms of an outer join must contain columns.

151

15

'%.*ls' is an invalid money value.

153

15

Invalid usage of the option %.*ls in the %ls statement.

154

15

%S_MSG is not allowed in %S_MSG.

155

15

'%.*ls' is not a recognized %ls option.

156

15

Incorrect syntax near the keyword '%.*ls'.

157

15

An aggregate may not appear in the set list of an UPDATE statement.

159

15

For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname.

160

15

Rule does not contain a variable.

161

15

Rule contains more than one variable.

163

15

The compute by list does not match the order by list.

164

15

GROUP BY expressions must refer to column names that appear in the select list.

165

16

Privilege %ls may not be granted or revoked.

166

15

'%ls' does not allow specifying the database name as a prefix to the object name.

167

16

Cannot create a trigger on a temporary object.

168

15

The %S_MSG '%.*ls' is out of the range of computer representation (%d bytes).

169

15

A column has been specified more than once in the order by list. Columns in the order by list must be unique.

170

15

Line %d: Incorrect syntax near '%.*ls'.

171

15

Cannot use SELECT INTO in browse mode.

172

15

Cannot use HOLDLOCK in browse mode.

173

15

The definition for column '%.*ls' must include a data type.

174

15

The %ls function requires %d arguments.

177

15

The IDENTITY function can only be used when the SELECT statement has an INTO clause.

178

15

A RETURN statement with a return status can only be used in a stored procedure.

179

15

Cannot use the OUTPUT option when passing a constant to a stored procedure.

180

15

There are too many parameters in this %ls statement. The maximum number is %d.

181

15

Cannot use the OUTPUT option in a DECLARE statement.

182

15

Table and column names must be supplied for the READTEXT or WRITETEXT utility.

183

15

The scale (%d) for column '%.*ls' must be within the range %d to %d.

185

15

Data stream is invalid for WRITETEXT statement in bulk form.

186

15

Data stream missing from WRITETEXT statement.

188

15

Cannot specify a log device in a CREATE DATABASE statement without also specifying at least one non-log device.

189

15

The %ls function requires %d to %d arguments.

190

15

Cannot update the function '%.*ls'.

191

15

Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.

192

16

The scale must be less than or equal to the precision.

193

15

The object or column name starting with '%.*ls' is too long. The maximum length is %d characters.

194

15

A SELECT INTO statement cannot contain a SELECT statement that assigns values to a variable.

195

15

'%.*ls' is not a recognized %S_MSG.

196

15

SELECT INTO must be the first query in a SQL statement containing a UNION operator.

198

15

Browse mode is invalid for statements containing a UNION operator.

199

15

An INSERT statement cannot contain a SELECT statement that assigns values to a variable.

201

16

Procedure '%.*ls' expects parameter '%.*ls', which was not supplied.

203

16

The name '%.*ls' is not a valid identifier.

204

20

Normalization error in node %ls.

205

16

All queries in a SQL statement containing a UNION operator must have an equal number of expressions in their target lists.

206

16

Operand type clash: %ls is incompatible with %ls

207

16

Invalid column name '%.*ls'.

208

16

Invalid object name '%.*ls'.

209

16

Ambiguous column name '%.*ls'.

210

16

Syntax error converting datetime from binary/varbinary string.

212

16

Expression result length exceeds the maximum. %d max, %d found.

213

16

Insert Error: Column name or number of supplied values does not match table definition.

214

16

Cannot convert parameter '%ls' to %ls data type expected by procedure.

217

16

Maximum stored procedure nesting level exceeded (limit %d).

220

16

Arithmetic overflow error for data type %ls, value = %ld.

221

10

FIPS Warning: Implicit conversion from %ls to %ls.

223

11

Object ID %ld specified as a default for table ID %ld, column ID %d is missing or not of type default.

224

11

Object ID %ld specified as a rule for table ID %ld, column ID %d is missing or not of type default.

226

16

%ls statement not allowed within multi-statement transaction.

229

14

%ls permission denied on object '%.*ls', database '%.*ls', owner '%.*ls'.

230

14

%ls permission denied on column '%.*ls' of object '%.*ls', database '%.*ls', owner '%.*ls'.

231

11

No such default. ID = %ld, database ID = %d.

232

16

Arithmetic overflow error for type %ls, value = %f.

233

16

The column '%.*ls' in table '%.*ls' cannot be null.

234

16

There is insufficient result space to convert a money value to %ls.

235

16

Cannot convert a char value to money. The char value has incorrect syntax.

236

16

The conversion from char data type to money resulted in a money overflow error.

237

16

There is insufficient result space to convert a money value to %ls.

238

16

There is insufficient result space to convert the %ls value (= %d) to the money data type.

241

16

Syntax error converting datetime from character string.

242

16

The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

243

16

Type %.*ls is not a defined system type.

244

16

The conversion of the %ls value '%.*ls' overflowed an %hs column. Use a larger integer column.

245

16

Syntax error converting the %ls value '%.*ls' to a column of data type %ls.

248

16

The conversion of the %ls value '%.*ls' overflowed an int column. Maximum integer value exceeded.

251

16

Could not allocate ancillary table for query optimization. Maximum number of tables in a query (%d) exceeded.

252

16

Cannot group by a bit column.

256

16

The data type %ls is invalid for the %ls function. Allowed types are: char/varchar, nchar/nvarchar, and binary/varbinary.

257

16

Implicit conversion from data type %ls to %ls is not allowed. Use the CONVERT function to run this query.

259

16

Ad hoc updates to system catalogs are not enabled. The system administrator must reconfigure SQL Server to allow this.

260

16

Disallowed implicit conversion from data type %ls to data type %ls, table '%ls', column '%ls'. Use the CONVERT function to run this query.

261

16

'%.*ls' is not a recognized function.

262

16

%ls permission denied, database '%.*ls', owner '%.*ls'.

263

16

Must specify table to select from.

264

16

Column name '%.*ls' appears more than once in the result column list.

266

16

Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = %ld, current count = %ld.

267

16

Object '%.*ls' cannot be found.

268

16

Cannot run SELECT INTO in this database. The database owner must run sp_dboption to enable this option.

270

16

Table '%.*ls' cannot be modified.

271

16

Column '%.*ls' cannot be modified because it is a computed column.

272

16

Cannot update a timestamp column.

273

16

Cannot insert a non-null value into a timestamp column. Use INSERT with a column list or with a default of NULL for the timestamp column.

278

16

The text, ntext, and image data types cannot be used in a GROUP BY clause.

279

16

The text, ntext, and image data types are invalid in this subquery or aggregate expression.

280

16

Only text, ntext, and image data types are valid with the TEXTPTR function.

281

16

%d is not a valid style number when converting from datetime to a character string.

282

10

The '%.*ls' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.

284

16

Rules cannot be bound to text, ntext, or image data types.

285

16

The READTEXT and WRITETEXT statements cannot be used with views.

286

16

The logical tables INSERTED and DELETED cannot be updated.

287

16

The %ls statement is not allowed within a trigger.

288

16

The PATINDEX function operates on char, nchar, varchar, nvarchar, text, and ntext data types only.

292

16

There is insufficient result space to convert a smallmoney value to %ls.

293

16

Cannot convert char value to smallmoney. The char value has incorrect syntax.

294

16

The conversion from char data type to smallmoney data type resulted in a smallmoney overflow error.

295

16

Syntax error converting character string to smalldatetime data type.

296

16

The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.

298

16

The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error.

299

16

The DATEADD function was called with bad type %ls.

301

16

Query contains an outer-join request that is not permitted.

303

16

The table '%.*ls' is an inner member of an outer-join clause. This is not allowed if the table also participates in a regular join clause.

306

16

The text, ntext, and image data types cannot be used in the WHERE, HAVING, or ON clause, except with the LIKE or IS NULL predicates.

307

16

Index ID %d on table '%.*ls' (specified in the FROM clause) does not exist.

308

16

Index '%.*ls' on table '%.*ls' (specified in the FROM clause) does not exist.

310

16

Invalid escape sequence. Valid characters after ESC are: an ESC pair, underscore, percent sign.

311

16

Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables.

312

16

Cannot reference text, ntext, or image columns in a filter stored procedure.

401

16

Unimplemented statement or expression %ls.

403

16

Invalid operator for data type. Operator equals %ls, type equals %ls.

409

16

The %ls operation cannot take a %ls data type as an argument.

410

20

COMPUTE clause #%d 'BY' expression #%d is not in the order by list.

411

20

COMPUTE clause #%d, aggregate expression #%d is not in the select list.

420

16

The text, ntext, and image data types cannot be used in an ORDER BY clause.

425

16

Data type %ls of receiving variable is not equal to the data type %ls of column '%.*ls'.

426

16

The length %d of the receiving variable is less than the length %d of the column '%.*ls'.

427

20

Could not load sysprocedures entries for constraint ID %d in database ID %d.

428

20

Could not find row in sysconstraints for constraint ID %d in database ID %d.

429

20

Could not find new constraint ID %d in sysconstraints, database ID %d, at compile time.

430

20

Could not resolve table name for object ID %d, database ID %d, when compiling foreign key.

431

19

Could not bind foreign key constraint. Too many tables involved in the query.

433

20

Could not find CHECK constraint for '%.*ls', although the table is flagged as having one.

436

20

Could not open referenced table ID %d in database ID %d.

437

20

Could not resolve the referenced column name in table ID %d.

438

20

Could not resolve the referencing column name in table ID %d.

439

20

Could not find FOREIGN KEY constraints for table '%.*ls' in database ID %d although the table is flagged as having them.

441

16

Cannot use the '%ls' function on a remote data source.

505

16

Current user account was invoked with SETUSER. Changing databases is not allowed.

506

16

Invalid ESCAPE character '%.*hs' has been specified in a LIKE predicate.

507

16

Invalid argument %d specified for SET ROWCOUNT.

509

11

User name '%.*ls' not found.

510

16

Cannot create a work table row larger than allowable maximum. Resubmit your query with the ROBUST PLAN hint.

511

16

Cannot create a row of size %d which is greater than the allowable maximum of %d.

512

16

Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

513

16

A column insert or update conflicts with a rule imposed by a previous CREATE RULE statement. The statement was terminated. The conflict occurred in database '%.*ls', table '%.*ls', column '%.*ls'.

515

16

Cannot insert the value NULL into column '%.*ls', table '%.*ls'; column does not allow nulls. %ls fails.

516

18

Could not get system date/time.

517

16

Adding a value to a '%ls' column caused overflow.

518

16

Cannot convert data type %ls to %ls.

528

20

System error detected during attempt to use the 'upsleep' system function.

529

16

Explicit conversion from data type %ls to %ls is not allowed.

532

16

The timestamp (changed to %S_TS) shows that the row has been updated by another user.

535

16

Difference of two datetime columns caused overflow at runtime.

536

16

Invalid length parameter passed to the substring function.

538

16

Cannot find '%.*ls'. This language may have been dropped. Contact your system administrator.

542

16

An invalid datetime value was encountered. Value exceeds the year 9999.

544

16

Cannot insert explicit value for identity column in table '%.*ls' when IDENTITY_INSERT is set to OFF.

545

16

Explicit value must be specified for identity column in table '%.*ls' when IDENTITY_INSERT is set to ON.

547

16

%ls statement conflicted with %ls %ls constraint '%.*ls'. The conflict occurred in database '%.*ls', table '%.*ls'%ls%.*ls%ls.

548

16

Cannot perform direct %ls to range maintained by replication. The conflict occurred in database '%.*ls', table '%.*ls'%ls%.*ls%ls.

550

16

The attempted insert or update failed because the target view either specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK OPTION and one or more rows resulting from the operation did not qualify under the CHECK OPTION constraint.

551

16

The checksum has changed to %d. This shows that the row has been updated by another user.

553

16

%hs over nullable side of outer join query on table '%ls'.

555

16

User-defined functions are not yet enabled.

556

16

INSERT EXEC failed because the stored procedure altered the schema of the target table.

601

12

Could not continue scan with NOLOCK due to data movement.

602

21

Could not find row in sysindexes for database ID %d, object ID %ld, index ID %d. Run DBCC CHECKTABLE on sysindexes.

604

21

Could not find row in sysobjects for object ID %ld in database '%.*ls'. Run DBCC CHECKTABLE on sysobjects.

605

21

Attempt to fetch logical page %S_PGID in database '%.*ls' belongs to object '%.*ls', not to object '%.*ls'.

607

21

Insufficient room was allocated for search arguments in the session descriptor for object '%.*ls'. Only %d search arguments were anticipated.

615

21

Could not find database table ID %d, name '%.*ls'.

617

20

Descriptor for object ID %ld in database ID %d not found in the hash table during attempt to unhash it.

618

21

A varno of %d was passed to the opentable system function. The largest valid value is %d.

623

21

Could not retrieve row from page by RID because logical page %S_PGID is not a data page. %S_RID. %S_PAGE.

624

21

Could not retrieve row from page by RID because the requested RID has a higher number than the last RID on the page. %S_RID.%S_PAGE, DBID %d.

625

21

Could not retrieve row from logical page %S_PGID by RID because the entry in the offset table (%d) for that RID (%d) is less than or equal to 0.

626

16

Cannot use ROLLBACK with a savepoint within a distributed transaction.

627

16

Cannot use SAVE TRANSACTION within a distributed transaction.

628

13

Cannot issue SAVE TRANSACTION when there is no active transaction.

635

20

Process %d tried to remove DES resource lock %S_DES, which it does not hold.

637

20

Index shrink program returned invalid status of 0.

639

21

Could not fetch logical page %S_PGID, database ID %d. The page is not currently allocated.

644

21

Could not find the index entry for RID '%.*hs' in index page %S_PGID, index ID %d, database '%.*ls'.

649

21

Could not find the clustered index entry for page %S_PGID, object ID %ld, status 0x%x. Index page %S_PGID, in database '%.*ls', was searched for this entry.

650

16

You can only specify the READPAST lock in the READ COMMITTED or REPEATABLE READ isolation levels.

651

16

Cannot use %hs granularity hint on table '%.*ls' because locking at the specified granularity is inhibited.

652

16

Index ID %d for table '%.*ls' resides on a read-only filegroup which cannot be modified.

653

20

Two buffers are conflicting for the same keep slot in table '%.*ls'.

654

20

No slots are free to keep buffers for table '%.*ls'.

655

20

Expected to find buffer in keep slot for table '%.*ls'.

666

16

Maximum system-generated unique value for a duplicate group exceeded for table ID %d, index ID %d. Dropping and re-creating the index may fix the problem; otherwise use another clustering key.

701

19

There is insufficient system memory to run this query.

708

10

Warning: Due to low virtual memory, special reserved memory used %d times since startup. Increase virtual memory on server.

802

17

No more buffers can be stolen.

804

20

Could not find buffer 0x%lx holding logical page %S_PGID in the SDES 0x%lx kept buffer pool for object '%.*ls'.

809

20

Buffer 0x%lx, allocation page %S_PGID, in database '%.*ls' is not in allocation buffer pool in PSS (process status structure). Contact Technical Support.

813

20

Logical page %S_PGID in database ID %d is already hashed.

816

20

Process ID %d tried to remove a buffer resource lock %S_BUF that it does not hold in SDES %S_SDES. Contact Technical Support.

818

19

There is no room to hold the buffer resource lock %S_BUF in SDES %S_SDES. Contact Technical Support.

821

20

Could not unhash buffer at 0x%lx with a buffer page number of %S_PGID and database ID %d with HASHED status set. The buffer was not found. %S_PAGE.

822

21

Could not start I/O for request %S_BLKIOPTR.

823

24

I/O error %ls detected during %S_MSG of %S_BUF.

834

21

The bufclean system function was called on dirty buffer (page %S_PGID, stat %#x/%#x, objid %#x, sstat%#x).

840

17

Device '%.*ls' (physical name '%.*ls', virtual device number %d) is not available. Contact the system administrator for assistance.

844

10

Time out occurred while waiting for buffer latch type %d, bp %#x, page %S_PGID, stat %#x, object ID %d:%d:%d, waittime %d. Continuing to wait.

845

17

Time out occurred while waiting for buffer latch type %d for page %S_PGID, database ID %d, object ID %d, index ID %d.

901

21

Could not find descriptor for database ID %d, object ID %ld in hash table after hashing it.

903

22

Could not find row in sysindexes for clustered index on system catalog %ld in database ID %d. This index should exist in all databases. Run DBCC CHECKTABLE on sysindexes in the database.

906

22

Could not locate row in sysobjects for system catalog '%.*ls' in database '%.*ls'. This system catalog should exist in all databases. Run DBCC CHECKTABLE on sysobjects in this database.

911

16

Could not locate entry in sysdatabases for database '%.*ls'. No entry found with that name. Make sure that the name is entered correctly.

913

22

Could not find database ID %d. Database may not be activated yet or may be in transition.

916

14

Server user '%.*ls' is not a valid user in database '%.*ls'.

921

14

Database '%.*ls' has not been recovered yet. Wait and try again.

922

14

Database '%.*ls' is being recovered. Waiting until recovery is finished.

923

14

User %d not allowed in database '%.*ls'. Only the owner can access this database.

924

14

Database '%.*ls' is already open and can only have one user at a time.

925

19

Maximum number of databases used for each query has been exceeded. The maximum allowed is %d.

926

14

Database '%.*ls' cannot be opened. It has been marked SUSPECT by recovery. See the SQL Server errorlog for more information.

927

14

Database '%.*ls' cannot be opened. It is in the middle of a restore.

929

20

Attempting to close a database that is not already open. Contact Technical Support.

941

14

Cannot open database '%.*ls'. It has not been upgraded to the latest format.

942

14

Database '%.*ls' cannot be opened because it is offline.

943

14

Database '%.*ls' cannot be opened because its version (%d) is later than the current server version (%d).

944

10

Converting database '%.*ls' from version %d to the current version %d.

945

16

Database '%.*ls' cannot be opened because some of the files could not be activated.

946

14

Cannot open database '%.*ls' version %d. Upgrade the database to the latest version.

947

16

Error while closing database '%.*ls' cleanly.

Errors 1000 - 1999

Error

Severity

Description

1001 

16

Line %d: Length or precision specification %d is invalid.

1002

16

Line %d: Specified scale %d is invalid.

1003 

15

Line %d: %ls clause allowed only for %ls.

1005 

15

Line %d: Invalid procedure number (%d). Must be between 1 and 32767.

1006 

15

CREATE TRIGGER contains no statements.

1007 

15

The %S_MSG '%.*ls' is out of the range for numeric representation (maximum precision %d).

1008 

15

The SELECT item identified by the ORDER BY number %d contains a variable as part of the expression identifying a column position. Variables are only allowed when ordering by an expression referencing a column name.

1010 

15

Invalid escape character '%.*ls'.

1011 

15

The correlation name '%.*ls' is specified multiple times in a FROM clause.

1012 

15

The correlation name '%.*ls' has the same exposed name as table '%.*ls'.

1013 

15

Tables '%.*ls' and '%.*ls' have the same exposed names. Use correlation names to distinguish them.

1015 

15

An aggregate cannot appear in an ON clause unless it is in a subquery contained in a HAVING clause or select list, and the column being aggregated is an outer reference.

1016 

15

Outer join operators cannot be specified in a query containing joined tables.

1019 

15

Invalid column list after object name in GRANT/REVOKE statement.

1020 

15

Cannot specify column list for INSERT/DELETE/EXECUTE privileges in the GRANT/REVOKE statement.

1021 

10

FIPS Warning: Line %d has the non-ANSI statement '%ls'.

1022 

10

FIPS Warning: Line %d has the non-ANSI clause '%ls'.

1023 

15

Invalid parameter %d specified for %ls.

1024 

10

FIPS Warning: Line %d has the non-ANSI function '%ls'.

1025 

10

FIPS Warning: The length of identifier '%.*ls' exceeds 18.

1027 

15

Too many expressions are specified in the GROUP BY clause. The maximum number is %d when either CUBE or ROLLUP is specified.

1028 

15

The CUBE and ROLLUP options are not allowed in a GROUP BY ALL clause.

1029 

15

Browse mode is invalid for subqueries and derived tables.

1031 

15

Percent values must be between 0 and 100.

1032 

16

Cannot use the column prefix '%.*ls'. This must match the object in the UPDATE clause '%.*ls'.

1033 

16

An ORDER BY clause is invalid in views, derived tables, and subqueries unless TOP is also specified.

1035 

15

Incorrect syntax near '%.*ls', expected '%.*ls'.

1036 

15

File option %hs is required in this CREATE/ALTER DATABASE statement.

1037 

15

The CASCADE, WITH GRANT or AS options cannot be specified with statement permissions.

1038 

15

Cannot use empty object or column names. Use a single space if necessary.

1039 

15

SHOWPLAN is not available. Use SHOWPLAN_TEXT or SHOWPLAN_ALL instead.

1040 

15

Mixing old and new syntax in CREATE/ALTER DATABASE statement is not allowed.

1041 

15

Option %.*ls is not allowed for a LOG file.

1042 

15

Conflicting %ls optimizer hints specified.

1043 

15

'%hs' is not yet implemented.

1044 

15

Cannot use an existing function name to specify a stored procedure name.

1045 

15

Aggregates are not allowed in this context. Only scalar expressions are allowed.

1046 

15

Subqueries are not allowed in this context. Only scalar expressions are allowed.

1047 

15

Conflicting locking hints specified.

1048 

15

Conflicting cursor options %ls and %ls.

1049 

15

Mixing old and new syntax to specify cursor options is not allowed.

1050 

15

This syntax is only allowed within the stored procedure sp_executesql.

1051 

15

Cursor parameters in a stored procedure must be declared with OUTPUT and VARYING options, and they must be specified in the order CURSOR VARYING OUTPUT.

1052 

15

Conflicting %ls options %ls and %ls.

1053 

15

For DROP STATISTICS, you must give both the table and the column name in the form 'tablename.column'.

1055 

15

'%.*ls' is an invalid name because it contains a NULL character.

1056 

15

The maximum number of elements in the select list is %d and you have supplied %d.

1057 

15

The IDENTITY function cannot be used with a SELECT INTO statement containing a UNION operator.

1058 

15

Cannot specify both READ_ONLY and FOR READ ONLY on a cursor declaration.

1059 

15

Cannot set or reset the %ls option within a procedure.

1060 

15

The number of rows in the TOP clause must be an integer.

1061 

16

The text/ntext/image constants are not yet implemented.

1062 

16

The TOP N WITH TIES clause is not allowed without a corresponding ORDER BY clause.

1063 

16

A filegroup cannot be added using ALTER DATABASE ADD FILE. Use ALTER DATABASE ADD FILEGROUP.

1064 

16

A filegroup cannot be used with log files.

1065 

15

The NOLOCK, READUNCOMMITTED, and READPAST lock hints are only allowed in a SELECT statement.

1066 

10

Warning. Line %d: The option '%ls' is obsolete and has no effect.

1067 

15

The SET SHOWPLAN statements must be the only statements in the batch.

1068 

16

Only one list of index hints per table is allowed.

1069 

16

Index hints are only allowed in a FROM clause.

1070 

15

CREATE INDEX option '%.*ls' is no longer supported.

1071 

16

Cannot specify a JOIN algorithm with a remote JOIN.

1072 

16

A REMOTE hint can only be specified with an INNER JOIN clause.

1073 

15

'%.*ls' is not a recognized cursor option for cursor %.*ls.

1101 

17

Could not allocate new page for database '%.*ls'. There are no more pages available in filegroup %.*ls. Space can be created by dropping objects, adding additional files, or allowing file growth.

1102 

22

IAM page %S_PGID for object ID %ld is incorrect. The %S_MSG ID on page is %ld; should be %ld. The entry in sysindexes may be incorrect or the IAM page may be corrupt.

1103 

21

Allocation page %S_PGID in database '%.*ls' has different segment ID than that of the object which is being allocated to. Run DBCC CHECKALLOC.

1105

17

Could not allocate space for object '%.*ls' in database '%.*ls' because the '%.*ls' filegroup is full.

1109 

21

Could not read allocation page %S_PGID because either the object ID (%ld) is not correct, or the page ID (%S_PGID) is not correct.

1201 

20

The page_lock system function was called with a mode %d that is not permitted.

1203

20

Process ID %d attempting to unlock unowned resource %.*ls.

1204

19

SQL Server has run out of LOCKS. Rerun your statement when there are fewer active users, or ask the system administrator to reconfigure SQL Server with more LOCKS.

1205

13

Your transaction (process ID #%d) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction.

1211 

13

Process ID %d was chosen as the deadlock victim with P_BACKOUT bit set.

1220 

17

No more lock classes available from transaction.

1221 

20

Invalid lock class for release call.

1222 

13

Lock request time out period exceeded.

1501 

20

Sort failure.

1505

14

CREATE UNIQUE INDEX terminated because a duplicate key was found. Most significant primary key is '%S_KEY'.

1507 

10

Warning: Deleted duplicate row. Primary key is '%S_KEY'.

1508

14

CREATE INDEX terminated because a duplicate row was found. Primary key is '%S_KEY'.

1509 

20

Row compare failure.

1510

17

Sort failed. Out of space or locks in database '%.*ls'.

1511 

20

Sort cannot be reconciled with transaction log.

1522 

20

Sort failure. Prevented overwriting of allocation page in database '%.*ls' by terminating sort.

1523 

20

Sort failure. Prevented incorrect extent deallocation by aborting sort.

1528 

21

Character data comparison failure. An unrecognized Sort-Map-Element type (%d) was found in the server-wide default sort table at SMEL entry [%d].

1529 

21

Character data comparison failure. A list of Sort-Map-Elements from the server-wide default sort table does not end properly. This list begins at SMEL entry [%d].

1530

16

CREATE INDEX with DROP_EXISTING was aborted because a row was out of order. Most significant offending primary key is '%S_KEY'. Explicitly drop and create the index instead.

1531 

16

The SORTED_DATA_REORG option cannot be used for a nonclustered index if the keys are not unique within the table. CREATE INDEX was aborted because of duplicate keys. Primary key is '%S_KEY'.

1532 

20

New sort run starting on page %S_PGID found extent not marked as shared.

1533 

20

Cannot share extent %S_PGID among more than eight sort runs.

1534 

20

Extent %S_PGID not found in shared extent directory.

1535 

20

Cannot share extent %S_PGID with shared extent directory full.

1536 

20

Cannot build a nonclustered index on a memory-only work table.

1537 

20

Cannot suspend a sort not in row input phase.

1538 

20

Cannot insert into a sort not in row input phase.

1540 

16

Cannot sort a row of size %d, which is greater than the allowable maximum of %d.

1619 

21

Could not open tempdb. Cannot continue.

1701 

16

Creation of table '%.*ls' failed because the row size would be %d, including internal overhead. This exceeds the maximum allowable table row size, %d.

1702

16

CREATE TABLE failed because column '%.*ls' in table '%.*ls' exceeds the maximum of %d columns.

1703 

17

Could not allocate disk space for a work table in database '%.*ls'. You may be able to free up space by using BACKUP LOG, or you may want to extend the size of the database by using ALTER DATABASE.

1704 

16

Only members of the sysadmin role can create the system table '%.*ls'.

1705 

16

You must create system table '%.*ls' in the master database.

1706 

16

System table '%.*ls' was not created, because ad hoc updates to system catalogs are not enabled.

1708 

10

The total row size (%d) for table '%.*ls' exceeds the maximum number of bytes per row (%d). Rows that exceed the maximum number of bytes will not be added.

1709 

16

Cannot use TEXTIMAGE_ON when a table has no text, ntext, or image columns.

1750 

10

Could not create constraint. See previous errors.

1752 

16

Could not create DEFAULT for column '%.*ls' as it is not a valid column in the table '%.*ls'.

1753 

16

Column '%.*ls.%.*ls' is not the same length as referencing column '%.*ls.%.*ls' in foreign key '%.*ls'.

1754 

16

Defaults cannot be created on columns with an IDENTITY attribute. Table '%.*ls', column '%.*ls'.

1755 

16

Defaults cannot be created on columns of data type timestamp. Table '%.*ls', column '%.*ls'.

1756 

10

Skipping FOREIGN KEY constraint '%.*ls' definition for temporary table.

1759 

16

Invalid column '%.*ls' specified in constraint definition.

1760 

16

Constraints of type %ls cannot be created on columns of type %ls.

1763 

16

Cross-database foreign key references are not supported. Foreign key '%.*ls'.

1766 

16

Foreign key references to temporary tables are not supported. Foreign key '%.*ls'.

1767 

16

Foreign key '%.*ls' references invalid table '%.*ls'.

1768 

16

Foreign key '%.*ls' references object '%.*ls' which is not a user table.

1769 

16

Foreign key '%.*ls' references invalid column '%.*ls' in referencing table '%.*ls'.

1770 

16

Foreign key '%.*ls' references invalid column '%.*ls' in referenced table '%.*ls'.

1772 

16

Foreign key '%.*ls' defines an invalid relationship between a user table and system table.

1773 

16

Foreign key '%.*ls' has implicit reference to object '%.*ls' which does not have a primary key defined on it.

1774 

16

The number of columns in the referencing column list for foreign key '%.*ls' does not match those of the primary key in the referenced table '%.*ls'.

1776 

16

There are no primary or candidate keys in the referenced table '%.*ls' that match the referencing column list in the foreign key '%.*ls'.

1777 

14

User does not have correct permissions on referenced table '%.*ls' to create foreign key '%.*ls'.

1778 

16

Column '%.*ls.%.*ls' is not the same data type as referencing column '%.*ls.%.*ls' in foreign key '%.*ls'.

1779 

16

Table '%.*ls' already has a primary key defined on it.

1780 

20

Could not find column ID %d in syscolumns for object ID %d in database ID %d.

1781 

16

Column already has a DEFAULT bound to it.

1801 

16

Database '%.*ls' already exists.

1802 

11

CREATE DATABASE failed. Some file names listed could not be created. Check previous errors.

1803

17

CREATE DATABASE failed. Could not allocate enough disk space for a new database on the named disks. Total space allocated must be at least %d MB to a accommodate copy of the model database.

1804 

10

There is no disk named '%.*ls'. Checking other disk names.

1805 

10

The CREATE DATABASE process is allocating %.2f MB on disk '%.*ls'.

1807 

17

Could not obtain exclusive lock on database '%.*ls'. Retry the operation later.

1808 

21

Default devices are not supported.

1811 

16

'%.*ls' is the wrong type of device for CREATE DATABASE or ALTER DATABASE. Check sysdevices. The statement is aborted.

1813 

16

Could not open new database '%.*ls'. CREATE DATABASE is aborted.

1814

10

Could not create tempdb. If space is low, extend the amount of space and restart.

1816 

16

Could not attach the database because the character set, sort order, or Unicode collation for the database differs from this server.

1817 

10

Warning: %ls %ld in database differs from server %ls of %ld.

1818 

16

Primary log file '%ls' is missing and the database was not cleanly shut down so it cannot be rebuilt.

1819 

10

Could not create default log file because the name was too long.

1820 

16

Disk '%.*ls' is already completely used by other databases. It can be expanded with DISK RESIZE.

1826 

16

User-defined filegroups are not allowed on '%hs'.

1827 

16

CREATE/ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of %d MB per %S_MSG.

1828 

16

The file named '%.*ls' is already in use. Choose another name.

1829 

16

The FOR ATTACH option requires that at least the primary file be specified.

1830 

16

The files '%.*ls' and '%.*ls' are both primary files. A database can only have one primary file.

1831 

10

Successfully %ls database '%.*ls'.

1832 

20

Could not attach database '%.*ls' to file '%.*ls'.

1901 

16

Column '%.*ls'. Cannot create index on a column of bit data type.

1902

16

Cannot create more than one clustered index on table '%.*ls'. Drop the existing clustered index '%.*ls' before creating another.

1903

16

%d is the maximum allowable size of an index. The composite index specified is %d bytes.

1904

16

Cannot specify more than %d column names for index key list. %d specified.

1905 

21

Could not find 'zero' row for index '%.*ls' the table in sysindexes.

1906 

11

Cannot create an index on table '%.*ls', because this table does not exist in database '%.*ls'.

1909 

16

Cannot use duplicate column names in index key list. Column name '%.*ls' listed more than once.

1913 

16

There is already an index on table '%.*ls' named '%.*ls'.

1914 

16

Cannot create index on object '%.*ls' because it is not a user table.

1915 

16

Only members of the sysadmin role or the owner of table '%.*ls' can create an index on it.

1916

16

CREATE INDEX options %ls and %ls are mutually exclusive.

1918 

10

Index (ID = %d) is being rebuilt.

1919 

16

Column '%.*ls'. Cannot create index on a column of text, ntext, or image data type.

1920 

10

Skipping rebuild of index ID %d, which is on a read-only filegroup.

1921 

16

Invalid filegroup '%.*ls' specified.

1922 

16

Filegroup '%.*ls' has no files assigned to it. Tables, indexes, and text, ntext, and image columns cannot be created on this filegroup.

1923 

10

The clustered index has been dropped.

1924 

16

Filegroup '%.*ls' is read-only.

1925 

16

Cannot convert a clustered index to a nonclustered index using the DROP_EXISTING option.

1926 

16

Cannot create a clustered index because nonclustered index ID %d is on a read-only filegroup.

1927 

16

There are already statistics on table '%.*ls' named '%.*ls'.

1928 

16

Cannot create statistics on table '%.*ls' because this table does not exist in database '%.*ls'.

1929 

16

Cannot create statistics on table '%.*ls' because it is not a user table.

1930 

16

Only the owner of table '%.*ls' or a member of the sysadmin fixed server role can create statistics on it.

Errors 2000 - 2999

Error

Severity

Description

2001 

10

Cannot use duplicate parameter names. Parameter name '%.*ls' listed more than once.

2004 

16

Procedure '%.*ls' has already been created with group number %d. Create procedure with an unused group number.

2007 

11

Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object '%.*ls'. The stored procedure will still be created.

2008 

16

The object '%.*ls' is not a procedure so you cannot create another procedure under that group name.

2009 

10

Procedure '%.*ls' was created despite delayed name resolution warnings (if any).

2010 

16

Cannot use ALTER %ls with %.*ls because %.*ls is a %S_MSG.

2106 

11

Cannot create a trigger on table '%.*ls', because this table does not exist in database '%.*ls'.

2108 

16

Cannot create a trigger on table '%.*ls' because you can only create a trigger on a table in the current database.

2109 

16

Cannot create a trigger on table '%.*ls' that accesses 'inserted' or 'deleted' because the table was created with the no_log option.

2110 

16

Cannot alter trigger '%.*ls' for table '%.*ls' because this trigger does not belong to this table.

2501

16

Could not find table named '%.*ls'. Check sysobjects.

2502 

16

Could not start transaction.

2503 

10

Successfully deleted the physical file '%ls'.

2504 

16

Could not delete the physical file '%ls'. The DeleteFile system function returned error %ls.

2505 

16

The device '%.*ls' does not exist. Use sp_helpdevice to show available devices.

2511

16

Table Corrupt: Object ID %d, Index ID %d. Keys out of order on page %S_PGID, slots %d and %d.

2513

16

Table Corrupt: Object ID %ld (object '%.*ls') does not match between '%.*ls' and '%.*ls'.

2514 

16

Table Corrupt: Data type %ld (type '%.*ls') does not match between '%.*ls' and '%.*ls'.

2520 

16

Could not find database '%.*ls'. Check sysdatabases.

2521 

16

Could not find database ID %d. Check sysdatabases.

2526 

16

Incorrect DBCC statement. Check the documentation for the correct DBCC syntax and options.

2528 

10

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

2532 

16

DBCC SHRINKFILE could not shrink file %ls. Log files are not supported.

2535

16

Table Corrupt: Page %S_PGID is allocated to object ID %d, index ID %d, not to object ID %d, index ID %d found in page header.

2536 

10

DBCC results for '%.*ls'.

2538 

10

Allocation page %S_PGID. Number of extents = %ld, used pages = %ld, referenced pages = %ld.

2539 

10

Total number of extents = %ld, used pages = %ld, referenced pages = %ld in this database.

2540 

10

The system cannot self repair this error.

2541 

10

DBCC UPDATEUSAGE: sysindexes row updated for table '%.*ls' (index ID %ld):

2542 

10

DATA pages: Changed from (%ld) to (%ld) pages.

2543 

10

USED pages: Changed from (%ld) to (%ld) pages.

2544 

10

RSVD pages: Changed from (%ld) to (%ld) pages.

2545 

10

ROWS count: Changed from (%I64d) to (%I64d) rows.

2557 

16

Only the owner of object '%.*ls' can run DBCC %ls on it.

2560 

16

Parameter %d is incorrect for this DBCC statement.

2562 

16

'%ls' cannot access object '%.*ls' because it is not a table.

2566 

14

DBCC DBREINDEX cannot be used on system tables.

2568 

16

Page %S_PGID is out of range for this database or is in a log file.

2571 

10

Only members of the sysadmin role can use the DBCC statement %.*ls.

2573 

16

Database '%.*ls' is not marked suspect. You cannot drop it with DBCC.

2574 

10

Object ID %d, index ID %d: Page %S_PGID is empty. This is not permitted at level %d of the B-tree.

2583 

16

An incorrect number of parameters was given to the DBCC statement.

2588 

16

Page %S_PGID was expected to be the first page of a text, ntext, or image value.

2591 

16

Could not find row in sysindexes with index ID %d for table '%.*ls'.

2592 

10

%ls index successfully restored for object '%.*ls' in database '%.*ls'.

2593 

10

There are %I64d rows in %ld pages for object '%.*ls'.

2594 

16

Invalid index ID (%d) specified.

2595 

16

Database '%.*ls' must be set to single user mode before executing this statement.

2597 

16

The database is not open. Execute a 'USE %.*ls' statement and rerun the DBCC statement.

2598 

16

Clustered indexes on sysobjects and sysindexes cannot be re-created.

2601

14

Cannot insert duplicate key row in object '%.*ls' with unique index '%.*ls'.

2603 

21

No space left on logical page %S_PGID of index ID %d for object '%.*ls' when inserting row on an index page. This situation should have been handled while traversing the index.

2617 

20

Buffer holding logical page %S_PGID not found in keep pool in SDES for object '%.*ls'. Contact Technical Support.

2624 

21

Could not insert into table %S_DES because row length %d is less than the minimum length %d.

2627 

14

Violation of %ls constraint '%.*ls'. Cannot insert duplicate key in object '%.*ls'.

2701 

10

Database name '%.*ls' ignored, referencing object in tempdb.

2702 

16

Database '%.*ls' does not exist.

2705 

16

Column names in each table must be unique. Column name '%.*ls' in table '%.*ls' is specified more than once.

2706 

11

Table '%.*ls' does not exist.

2710 

16

You are not the owner specified for the object '%.*ls' in this statement (CREATE, ALTER, TRUNCATE, UPDATE STATISTICS or BULK INSERT).

2714 

16

There is already an object named '%.*ls' in the database.

2715 

16

Column or parameter #%d: Cannot find data type %.*ls.

2716 

16

Column or parameter #%d: Cannot specify a column width on data type %.*ls.

2717 

16

Column or parameter #%d: Specified column width too large for data type %.*ls.

2718 

16

Column or parameter #%d: Cannot specify null values on a column of data type bit.

2721 

11

Could not find a default segment to create the table on. Ask your system administrator to specify a default segment in syssegments.

2724 

10

Parameter '%.*ls' has an invalid data type.

2727 

11

Cannot find index '%.*ls'.

2729 

16

Procedure '%.*ls' group number 1 already exists in the database. Choose another procedure name.

2730 

11

Cannot create procedure '%.*ls' with a group number of %d because a procedure with the same name and a group number of 1 does not currently exist in the database. Must execute CREATE PROCEDURE '%.*ls';1 first.

2732 

16

User error number %ld is invalid. The number must be between %ld and %ld.

2734 

16

The user name '%.*ls' does not exist in sysusers.

2736 

16

Owner name specified is a group name. Objects cannot be owned by groups.

2737 

16

Message passed to %hs must be of type char, varchar, nchar, or nvarchar.

2738 

16

A table can only have one timestamp column. Because table '%.*ls' already has one, the column '%.*ls' cannot be added.

2739 

16

The text, ntext, and image data types are invalid for local variables.

2740 

16

SET LANGUAGE failed because '%.*ls' is not an official language name or a language alias on this SQL Server.

2741 

16

SET DATEFORMAT date order '%.*ls' is invalid.

2742 

16

SET DATEFIRST %d is out of range.

2743 

16

%ls statement requires %S_MSG parameter.

2744 

16

Multiple identity columns specified for table '%.*ls'. Only one identity column per table is allowed.

2745 

10

Process ID %d has raised user error %d, severity %d. SQL Server is terminating this process.

2746 

16

Cannot specify user error format string with a length exceeding %d bytes.

2747 

16

Too many substitution parameters for RAISERROR. Cannot exceed %d substitution parameters.

2748 

16

Cannot specify %ls data type (RAISERROR parameter %d) as a substitution parameter for RAISERRROR.

2749 

16

Identity column '%.*ls' must be of data type int, smallint, tinyint, or decimal or numeric with scale of 0, and constrained to be nonnullable.

2750

16

Column or parameter #%d: Specified column precision %d is greater than the maximum precision of %d.

2751

16

Column or parameter #%d: Specified column scale %d is greater than the specified precision of %d.

2752 

16

Identity column '%.*ls' contains invalid SEED.

2753 

16

Identity column '%.*ls' contains invalid INCREMENT.

2754 

16

Error severity levels greater than %d can only be specified by members of the sysadmin role, using the WITH LOG option.

2755 

16

SET DEADLOCK_PRIORITY option '%.*ls' is invalid.

2756 

16

Invalid value %d for state. Valid range is from %d to %d.

2757 

16

RAISERROR failed due to invalid parameter substitution(s) for error %d, severity %d, state %d.

2758 

16

%hs could not locate entry for error %d in sysmessages.

2759 

0

CREATE SCHEMA failed due to previous errors.

2760 

16

Specified owner name '%.*ls' either does not exist or you do not have permission to use it.

2761 

16

The ROWGUIDCOL property can only be specified on the uniqueidentifier data type.

2762 

16

sp_setapprole was not invoked correctly. Refer to the documentation for more information.

2763 

16

Could not find application role '%.*ls'.

2764 

16

Incorrect password supplied for application role '%.*ls'.

2765 

15

Could not locate statistics for column '%.*ls' in the system catalogs.

2766 

16

The definition for user-defined data type '%.*ls' has changed.

2767 

15

Could not locate statistics '%.*ls' in the system catalogs.

2768 

15

Statistics for %ls '%.*ls'.

2769 

15

Column '%.*ls'. Cannot create statistics on a column of data type %ls.

2770 

16

The SELECT INTO statement cannot have same source and destination tables.

2771 

16

Cannot create statistics on table '%.*ls'. This table is a virtual system table.

2809 

18

The request for %S_MSG '%.*ls' failed because '%.*ls' is a %S_MSG object.

2812

16

Could not find stored procedure '%.*ls'.

Errors 3000 - 3999

Error

Severity

Description

3009 

16

Could not insert a backup or restore history/detail record in the msdb database. This may indicate a problem with the msdb database. The backup/restore operation was still successful.

3013 

16

Backup or restore operation terminating abnormally.

3014 

10

Backup or restore operation successfully processed %d pages in %d.%03d seconds (%d.%03d MB/sec).

3015 

10

%hs is not yet implemented.

3016 

16

File '%ls' of database '%ls' has been removed or shrunk since this backup or restore operation was interrupted. The operation cannot be restarted.

3017 

16

Could not resume interrupted backup or restore operation. See the SQL Server error log for more information.

3018 

16

There is no interrupted backup or restore operation to restart. Reissue the statement without the RESTART clause.

3019 

16

The checkpoint file was for a different backup or restore operation. Reissue the statement without the RESTART clause.

3020 

16

The backup operation cannot be restarted as the log has been truncated. Reissue the statement without the RESTART clause.

3021 

16

Cannot perform a backup or restore operation within a transaction.

3023

16

Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as CREATE FILE) operations on a database must be serialized. Reissue the statement after the current backup, CHECKALLOC, or file manipulation operation is completed.

3024 

16

You can only perform a full backup of the master database. Use BACKUP DATABASE to back up the entire master database.

3025 

16

Missing database name. Reissue the statement specifying a valid database name.

3026 

16

Could not find filegroup ID %d in sysfilegroups for database '%ls'.

3027 

16

Could not find filegroup '%.*ls' in sysfilegroups for database '%.*ls'.

3028 

16

Operation checkpoint file is invalid. Could not restart operation. Reissue the statement without the RESTART option.

3029 

16

Database file '%ls' is subject to logical recovery and must be among the files to be backed up as part of the file or filegroup backup.

3030 

16

Database file '%ls' is subject to logical recovery and must be among the files to be restored.

3031 

16

The statement has inconsistent or conflicting options. Remove the conflicting option and reissue the statement.

3032 

16

One or more of the options is not supported for this statement. Review the documentation for supported options.

3033 

16

BACKUP DATABASE cannot be used on a database opened in emergency mode.

3034 

16

No files were selected to be processed. You may have selected one or more filegroups that have no members.

3035 

16

Cannot perform a differential backup for database '%ls', because a current database backup does not exist. Reissue the statement omitting the WITH DIFFERENTIAL option.

3036

16

Database '%ls' is in warm-standby state (set by executing RESTORE WITH STANDBY) and cannot be backed up until the entire load sequence is completed.

3101

16

Database in use. The system administrator must have exclusive use of the database to run the restore operation.

3106 

16

The specified file '%ls' is in an obsolete backup database format (version %d) and cannot be upgraded to current server version %d.

3108 

16

RESTORE DATABASE must be used in single user mode when trying to restore the master database.

3110 

14

Only members of the sysadmin role or the database owner of '%.*ls' can run RESTORE DATABASE.

3112 

16

Cannot restore any database other than master when the server is in single user mode.

3113 

21

The database owner (DBO) does not have an entry in sysusers in database '%.*ls'.

3114 

21

Database '%.*ls' does not have an entry in sysdatabases.

3115 

10

User '%.*ls' in database '%.*ls' has SUID %d, which is the same as the SUID of the database owner (as defined in sysdatabases). User '%.*ls' will be given SUID %d.

3116 

10

When all restore transactions have been completed for database '%.*ls', user '%.*ls' should be given the next available SUID.

3117 

10

Database '%.*ls' already has a user with SUID %d.

3120

16

The database you are attempting to restore was backed up under a different sort order ID (%d) than the one currently running on this server (%d), and at least one of them is a non-binary sort order.

3123 

16

Invalid database name '%.*ls' specified for backup or restore operation.

3127 

16

Temporary Message: The backup set does not contain pages for file '%ls'.

3128 

16

File '%ls' has an unsupported page size (%d).

3129 

16

Temporary Message: File '%ls' has changed size from %d to %d bytes.

3132 

16

The RAID set for database '%ls' is missing member number %d.

3133 

16

The volume on device '%ls' is not a member of the media family.

3135 

16

Cannot use the backup set in file '%ls' for this restore operation.

3136 

16

Cannot apply the differential backup on device '%ls' to database '%ls'.

3138 

16

One or more files in the backup set are no longer part of database '%ls'.

3140 

16

Could not adjust the space allocation for file '%ls'.

3141 

16

The database to be restored was named '%ls'. Reissue the statement using the WITH REPLACE option to overwrite the '%ls' database.

3142 

16

One or more devices or files already exist. Reissue the statement using the WITH REPLACE option to overwrite these files and devices.

3143

16

The data set on device '%ls' is not a SQL Server backup set.

3144 

16

File '%.*ls' was not backed up in file %d on device '%ls'. The file cannot be restored from this backup set.

3145 

16

The STOPAT option is not supported for RESTORE DATABASE. You can use the STOPAT option with RESTORE LOG.

3146 

16

None of the newly-restored files had been modified after the backup was taken, so no further recovery actions are required. The database is now available for use.

3147 

16

Backup and restore operations are not allowed on database tempdb.

3148 

16

Media recovery for ALTER DATABASE is not yet implemented. The database cannot be rolled forward.

3149

16

The database you are attempting to restore was backed up under a different Unicode locale ID (%d) or Unicode comparison style (%d) than the Unicode locale ID (%d) or Unicode comparison style (%d) currently running on this server.

3150 

10

The master database has been successfully restored. Shutting down SQL Server.

3151 

21

The master database failed to restore. Use the rebuildm utility to rebuild the master database. Shutting down SQL Server.

3152 

16

Cannot overwrite file '%ls' because it is marked as read-only.

3153 

16

The database is already fully recovered.

3154

16

The backup set holds a backup of a database other than the existing '%ls' database.

3155

16

The RESTORE operation cannot proceed because one or more files have been added or dropped from the database since the backup set was created.

3156 

16

The file '%ls' cannot be used by RESTORE. Consider using the WITH MOVE option to identify a valid location for the file.

3157 

16

The logical file (%d) is named '%ls'. RESTORE will not overwrite it from '%ls'.

3158 

16

Could not create one or more files. Consider using the WITH MOVE option to identify valid locations.

3159 

16

The tail of the log for database '%ls' has not been backed up. Back up the log and rerun the RESTORE statement specifying the FILE clause.

3160 

16

Could not update primary file information in sysdatabases.

3161 

16

The primary file is unavailable. It must be restored or otherwise made available.

3162 

16

The database has on-disk structure version %d. The server supports version %d and can only restore such a database that was inactive when it was backed up. This database was not inactive.

3163 

16

The transaction log was damaged. All data files must be restored before RESTORE LOG can be attempted.

3164 

16

Cannot roll forward the database with on-disk structure version %d. The server supports version %d. Reissue the RESTORE statement WITH RECOVERY.

3165 

16

Could not adjust the replication state of database '%ls'. The database was successfully restored, however its replication state is indeterminate. See "Troubleshooting Replication" in this volume.

3166 

16

RESTORE DATABASE could not drop database '%ls'. Drop the database and then reissue the RESTORE DATABASE statement.

3167 

16

RESTORE could not start database '%ls'.

3201 

16

Cannot open backup device '%ls'. Device error or device off-line. See the SQL Server error log for more details.

3202 

16

Write on '%ls' failed, status = %ld. See the SQL Server error log for more details.

3203 

16

Read on '%ls' failed, status = %ld. See the SQL Server error log for more details.

3204 

16

Operator aborted backup or restore. See the error messages returned to the console for more details.

3205 

16

Too many backup devices specified for backup or restore; only %d are allowed.

3206

16

No entry in sysdevices for backup device '%.*ls'. Update sysdevices and rerun statement.

3207 

16

Backup or restore requires at least one backup device. Rerun your statement specifying a backup device.

3208 

16

Unexpected end of file while reading beginning of backup set. Confirm that the media contains a valid SQL Server backup set, and see the console error log for more details.

3209

16

'%.*ls' is not a backup device. Check sysdevices.

3211 

10

%d percent %hs.

3217 

16

Invalid value specified for %ls parameter.

3221 

16

The ReadFileEx system function executed on file '%ls' only read %d bytes, expected %d.

3222 

16

The WriteFileEx system function executed on file '%ls' only wrote %d bytes, expected %d.

3224 

16

Could not create worker thread.

3227

16

The volume on device '%ls' is a duplicate of stripe set member %d.

3229 

16

Request for device '%ls' timed out.

3230 

16

Operation on device '%ls' exceeded retry count.

3234 

16

File '%.*ls' is not a database file for database '%ls'.

3235 

16

File '%ls' is not part of database '%ls'. You can only list files that are members of this database.

3237 

16

Option not supported for Named Pipe-based backup sets.

3239 

16

The backup set on device '%ls' uses a feature of the Microsoft Tape Format not supported by SQL Server.

3241 

16

The media family on device '%ls' is incorrectly formed. SQL Server cannot process this media family.

3242

16

The file on device '%ls' is not a valid Microsoft Tape Format backup set.

3243 

16

The media family on device '%ls' was created using Microsoft Tape Format version %d.%d. SQL Server supports version %d.%d.

3244 

16

Descriptor block size exceeds %d bytes. Use a shorter name and/or description string and retry the operation.

3245 

16

Could not convert a string to or from Unicode, %ls.

3246 

16

The media family on device '%ls' is marked as nonappendable. Reissue the statement using the INIT option to overwrite the media.

3247

16

The volume on device '%ls' has the wrong media sequence number (%d). Remove it and insert volume %d.

3248 

25

>>> VOLUME SWITCH <<< (not for output!)

3249

16

The volume on device '%ls' is a continuation volume for the backup set. Remove it and insert the volume holding the start of the backup set.

3250 

16

The value '%d' is not within range for the %ls parameter.

3251

10

The RAID stream on device '%ls' has been finished. The device will now be reused for one of the remaining RAID streams.

3252 

16

Passwords on media and/or data sets are not supported in this release of SQL Server.

3253 

16

The block size parameter must supply a value that is a power of 2.

3254 

16

The volume on device '%ls' is empty.

3255 

16

The data set on device '%ls' is a SQL Server backup set not compatible with this version of SQL Server.

3256

16

The backup set on device '%ls' was terminated while it was being created and is incomplete. RESTORE sequence is terminated abnormally.

3257 

16

There is insufficient free space on disk volume '%ls' to create the database. The database requires %I64u additional free bytes, while only %I64u bytes are available.

3258

16

The volume on device '%ls' belongs to a different media set.

3259 

16

The volume on device '%ls' is not part of a multifamily (RAID) media set. Use WITH FORMAT to form a new RAID set.

3260 

16

An internal buffer has become full.

3261 

16

SQL Server cannot use the virtual device configuration.

3262 

10

The backup set is valid.

3263

16

Cannot use the volume on device '%ls' as a continuation volume. It is sequence number %d of family %d for the current media set. Insert a new volume, or sequence number %d of family %d for the current set.

3264 

16

The operation did not proceed far enough to allow RESTART. Reissue the statement without the RESTART qualifier.

3265 

16

The login has insufficient authority. Membership of the sysadmin role is required to use VIRTUAL_DEVICE with BACKUP or RESTORE.

3266 

10

The Microsoft Tape Format (MTF) soft filemark database on backup device '%ls' cannot be read, inhibiting random access.

3267

16

Insufficient resources to create UMS scheduler.

3268 

16

Cannot use the backup file '%ls' because it was originally formatted with sector size %d and is now on a device with sector size %d.

3269 

16

Cannot restore the file '%ls' because it was originally written with sector size %d; '%ls' is now on a device with sector size %d.

3270 

16

An internal consistency error occurred. Contact Technical Support for assistance.

3271 

16

Nonrecoverable I/O error occurred on file '%ls'.

3272 

16

The '%ls' device has a hardware sector size of %d, but the block size parameter specifies an incompatible override value of %d. Reissue the statement using a compatible block size.

3301 

21

Invalid log record found in the transaction log (logop %d).

3307 

21

Process %d was expected to hold logical lock on page %S_PGID.

3313 

21

Error while redoing logged operation in database '%.*ls'. Error at log record ID %S_LSN.

3314 

21

Error while undoing logged operation in database '%.*ls'. Error at log record ID %S_LSN.

3405 

10

Recovering database '%.*ls'.

3406 

10

%d transactions rolled forward in database '%.*ls' (%d).

3407 

10

%d transactions rolled back in database '%.*ls' (%d).

3408 

10

Recovery complete.

3413 

21

Database ID %d. Could not mark database as suspect. Getnext NC scan on sysdatabases.dbid failed.

3414

10

Database '%.*ls' (database ID %d) could not recover. Contact Technical Support.

3415 

16

Read-only database '%.*ls' must be made writable before it can be upgraded.

3417 

21

Cannot recover the master database. Exiting.

3429 

10

Warning: The outcome of transaction %S_XID, named '%.*ls' in database '%.*ls' (database ID %d), could not be determined because the coordinating database (database ID %d) could not be opened. The transaction was assumed to be committed.

3430 

10

Warning: Could not determine the outcome of transaction %S_XID, named '%.*ls' in database '%.*ls' (with ID %d) because the coordinating database (ID %d) did not contain the outcome. The transaction was assumed to be committed.

3431 

21

Could not recover database '%.*ls' (database ID %d) due to unresolved transaction outcomes.

3432 

16

Warning: syslanguages is missing.

3433 

16

Name is truncated to '%.*ls'. The maximum name length is %d.

3434 

20

Cannot change sort order or locale. Server shutting down. Restart SQL Server to continue with sort order unchanged.

3435 

20

Sort order or locale cannot be changed because user objects or user databases exist.

3436 

20

Cannot rebuild index ID %d for the '%.*ls' table in the '%.*ls' database.

3437 

21

Error recovering database '%.*ls'. Could not connect to MSDTC to check the completion status of transaction %S_XID.

3438 

10

Database '%.*ls' (database ID %d) failed to recover because transaction first LSN is not equal to LSN in checkpoint. Contact Technical Support.

3439 

10

Database '%.*ls' (database ID %d). The DBCC RECOVERDB statement failed due to previous errors.

3440 

21

Database '%.*ls' (database ID %d). The DBCC RECOVERDB statement can only be run after a RESTORE statement that used the WITH NORECOVERY option.

3441 

21

Database '%.*ls' (database ID %d). The RESTORE statement could not access file '%ls'. Error was '%ls'.

3442 

21

Database '%.*ls' (database ID %d). The size of the undo file is insufficient.

3443 

21

Database '%.*ls' (database ID %d) was marked for standby or read-only use, but has been modified. The RESTORE LOG statement cannot be performed.

3444 

21

Database '%.*ls' (database ID %d). Could not find start of previous recovery operation. The RESTORE LOG statement cannot be performed.

3445 

21

Database '%.*ls' (database ID %d). The file '%ls' is not a valid undo file.

3446 

16

Primary file not available for database '%.*ls'.

3447 

16

Could not activate or scan all of the log files for database '%.*ls'.

3448 

21

Could not undo log record %S_LSN, for transaction ID %S_XID, on page %S_PGID, database '%.*ls' (database ID %d). Page information: LSN = %S_LSN, type = %ld. Log information: OpCode = %ld, context %ld.

3449 

21

An error has occurred indicating potential database corruption. SQL Server is shutting down so that recovery can be performed on database ID %d.

3450 

10

Recovery progress on database '%.*ls' (%d): %d percent.

3451 

16

Recovery has failed because reexecution of CREATE INDEX found inconsistencies between target filegroup '%ls' (%d) and source filegroup '%ls' (%d). Restore both filegroups before attempting further RESTORE LOG operations.

3452 

10

Recovery of database '%.*ls' (%d) detected possible identity value inconsistency in table ID %d. Run DBCC CHECKIDENT ('%.*ls').

3453 

21

Recovery has failed because a nonlogged operation could not be redone. Use the RESTORE statement to restore all data in filegroup '%ls' (%d) to a point beyond the nonlogged changes.

3501 

21

Could not find row in sysdatabases for database ID %d at checkpoint time.

3505 

14

Only the owner of database '%.*ls' can run the CHECKPOINT statement.

3508 

25

Could not get an exclusive lock on the database '%.*ls'. Make sure that no other users are currently using this database, and rerun the CHECKPOINT statement.

3509 

14

Could not set database '%.*ls' %ls read-only user mode because you could not exclusively lock the database.

3510 

16

Database '%.*ls' cannot be changed from read-only because the primary and/or log file(s) are not writable.

3604

10

Duplicate key was ignored.

3605 

10

Duplicate row was ignored.

3606 

10

Arithmetic overflow occurred.

3607 

10

Division by zero occurred.

3608 

16

Cannot allocate a GUID for the token.

3612 

10

%hsSQL Server Execution Times:%hs CPU time = %lu ms, elapsed time = %lu ms.

3613 

10

SQL Server parse and compile time: %hs CPU time = %lu ms, elapsed time = %lu ms.

3615 

10

Table '%.*ls'. Scan count %d, logical reads %d, physical reads %d, read-ahead reads %d.

3618 

10

The transaction has been terminated.

3619 

10

Could not write a CHECKPOINT record in database ID %d because the log is out of space.

3620 

10

Automatic checkpointing is disabled in database '%.*ls' because the log is out of space. It will continue when the database owner successfully checkpoints the database. Free up some space or extend the database and then run the CHECKPOINT statement.

3621 

10

The statement has been terminated.

3622 

10

A domain error occurred.

3623 

10

A transaction on a no_log table was undone. See the SQL Server errorlog for details.

3625 

20

'%hs' is not yet implemented.

3627

16

Could not create worker thread.

3701 

11

Cannot drop the %S_MSG '%.*ls', because it does not exist in the system catalog.

3702 

16

Cannot drop the %S_MSG '%.*ls' because it is currently in use.

3704 

16

Only the owner or members of the sysadmin role can drop the %S_MSG '%.*ls'.

3705 

16

Cannot use DROP %ls with '%.*ls' because '%.*ls' is a %S_MSG. Use DROP %ls.

3708 

16

Cannot drop the %S_MSG '%.*ls' because it is a system %S_MSG.

3716 

16

The %S_MSG '%.*ls' cannot be dropped because it is bound to one or more %S_MSG.

3718 

11

Could not drop index '%.*ls' because the table or clustered index entry cannot be found in the sysindexes system table.

3723 

16

An explicit DROP INDEX is not allowed on index '%.*ls'. It is being used for %ls constraint enforcement.

3724 

16

Cannot drop the %S_MSG '%.*ls' because it is published for replication.

3725 

16

The constraint '%.*ls' is being referenced by table '%.*ls', foreign key constraint '%.*ls'.

3726 

16

Could not drop object '%.*ls' because it is referenced by a FOREIGN KEY constraint.

3727 

10

Could not drop constraint. See previous errors.

3728 

16

'%.*ls' is not a constraint.

3733 

16

Constraint '%.*ls' does not belong to table '%.*ls'.

3736 

16

Cannot drop the %S_MSG '%.*ls' because it is being used for distribution.

3740 

16

Cannot drop the %S_MSG '%.*ls' because at least part of the table resides on a read-only filegroup.

3902 

13

The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION.

3903 

13

The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.

3904 

21

Cannot unsplit logical page %S_PGID in object '%.*ls', in database '%.*ls'. Both pages together contain more data than will fit on one page.

3906 

16

Could not run BEGIN TRANSACTION in database '%.*ls' because the database is read-only.

3908 

16

Could not run BEGIN TRANSACTION in database '%.*ls' because the database is in bypass recovery mode.

3909 

16

Session binding token is invalid or corrupt.

3910 

16

Transaction context in use by another session.

3912 

16

Cannot bind using an XP token while the server is not in an XP call.

3914 

16

The data type '%s' is invalid for transaction names or savepoint names. Allowed data types are char, varchar, nchar, or nvarchar.

3915 

16

Cannot use the ROLLBACK statement within an INSERT-EXEC statement.

3916 

16

Cannot use the COMMIT statement within an INSERT-EXEC statement unless BEGIN TRANSACTION is used first.

3917 

16

Session is bound to a transaction context that is in use. Other statements in the batch were ignored.

Errors 4000 - 4999

Error

Severity

Description

4003 

21

ODS error. Server is terminating this connection.

4004 

16

ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC version 3.7 or earlier.

4015 

16

Language requested in login '%.*ls' is not an official name on this SQL Server. Using server-wide default %.*ls instead.

4016 

16

Language requested in 'login %.*ls' is not an official name on this SQL Server. Using user default %.*ls instead.

4017 

16

Neither the language requested in 'login %.*ls' nor user default language %.*ls is an official language name on this SQL Server. Using server-wide default %.*ls instead.

4018 

16

User default language %.*ls is not an official language name on this SQL Server. Using server-wide default %.*ls instead.

4019 

16

Language requested in login '%.*ls' is not an official language name on this SQL Server. Login fails.

4020 

16

Default date order '%.*ls' for language %.*ls is invalid. Using mdy instead.

4027 

16

Mount tape for %hs of database '%ls'.

4028 

16

End of tape has been reached. Remove tape '%ls' and mount next tape for %hs of database '%ls'.

4030 

10

The medium on device '%ls' expires on %hs and cannot be overwritten.

4035 

10

Processed %d pages for database '%ls', file '%ls' on file %d.

4037 

16

User-specified volume ID '%ls' does not match the volume ID '%ls' of the device '%ls'.

4038 

16

Cannot find file ID %d on device '%ls'.

4060 

11

Cannot open database requested in login '%.*ls'. Login fails.

4061 

11

Cannot open either database requested in login (%.*ls) or user default database (%.*ls). Using master database instead.

4062 

11

Cannot open user default database '%.*ls'. Using master database instead.

4063 

11

Cannot open database requested in login (%.*ls). Using user default '%.*ls' instead.

4207

16

BACKUP LOG is not allowed while the select into/bulkcopy option is enabled. Use BACKUP DATABASE or disable the option using sp_dboption.

4208

16

BACKUP LOG is not allowed while the trunc. log on chkpt. option is enabled. Use BACKUP DATABASE or disable the option using sp_dboption.

4212 

16

Cannot back up the log of the master database. Use BACKUP DATABASE instead.

4213 

16

Cannot allow BACKUP LOG because file '%ls' has been subjected to nonlogged updates and cannot be rolled forward. Perform a full database, or differential database, backup.

4214

10

There is no current database backup. This log backup cannot be used to roll forward a preceding database backup.

4215 

10

The log was not truncated because records at the beginning of the log are pending replication. Ensure the Log Reader Agent is running or use sp_repldone to mark transactions as distributed.

4301 

16

Database in use. The system administrator must have exclusive use of the database to restore the log.

4304 

16

A USER ATTENTION signal raised during RESTORE LOG is being ignored until the current restore completes.

4305

16

This backup set cannot be restored because the database has not been rolled forward far enough. You must first restore all earlier logs before restoring this log.

4306

16

The preceding restore operation did not specify WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying WITH NORECOVERY or WITH STANDBY for all but the final step.

4312 

16

Only members of the sysadmin role or owner of database '%.*ls' can run RESTORE LOG.

4316 

16

Can only RESTORE LOG in the master database if SQL Server is in single user mode.

4318

16

File '%ls' has been rolled forward to LSN %.*ls. This log terminates at LSN %.*ls, which is too early to apply the WITH RECOVERY option. Reissue the RESTORE LOG statement WITH NORECOVERY.

4319 

16

Cannot use the STOPAT and NORECOVERY options together. Reissue the statement specifying WITH RECOVERY to roll the database forward to a specific point in time.

4320 

16

File '%ls' was only partially restored by a database or file restore. The entire file must be successfully restored before applying the log.

4321 

16

The minimum recovery point of the database is beyond the specified point-in-time. Reissue this statement without specifying STOPAT.

4322 

10

This log file contains records logged before the designated point-in-time. The database is being left in load state so you can apply another log file.

4323 

16

The database is marked suspect. Transaction logs cannot be restored. Use RESTORE DATABASE to recover the database.

4324 

10

Backup history older than %ls has been deleted.

4325 

16

Could not delete entries for backup set ID '%ls'.

4403 

16

View '%.*ls' is not updatable because it contains aggregates.

4404 

16

View '%.*ls' is not updatable because the definition contains the DISTINCT clause.

4405 

16

View '%.*ls' is not updatable because the FROM clause names multiple tables.

4406 

16

View '%.*ls' is not updatable because a column of the view is derived or constant.

4408 

19

The query and the views in it exceed the limit of %d tables.

4413 

16

Could not use view '%.*ls' because of previous binding errors.

4414 

16

Could not allocate ancillary table for view resolution. The maximum number of tables in a query (%d) was exceeded.

4415 

16

View '%.*ls' is not updatable because either it was created WITH CHECK OPTION or it spans a view created WITH CHECK OPTION and the target table is referenced multiple times in the resulting query.

4416 

16

View '%.*ls' is not updatable because the definition contains a UNION operator.

4417 

16

Derived table '%.*ls' is not updatable because the definition contains a UNION operator.

4418 

16

Derived table '%.*ls' is not updatable because it contains aggregates.

4419 

16

Derived table '%.*ls' is not updatable because the definition contains the DISTINCT clause.

4420 

16

Derived table '%.*ls' is not updatable because the FROM clause names multiple tables.

4421 

16

Derived table '%.*ls' is not updatable because a column of the derived table is derived or constant.

4424 

16

Joined tables cannot be specified in a query containing outer join operators. View '%.*ls' contains joined tables.

4425 

16

Cannot specify outer join operators in a query containing joined tables. View '%.*ls' contains outer join operators.

4427 

16

The view '%.*ls' is not updatable because the definition contains the TOP clause.

4428 

16

The derived table '%.*ls' is not updatable because the definition contains the TOP clause.

4429 

16

View '%.*ls' contains a self-reference. Views cannot reference themselves directly or indirectly.

4430 

10

Warning: Index hints supplied for view '%.*ls' will be ignored.

4501 

16

View '%.*ls' has more columns defined than column names given.

4502 

16

View '%.*ls' has more column names specified than columns defined.

4504 

16

Could not perform CREATE TABLE because there was not enough space to allocate memory for the table.

4505 

16

CREATE VIEW failed because column '%.*ls' in view '%.*ls' exceeds the maximum of %d columns.

4506 

10

Column names in each view must be unique. Column name '%.*ls' in view '%.*ls' is specified more than once.

4508 

16

Views are not allowed on temporary tables. Table names that begin with '#' denote temporary tables.

4510 

16

Could not perform CREATE VIEW because WITH CHECK OPTION was specified and the view is not updatable.

4511 

16

Could not perform CREATE VIEW because no column name was specified for column %d.

4602 

14

Only members of the sysadmin role can grant or revoke the CREATE DATABASE permission.

4603 

14

Only the owner of the current database can grant or revoke this permission.

4604 

16

There is no such user or group '%.*ls'.

4606 

16

Granted or revoked privilege %ls is not compatible with object.

4610 

16

You can only grant or revoke permissions on objects in the current database.

4611 

16

To revoke grantable privileges, specify the CASCADE option with REVOKE.

4613 

16

Grantor does not have GRANT permission.

4615 

16

Invalid column name '%.*ls'.

4617 

16

Cannot grant, deny or revoke permissions to or from special roles.

4618 

16

You do not have permission to use %.*ls in the AS clause.

4619 

16

CREATE DATABASE permission can only be granted in the master database.

4701 

11

Could not truncate table '%.*ls' because this table does not exist in database '%.*ls'.

4706 

17

Could not truncate table '%.*ls' because there is not enough room in the log to record the deallocation of all the index and data pages.

4707 

16

Could not truncate object '%.*ls' because it or one of its indexes resides on a READONLY filegroup.

4708 

16

Could not truncate object '%.*ls' because it is not a table.

4709 

16

You are not allowed to truncate the system table '%.*ls'.

4710 

16

Only the owner or members of the sysadmin role can truncate table '%.*ls'.

4711 

16

Cannot truncate table '%.*ls' because it is published for replication.

4712 

16

Cannot truncate table '%.*ls' because it is being referenced by a FOREIGN KEY constraint.

4801 

20

Bulk_main: The opentable system function on BULK INSERT table failed. Database ID %d, name '%.*ls'.

4803 

21

Received invalid row length %d from bcp client. Maximum row size is %d.

4804 

21

Premature end-of-message while reading current row from host. Host program may have terminated.

4805 

17

The front-end tool you are using does not support the feature of bulk insert from host. Use the proper tools for this command.

4807 

21

Received invalid row length %d from bcp client. Minimum row size is %d.

4810 

16

Expected the TEXT token in data stream for bulk copy of text or image data.

4811 

16

Expected the column offset in data stream for bulk copy of text or image data.

4812 

16

Expected the row offset in data stream for bulk copy of text or image data.

4813 

16

Expected the text length in data stream for bulk copy of text, ntext, or image data.

4815 

21

Received invalid column length from bcp client.

4817 

16

Could not bulk insert. Invalid sorted column '%.*ls'. Assuming data stream is not sorted.

4818 

16

Could not bulk insert. Sorted column '%.*ls' was specified more than once. Assuming data stream is not sorted.

4819 

16

Could not bulk insert. Bulk data stream was incorrectly specified as sorted.

4820 

16

Could not bulk insert. Unknown version of format file '%s'.

4821 

16

Could not bulk insert. Error reading the number of columns from format file '%s'.

4822 

16

Could not bulk insert. Invalid number of columns in format file '%s'.

4823 

16

Could not bulk insert. Invalid column number in format file '%s'.

4824 

16

Could not bulk insert. Invalid data type for column number %d in format file '%s'.

4825 

16

Could not bulk insert. Invalid prefix for column number %d in format file '%s'.

4826 

16

Could not bulk insert. Invalid column length for column number %d in format file '%s'.

4827 

16

Could not bulk insert. Invalid column terminator for column number %d in format file '%s'.

4828 

16

Could not bulk insert. Invalid destination table column number for source column %d in format file '%s'.

4829 

16

Could not bulk insert. Error reading destination table column name for source column %d in format file '%s'.

4830 

10

Bulk Insert: DataFileType was incorrectly specified as char. DataFileType will be assumed to be widechar because the data file has a Unicode signature.

4831 

10

Bulk Insert: DataFileType was incorrectly specified as widechar. DataFileType will be assumed to be char because the data file does not have a Unicode signature.

4832 

16

Bulk Insert: Unexpected end-of-file (EOF) encountered in data file.

4833 

16

Bulk Insert: Version mismatch between the provider dynamic link library and the server executable.

4834 

16

Permission denied. Only members of the sysadmin role can use the BULK INSERT statement.

4835 

16

Bulk copying into a table with computed columns is not supported for downlevel clients.

4836 

10

Warning: Table '%s' is published for merge replication. Reinitialize affected subscribers or execute sp_addtabletocontents to ensure that data added is included in the next sychronization.

4837 

16

Error: Cannot bulk copy into a table '%s' enabled for immediate-updating subscriptions

4849 

16

Could not import table '%ls'. Error %d.

4850 

10

Data import: Table '%ls' is already locked by another user.

4851 

10

Data import: Table '%ls' already has data. Skipping to next table.

4852 

10

Data import: Table '%ls' does not exist or it is not a user table.

4853 

10

%hs

4854 

21

%hs

4860 

16

Could not bulk insert. File '%ls' does not exist.

4861 

16

Could not bulk insert because file '%ls' could not be opened. Operating system error code %ls.

4862 

16

Could not bulk insert because file '%ls' could not be read. Operating system error code %ls.

4863 

16

Bulk insert data conversion error (truncation) for row %d, column %d (%ls).

4864 

16

Bulk insert data conversion error (type mismatch) for row %d, column %d (%ls).

4865 

16

Could not bulk insert because the maximum number of errors (%d) was exceeded.

4866 

16

Could not bulk insert because column too long in data file. Make sure FieldTerminator and RowTerminator were specified correctly.

4867 

16

Bulk insert data conversion error (overflow) for row %d, column %d (%ls).

4901 

16

ALTER TABLE only allows columns to be added that can contain nulls or have a DEFAULT definition specified. Column '%.*ls' cannot be added to table '%.*ls' because it does not allow nulls and does not specify a DEFAULT definition.

4909 

16

Cannot alter '%.*ls' because it is not a table.

4910 

16

Only the owner or members of the sysadmin role can alter table '%.*ls'.

4916 

16

Could not enable or disable the constraint. See previous errors.

4917 

16

Constraint '%.*ls' does not exist.

4920 

16

ALTER TABLE failed because trigger '%.*ls' on table '%.*ls' does not exist.

4921 

16

ALTER TABLE failed because trigger '%.*ls' does not belong to table '%.*ls'.

4922 

16

%ls %.*ls failed because %ls %.*ls accesses this column.

4923 

16

ALTER TABLE DROP COLUMN failed because '%.*ls' is the only data column in table '%.*ls'. A table must have at least one data column.

4924 

16

%ls failed because column '%.*ls' does not exist in table '%.*ls'.

4925 

16

ALTER TABLE ALTER COLUMN ADD ROWGUIDCOL failed because a column already exists in table '%.*ls' with ROWGUIDCOL property.

4926 

16

ALTER TABLE ALTER COLUMN DROP ROWGUIDCOL failed because a column does not exist in table '%.*ls' with ROWGUIDCOL property.

4927 

16

Cannot alter column '%.*ls' to be data type %.*ls.

4928 

16

Cannot alter column '%.*ls' because it is '%ls'.

4929 

16

Cannot alter the %S_MSG '%.*ls' because it is being published for replication.

4930 

10

Warning: Columns added to the replicated table %S_MSG '%.*ls' will be ignored by existing articles.

4931 

16

Cannot add columns to %S_MSG '%.*ls' because it is being published for merge replication.

Errors 5000 - 5999

Error

Severity

Description

5001 

16

User must be in the master database.

5002 

16

Database '%.*ls' does not exist. Check sysdatabases.

5004 

16

Database must be in state where it can be checkpointed to use ALTER DATABASE.

5005 

10

Extending database by %.2f MB on disk '%.*ls'.

5006 

16

Could not get exclusive use of %S_MSG '%.*ls' to perform the requested operation.

5008 

16

ALTER DATABASE option not implemented yet.

5009 

16

ALTER DATABASE failed. Some disk names listed in the statement were not found. Check that the names exist and are spelled correctly before rerunning the statement.

5011 

14

Only members of the sysadmin role or owner of database '%.*ls' can alter it.

5013

16

The master and model databases cannot have files added to them. ALTER DATABASE was aborted.

5014 

16

The %S_MSG '%.*ls' does not exist in database '%.*ls'.

5015 

16

ALTER DATABASE failed. The total size specified must be 1 MB or greater.

5017 

16

ALTER DATABASE failed. Database '%.*ls' was not created with 'FOR LOAD' option.

5018 

0

File '%.*ls' modified in sysaltfiles. Delete old file after restarting SQL Server.

5019 

16

Could not find entry in sysaltfiles for file '%.*ls'.

5020 

16

The primary data or log file cannot be removed from a database.

5021 

16

MAXSIZE cannot be larger than the maximum database size of %ld MB.

5022 

16

Log file '%ls' for this database is already active.

5023 

16

Database must be put in bypass recovery mode to rebuild the log.

5024 

16

No entry found for the primary log file in sysfiles1. Could not rebuild the log.

5025 

16

The file '%ls' already exists. It should be renamed or deleted so that a new log file can be created.

5026 

16

Could not create a new log file with file '%.*ls'. See previous errors.

5027 

16

System databases master, model, and tempdb cannot have their logs rebuilt.

5028 

16

The system could not activate enough of the database to rebuild the log.

5029 

10

Warning: The log for database '%.*ls' has been rebuilt. Transactional consistency has been lost. DBCC CHECKDB should be run to validate physical consistency. Database options will have to be reset, and extra log files may need to be deleted.

5030 

16

The database could not be exclusively locked to perform the operation.

5031 

16

Cannot remove the file '%.*ls' because it is the only file in the DEFAULT filegroup.

5035 

16

Filegroup '%.*ls' already exists in this database.

5036 

16

MODIFY FILE failed. Specify logical name.

5037 

16

MODIFY FILE failed. Do not specify physical name.

5038 

16

MODIFY FILE failed. Only modify one file and one property at a time.

5039 

16

MODIFY FILE failed. Specified size is less than current size.

5040 

16

MODIFY FILE failed. Size is greater than MAXSIZE.

5041 

16

MODIFY FILE failed. File '%.*ls' does not exist.

5042 

16

The %S_MSG '%.*ls' cannot be removed because it is not empty.

5043 

16

The %S_MSG '%.*ls' cannot be found in %ls.

5044 

10

The %S_MSG '%.*ls' has been removed.

5045 

16

The %S_MSG already has the '%ls' property set.

5046 

10

The %S_MSG property '%ls' has been set.

5047 

16

Cannot change the READONLY property of the PRIMARY filegroup.

5048 

16

Cannot %ls file in read-only filegroup '%.*ls'.

5049 

16

Cannot extend file '%ls' using this syntax as it was not created with DISK INIT. Use ALTER DATABASE MODIFY FILE.

5050 

16

Cannot change the properties of empty filegroup '%.*ls'. The filegroup must contain at least one file.

5051 

16

Cannot have a filegroup with the name 'DEFAULT'.

5053 

16

The maximum of %ld filegroups per database has been exceeded.

5054 

16

Could not cleanup worktable IAM chains to allow shrink or remove file operation. Please try again when tempdb is idle.

5055 

16

Cannot %ls read-only file '%.*ls'.

5101 

15

You must supply parameters for the DISK %hs statement. Usage: %hs.

5102 

15

No such statement DISK %.*ls.

5103 

16

MAXSIZE cannot be less than SIZE for file '%ls'.

5104 

16

File '%.*ls' already used.

5105 

16

Device activation error. The physical file name '%.*ls' may be incorrect.

5106 

15

Parameter '%hs' requires value of data type '%hs'.

5107 

15

Value is wrong data type for parameter '%hs' (requires data type '%hs').

5109 

16

No such parameter '%.*ls'.

5116 

14

Permission denied. Only members of the sysadmin role can run DISK statements.

5117 

16

Could not run DISK statement. You must be in the master database to run this statement.

5122 

10

Each disk file size must be greater than or equal to 1 MB.

5123 

16

CREATE FILE encountered operating system error %ls while attempting to open or create the physical file '%.*ls'.

5126 

16

The logical device '%.*ls' does not exist in sysdevices.

5146 

16

The %hs of %d is out of range. It must be between %d and %d.

5148 

16

Could not set the file size to the desired amount. The operating system file size limit may have been reached.

5149 

16

MODIFY FILE encountered operating system error %ls while attempting to expand the physical file.

5150 

16

The size of a single log file must not be greater than 2 TB.

5151 

16

The %hs statement is obsolete and no longer supported.

5154 

16

Device '%.*ls' is not open.

5156 

16

Usage: DBCC DEVCONTROL(devname,ONLINE|OFFLINE)

5157 

16

I/O error encountered in the writelog system function during backout.

5158 

10

Warning: Media in device '%.*ls' may have been changed.

5159 

16

Operating system error %.*ls on device '%.*ls' during %ls.

5160 

16

Cannot take '%.*ls' offline because the database is in use.

5162 

16

Cannot find '%.*ls' in sysdatabases.

5163 

16

Cannot open '%.*ls' to take offline.

5164 

16

Usage: DBCC DBCONTROL(dbname,ONLINE|OFFLINE)

5165 

16

Cannot explicitly open or close master database.

5167 

16

Database '%.*ls' is already offline.

5168 

16

File '%.*ls' is on a network drive, which is not allowed.

5169 

16

FILEGROWTH cannot be greater than MAXSIZE for file '%.*ls'.

5170 

16

Cannot create file '%ls' because it already exists.

5171 

16

%.*ls is not a primary database file.

5172 

16

The header for file '%ls' is not a valid database file header. The %ls property is incorrect.

5173 

16

Cannot associate files with different databases.

5174 

10

Each file size must be greater than or equal to 512 KB.

5175 

10

The file '%.*ls' has been expanded to prevent recovery from failing. Contact the system administrator for further assistance.

5176 

10

The file '%.*ls' has been expanded beyond its maximum size to prevent recovery from failing. Contact the system administrator for further assistance.

5177 

16

Encountered an unexpected error while checking the sector size for file '%.*ls'. Check the SQL Server error log for more information.

5178 

16

Cannot use file '%.*ls' because it was originally formatted with sector size %d and is now on a device with sector size %d.

5179 

16

Cannot use file '%.*ls', which is on a device with sector size %d. SQL Server supports a maximum sector size of 4096 bytes.

5180 

22

Could not open FCB for invalid file ID %d in database '%.*ls'. Table or database may be corrupted.

5181 

16

Could not restart database '%.*ls'. Reverting back to old status.

5701

10

Changed database context to '%.*ls'.

5702 

10

SQL Server is terminating this process.

5703 

10

Changed language setting to %.*ls.

5803 

10

Unknown config number (%d) in sysconfigures.

5805 

16

Too few locks specified. Minimum %d.

5807 

16

Recovery intervals above %d minutes not recommended. Use the RECONFIGURE WITH OVERRIDE statement to force this configuration.

5808

16

Ad hoc updates to system catalogs not recommended. Use the RECONFIGURE WITH OVERRIDE statement to force this configuration.

5809 

16

Average time slices above %d milliseconds not recommended. Use the RECONFIGURE WITH OVERRIDE statement to force this configuration.

5810 

16

Valid values for the fill factor are 0 to 100.

5812 

14

Permission denied. Only members of the sysadmin role can run RECONFIGURE.

5823 

16

Cannot reconfigure SQL Server to use sort order ID %d, because the row for that sort order does not exist in syscharsets.

5824 

16

Cannot reconfigure SQL Server to use sort order ID %d, because the row for its underlying character set (ID %d) does not exist in syscharsets.

5825 

16

Cannot reconfigure the server's sort order because the syscharsets table does not exist. You must upgrade your server prior to attempting this.

5826 

10

You have just reconfigured SQL Server's sort order. Table indexes on columns of type char or varchar will be rebuilt when SQL Server is restarted.

5827 

10

By changing the default sort order, you have also reconfigured SQL Server's default character set.

5828 

16

User connections are limited to %d.

5829 

16

The specified user options value is invalid.

5830 

10

You have just reconfigured SQL Server's Unicode collation. Table indexes on columns of type nchar or nvarchar will be rebuilt when SQL Server is restarted.

5831 

16

Minimum server memory value (%d) must be less than or equal to the maximum value (%d).

5904 

17

Background checkpoint process suspended until locks are available.

Errors 6000 - 6999

Error

Severity

Description

6001 

10

SHUTDOWN is waiting for %d process(es) to complete.

6002 

10

SHUTDOWN is in progress. Log off.

6004 

10

SHUTDOWN can only be used by members of the sysadmin role.

6005 

10

SHUTDOWN is in progress.

6006 

10

Server shut down by request.

6007 

10

The SHUTDOWN statement cannot be executed within a transaction or by a stored procedure.

6101 

16

Process ID %d is not a valid process ID. Choose a number between 1 and %d.

6102 

14

Only members of the sysadmin role can use the KILL statement.

6103

17

Could not do cleanup for the killed process. Received message %d.

6104 

16

Cannot use KILL to kill your own process.

6106 

16

Process ID %d is not an active process ID.

6107 

14

Only user processes can be killed.

6108 

16

KILL WITH COMMIT/ABORT can only be used with waiting distributed transactions.

6401 

16

Cannot roll back %.*ls. No transaction or savepoint of that name was found.

Errors 7000 - 7999

Error

Severity

Description

7102 

20

SQL Server Internal Error. Text manager cannot continue with current statement.

7105 

22

Page %S_PGID, slot %d for text, ntext, or image node does not exist.

7116 

25

Offset %d is not in the range of available text, ntext, or image data.

7122 

16

Invalid text, ntext, or image pointer type. Must be binary(16).

7123 

16

Invalid text, ntext, or image pointer value %hs.

7124 

16

The offset and length specified in the READTEXT statement is greater than the actual data length of %ld.

7125 

16

The text, ntext, or image pointer value conflicts with the column name specified.

7126 

16

The text, ntext, or image pointer value references a data page with an invalid text, ntext, or image status.

7127 

16

The text, ntext, or image pointer value references a data page with an invalid timestamp.

7128 

16

The text, ntext, or image pointer value references a data page that is no longer allocated.

7130

16

%ls WITH NO LOG is not valid at this time. Use sp_dboption to set the 'select into/bulkcopy' option on for database '%.*ls'.

7133 

16

NULL textptr (text, ntext, or image pointer) passed to %ls function.

7135 

16

Deletion length %ld is not in the range of available text, ntext, or image data.

7136 

16

%ls WITH NO LOG is not valid when the column is being replicated.

7139 

16

Length of text, ntext, or image data (%ld) to be replicated exceeds configured maximum %ld.

7140 

16

Text has been padded with 0 due to dirty read.

7141 

16

Must create orphaned text inside a user transaction.

7142 

16

Must drop orphaned text before committing the transaction.

7143 

16

Invalid locator de-referenced.

7201 

17

Could not execute procedure on remote server '%.*ls' because SQL Server is not configured for remote access. Ask your system administrator to reconfigure SQL Server to allow remote access.

7202 

11

Could not find server '%.*ls' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

7204 

20

Could not obtain or use interface %hs from Microsoft OLE DB provider for ODBC. Microsoft OLE DB provider for ODBC not registered. Remote procedures cannot be executed.

7212 

16

Could not execute procedure '%.*ls' on remote server '%.*ls'.

7213 

20

Could not set up parameter for remote server '%.*ls'.

7214 

16

Remote procedure time out of %d seconds exceeded. Remote procedure '%.*ls' is canceled.

7221 

16

Could not relay results of procedure '%.*ls' from remote server '%.*ls'.

7300 

16

OLE DB error trace [%ls].

7301 

16

Could not obtain a required interface from OLE DB provider '%ls'.

7302 

16

Could not create an instance of OLE DB provider '%ls'.

7303

16

Could not initialize data source object of OLE DB provider '%ls'. %ls

7304

16

Could not create a new session on OLE DB provider '%ls'.

7305 

16

Could not create a statement object using OLE DB provider '%ls'.

7306

16

Could not open table '%ls' from OLE DB provider '%ls'. %ls

7307 

16

Could not obtain the data source of a session from OLE DB provider '%ls'. This action must be supported by the provider.

7310 

16

Could not obtain the schema options for OLE DB provider '%ls'. The provider supports the interface, but returns a failure code when it is used.

7311 

16

Could not obtain the schema rowset for OLE DB provider '%ls'. The provider supports the interface, but returns a failure code when it is used.

7312 

16

Invalid use of schema and/or catalog for OLE DB provider '%ls'. A four-part name was supplied, but the provider does not expose the necessary interfaces to use a catalog and/or schema.

7313 

16

Invalid schema or catalog specified for provider '%ls'.

7314

16

OLE DB provider '%ls' does not contain table '%ls'.

7315 

16

OLE DB provider '%ls' contains multiple tables that match the name '%ls'.

7316 

16

Could not use qualified table names (schema or catalog) with OLE DB provider '%ls' because it does not implement required functionality.

7317 

16

OLE DB provider '%ls' returned an invalid schema definition.

7318 

16

OLE DB provider '%ls' returned an invalid column definition.

7319 

16

OLE DB provider '%ls' returned a '%ls' index '%ls' with incorrect bookmark ordinal %d.

7320 

16

Could not execute query against OLE DB provider '%ls'. %ls

7321

16

An error occurred while preparing a query for execution against OLE DB provider '%ls'. %ls

7322 

16

A failure occurred while giving parameter information to OLE DB provider '%ls'. %ls

7323 

16

An error occurred while submitting the query text to OLE DB provider '%ls'. %ls

7330 

16

Could not fetch a row from OLE DB provider '%ls'. %ls

7331 

16

Could not release a row from OLE DB provider '%ls'. %ls

7332 

16

Could not rescan the result set from OLE DB provider '%ls'. %ls

7333 

16

Could not fetch a row using a bookmark from OLE DB provider '%ls'. %ls

7340 

16

Could not create a column accessor for OLE DB provider '%ls'. %ls

7341 

16

Could not get the current row value of column '%ls.%ls' from the OLE DB provider '%ls'. %ls

7342 

16

Unexpected NULL value returned for column '%ls.%ls' from the OLE DB provider '%ls'. This column cannot be NULL.

7343 

16

OLE DB provider '%ls' could not %ls table '%ls'. %ls

7344 

16

OLE DB provider '%ls' could not %ls table '%ls' because of column '%ls'. %ls

7345 

16

OLE DB provider '%ls' could not delete from table '%ls'. %ls

7346 

16

Could not get the data of the row from the OLE DB provider '%ls'. %ls

7347 

16

OLE DB provider '%ls' returned an unexpected data length for the fixed-length column '%ls.%ls'. The expected data length is %ls, while the returned data length is %ls.

7348 

16

OLE DB provider '%ls' could not set range for table '%ls'.%ls

7349 

16

OLE DB provider '%ls' could not set range for table '%ls' because of column '%ls'.%ls

7350 

16

Could not get the column information from the OLE DB provider '%ls'.

7351 

16

OLE DB provider '%ls' could not map ordinals for one or more columns of object '%ls'.

7352 

16

OLE DB provider '%ls' supplied inconsistent metadata. The object '%ls' was missing expected column '%ls'.

7353 

16

OLE DB provider '%ls' supplied inconsistent metadata. An extra column was supplied during execution that was not found at compile time.

7354 

16

OLE DB provider '%ls' supplied invalid metadata for column '%ls'. %ls

7355 

16

OLE DB provider '%ls' supplied inconsistent metadata for a column. The name was changed at execution time.

7356

16

OLE DB provider '%ls' supplied inconsistent metadata for a column. Metadata information was changed at execution time.

7357

16

Could not process object '%ls'. The OLE DB provider '%ls' indicates that the object has no columns.

7358 

16

Could not execute query. The OLE DB provider '%ls' did not provide an appropriate interface to access the text, ntext, or image column '%ls.%ls'.

7360 

16

Could not get the length of a storage object from the OLE DB provider '%ls' for table '%ls', column '%ls'.

7361 

16

Could not read a storage object from the OLE DB provider '%ls', for table '%ls', column '%ls'.

7370 

16

One or more properties could not be set on the query for OLE DB provider '%ls'. %ls

7371 

16

One or more properties could not be set on the table for OLE DB provider '%ls'.

7373 

16

Could not set the initialization properties for the OLE DB provider '%ls'.

7375 

16

Could not open index '%ls' on table '%ls' from OLE DB provider '%ls'. %ls

7376 

16

Could not enforce the remote join hint for this query.

7390 

16

The requested operation could not be performed because the OLE DB provider '%ls' does not support the required transaction interface.

7391

16

The operation could not be performed because the OLE DB provider '%ls' does not support distributed transactions.

7392

16

Could not start a transaction for OLE DB provider '%ls'.

7393 

16

OLE DB provider '%ls' reported an error aborting the current transaction.

7394 

16

OLE DB provider '%ls' reported an error committing the current transaction.

7399

16

OLE DB provider '%ls' reported an error. %ls

7401 

16

Cannot create OLE DB provider enumeration object installed with SQL Server. Verify installation.

7403

16

Could not locate registry entry for OLE DB provider '%ls'.

7404 

16

The server could not load DCOM on startup (-O command-line used to force startup). Heterogeneous queries and remote RPC are disabled.

7405 

16

Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options to be set for the connection. This ensures consistent query semantics. Enable these options and then reissue your query.

7410 

16

Remote access not allowed for Windows NT user activated by SETUSER.

7411 

16

Server '%.*ls' is not configured for %ls.

7413

16

Could not perform a Windows NT authenticated login because delegation is not available.

7414 

16

Invalid number of parameters. Rowset '%ls' expects %d parameter(s).

7415 

16

Ad hoc access to OLE DB provider '%ls' has been denied. You must access this provider through a linked server.

7416 

16

Access to the remote server is denied because no login-mapping exists.

7417 

16

Remote tables are not allowed in GROUP BY ALL operations.

7601 

16

Cannot use a CONTAINS or FREETEXT predicate on %S_MSG '%.*ls' because it is not full-text indexed.

7602 

16

The Full-Text Service (Microsoft Search) is not available. The system administrator must start this service.

7603 

15

Syntax error in search condition '%ls'.

7604 

17

Full-text operation failed due to a time out.

7605 

17

Full-text catalog '%ls' has been lost. Use sp_fulltext_catalog to rebuild and to repopulate this full-text catalog.

7606 

17

Could not find full-text index for database ID %d, table ID %d. Use sp_fulltext_table to deactivate then activate this index.

7607 

17

Search on full-text catalog '%ls' for database ID %d, table ID %d with search condition '%ls' failed with unknown result (%x).

7608 

17

An unknown full-text failure (%x) occurred in function %hs on full-text catalog '%ls'.

7609 

17

Could not load the Full-Text Search component (SQLFTQRY.DLL).

7610 

16

Could not create full-text catalog because '%ls' is an invalid file path.

7611 

10

Warning: Request to start a population in full-text catalog '%ls' ignored because a crawl is currently active for this full-text catalog.

7612 

16

%d is not a valid value for full-text system resource usage.

7613 

16

Cannot drop index '%.*ls' because it enforces the full-text key for table '%.*ls'.

7614 

16

Cannot alter or drop column '%.*ls' because it is enabled for Full-Text Search.

7615 

16

A CONTAINS or FREETEXT predicate can only operate on one table. Qualify the use of * with a table name.

7616 

16

Full-Text Search is not enabled for the current database. Use sp_fulltext_database to enable full-text search for the database.

7617 

16

Query does not reference the fulltext indexed table.

7618 

16

%d is not a valid value for a full-text connection time out.

7619

16

The requested catalog is disabled on the Search server.

7620 

16

Conversion to data type %ls failed for full-text search key value 0x%ls.

7621 

16

Invalid use of full-text predicate in the HAVING clause.

7622 

17

Full-text catalog '%ls' lacks sufficient disk space to complete this operation.

7623 

17

Full-text query failed because full-text catalog '%ls' is not yet ready for queries.

7624 

17

Full-text catalog '%ls' is in a unusable state. Drop and re-create this full-text catalog.

7908 

10

The table '%.*ls' was created with the NO_LOG option.

7909 

10

A transaction involving the NO_LOG table '%.*ls' was undone. This may have left the table in an inconsistent state. Rebuild the table.

7910 

10

Repair: Page %S_PGID has been allocated to object ID %d, index ID %d.

7911 

10

Repair: Page %S_PGID has been deallocated from object ID %d, index ID %d.

7912 

10

Repair: Extent %S_PGID has been allocated to object ID %d, index ID %d.

7913 

10

Repair: Extent %S_PGID has been deallocated from object ID %d, index ID %d.

7914 

10

Repair: %ls page at %S_PGID has been rebuilt.

7915 

10

Repair: IAM chain for object ID %d, index ID %d, has been truncated before page %S_PGID and will be rebuilt.

7916 

10

Repair: Deleted record for object ID %d, index ID %d, on page %S_PGID, slot %d. Indexes will be rebuilt.

7917 

10

Repair: Converted forwarded record for object ID %d, index ID %d, at page %S_PGID, slot %d to a data row.

7918 

10

Repair: Page %S_PGID next and %S_PGID previous pointers have been set to match each other in object ID %d, index ID %d.

7919 

16

Repair statement not processed. Database needs to be in single user mode.

7920 

10

Processed %ld entries in sysindexes for database ID %d.

7922 

16

***************************************************************

7923 

10

Table %.*ls Object ID %ld.

7924 

10

Index ID %ld FirstIAM %S_PGID Root %S_PGID Dpages %ld Sort %d.

7925 

16

Index ID %d. %ld index pages in %ld extents.

7926 

16

Data level %d. %ld data pages in %ld extents.

7927 

16

Total number of extents is %ld.

7932 

16

The indexes for '%.*ls' are already correct. They will not be rebuilt.

7933 

16

One or more indexes are corrupt. They will be rebuilt.

7934 

16

The table '%.*ls' has no indexes.

7935 

16

REINDEX received an exception. Statement terminated.

7937 

16

The data in table '%.*ls' is possibly corrupt. REINDEX terminated. Run DBCC CHECKTABLE and report errors to your system administrator.

7939 

16

Cannot detach database '%.*ls' because it does not exist.

7940 

16

System databases master, model, and tempdb cannot be detached.

7941 

10

Trace option(s) not enabled for this connection. Use 'DBCC TRACEON()'.

7942 

10

DBCC %ls scanning '%.*ls' table...

7943 

10

Table: '%.*ls' (%d); index ID: %d, database ID: %d

7944 

10

%ls level scan performed.

7945 

10

- Pages Scanned................................: %lu

7946 

10

- Extents Scanned..............................: %lu

7947 

10

- Extent Switches..............................: %lu

7948 

10

- Avg. Pages per Extent........................: %3.1f

7949 

10

- Scan Density [Best Count:Actual Count].......: %4.2f%ls [%lu:%lu]

7950 

10

- Logical Scan Fragmentation ..................: %4.2f%ls

7951 

10

- Physical Scan Fragmentation .................: %4.2f%ls

7952 

10

- Extent Scan Fragmentation ...................: %4.2f%ls

7953 

10

- Avg. Bytes Free per Page.....................: %3.1f

7954 

10

- Avg. Page Density (full).....................: %4.2f%ls

7955 

10

Invalid SPID %d specified.

7956 

10

Permission to execute DBCC %ls denied.

7957 

10

Cannot display the specified SPID's buffer; in transition.

7958 

10

The specified SPID does not process input/output data streams.

7959 

10

The DBCC statement is not supported in this release.

7962 

16

Upgrade requires SQL Server to be started in single user mode. Restart SQL Server with the -m flag.

7963 

16

Upgrade encountered a fatal error. See the SQL Server errorlog for more information.

7965 

16

Table corrupt: Could not check object ID %d, index ID %d due to invalid allocation (IAM) page(s).

7966 

10

Warning: NO_INDEX option of %ls being used. Checks on non-system indexes will be skipped.

7968 

10

Transaction information for database '%.*ls'.

7969 

10

No active open transactions.

7970 

10

%hsOldest active transaction:

7971 

10

SPID (server process ID) : %d

7972 

10

UID (user ID) : %d

7974 

10

Name : %.*ls

7975 

10

LSN : (%d:%d:%d)

7977 

10

Start time : %.*ls

7979 

10

%hsReplicated Transaction Information:

7980 

10

Oldest distributed LSN : (%d:%d:%d)

7982 

10

Oldest non-distributed LSN : (%d:%d:%d)

7983 

14

Only the owner of database '%.*ls' can run the DBCC %ls statement.

7984 

16

Invalid object name '%.*ls'.

7985 

16

The object name '%.*ls' contains more than the maximum number of prefixes. The maximum is %d.

7986 

16

Warning: Pinning tables should be carefully considered. If a pinned table is larger, or grows larger, than the available data cache, the server may need to be restarted and the table unpinned.

7991 

16

System table mismatch: Table '%.*ls', object ID %d has index ID 1 in sysindexes but the status in sysobjects does not have the clustered bit set. The table will be checked as a heap.

7992 

16

Cannot shrink 'read only' database '%.*ls'

7993 

10

Cannot shrink file '%d' in database '%.*ls' to %d pages as it only contains %d pages.

7994 

16

Object ID %d, index ID %d: FirstIAM field in sysindexes is %S_PGID. FirstIAM for statistics only and dummy index entries should be (0:0).

7995 

16

Database '%ls' consistency errors in sysobjects, sysindexes, syscolumns, or systypes prevent further %ls processing.

7996 

16

Extended stored procedures can only be created in the master database.

7997 

16

'%.*ls' does not contain an identity column.

7998 

16

Checking identity information: current identity value '%.*hs', current column value '%.*hs'.

7999 

16

Could not find any index named '%.*ls' for table '%.*ls'.

Errors 8000 - 8999

Error

Severity

Description

8101

16

An explicit value for the identity column in table '%.*ls' can only be specified when a column list is used and IDENTITY_INSERT is ON.

8102

16

Cannot update identity column '%.*ls'.

8103 

16

Table '%.*ls' does not exist or cannot be opened for SET operation.

8104 

16

The current user is not the database or object owner of table '%.*ls'. Cannot perform SET operation.

8105 

16

'%.*ls' is not a user table. Cannot perform SET operation.

8106

16

Table '%.*ls' does not have the identity property. Cannot perform SET operation.

8107 

16

IDENTITY_INSERT is already ON for table '%.*ls.%.*ls.%.*ls'. Cannot perform SET operation for table '%.*ls'.

8108 

16

Cannot add identity column, using the SELECT INTO statement, to table '%.*ls', which already has column '%.*ls' that inherits the identity property.

8109 

16

Attempting to add multiple identity columns to table '%.*ls' using the SELECT INTO statement.

8110 

16

Cannot add multiple PRIMARY KEY constraints to table '%.*ls'.

8111 

16

Cannot define PRIMARY KEY constraint on nullable column in table '%.*ls'.

8112 

16

Cannot add more than one clustered index for constraints on table '%.*ls'.

8114

16

Error converting data type %ls to %ls.

8115 

16

Arithmetic overflow error converting %ls to data type %ls.

8116 

16

Argument data type %ls is invalid for argument %d of %ls function.

8117 

16

Operand data type %ls is invalid for %ls operator.

8118 

16

Column '%.*ls.%.*ls' is invalid in the select list because it is not contained in an aggregate function and there is no GROUP BY clause.

8119 

16

Column '%.*ls.%.*ls' is invalid in the HAVING clause because it is not contained in an aggregate function and there is no GROUP BY clause.

8120 

16

Column '%.*ls.%.*ls' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

8121 

16

Column '%.*ls.%.*ls' is invalid in the HAVING clause because it is not contained in either an aggregate function or the GROUP BY clause.

8122 

16

Only the first query in a UNION statement can have a SELECT with an assignment.

8123 

16

A correlated expression is invalid because it is not in a GROUP BY clause.

8124 

16

Multiple columns are specified in an aggregated expression containing an outer reference. If an expression being aggregated contains an outer reference, then that outer reference must be the only column referenced in the expression.

8125 

16

An aggregated expression containing an outer reference must be contained in either the select list, or a HAVING clause subquery in the query whose FROM clause contains the table with the column being aggregated.

8126 

16

Column name '%.*ls.%.*ls' is invalid in the ORDER BY clause because it is not contained in an aggregate function and there is no GROUP BY clause.

8127 

16

Column name '%.*ls.%.*ls' is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.

8128 

10

Using '%s' version '%s' to execute extended stored procedure '%s'.

8129 

16

The new disk size must be greater than %d. Consider using DBCC SHRINKDB.

8130 

16

The device is not a database device. Only database devices can be expanded.

8131 

10

Extended stored procedure DLL '%s' does not export __GetXpVersion(). Refer to the topic "Backward Compatibility Details (Level 1) - Open Data Services" in the documentation for more information.

8132 

10

Extended stored procedure DLL '%s' reports its version is %d.%d. Server expects version %d.%d.

8133 

16

None of the result expressions in a CASE specification can be NULL.

8134 

16

Divide by zero error encountered.

8135 

16

Table level constraint does not specify column list, table '%.*ls'.

8136 

16

Duplicate columns specified in %ls constraint key list, table '%.*ls'.

8138 

16

More than 16 columns specified in foreign key column list, table '%.*ls'.

8139 

16

Number of referencing columns in foreign key differs from number of referenced columns, table '%.*ls'.

8140 

16

More than one key specified in column level %ls constraint, table '%.*ls'.

8141 

16

Column %ls constraint for column '%.*ls' references another column, table '%.*ls'.

8142 

16

Subqueries are not supported in %ls constraints, table '%.*ls'.

8143 

16

Parameter '%.*ls' was supplied multiple times.

8144 

16

Too many arguments were supplied for procedure %.*ls.

8145 

16

%.*ls is not a parameter for procedure %.*ls.

8146 

16

Procedure %.*ls has no parameters and arguments were supplied.

8147 

16

Could not create IDENTITY attribute on nullable column '%.*ls', table '%.*ls'.

8148 

16

More than one column %ls constraint specified for column '%.*ls', table '%.*ls'.

8150 

16

Multiple NULL constraints were specified for column '%.*ls', table '%.*ls'.

8151 

16

Both a PRIMARY KEY and UNIQUE constraint have been defined for column '%.*ls', table '%.*ls'. Only one is allowed.

8152 

16

String or binary data would be truncated.

8153 

0

Warning: Null value eliminated from aggregate.

8154 

15

The table '%.*ls' is ambiguous.

8155 

15

No column was specified for column %d of '%.*ls'.

8156 

15

The column '%.*ls' was specified multiple times for '%.*ls'.

8157 

15

All the queries in a query expression containing a UNION operator must have the same number of expressions in their select lists.

8158 

15

'%.*ls' has more columns than were specified in the column list.

8159 

15

'%.*ls' has fewer columns than were specified in the column list.

8160 

15

A grouping function can only be specified when either CUBE or ROLLUP is specified in the GROUP BY clause.

8161 

15

A grouping function argument does not match any of the expressions in the GROUP BY clause.

8162 

16

Formal parameter '%.*ls' was defined as OUTPUT but the actual parameter not declared OUTPUT.

8163

16

The text, ntext, or image data type cannot be selected as DISTINCT.

8164 

16

An INSERT EXEC statement cannot be nested.

8166 

16

Constraint name '%.*ls' not permitted. Constraint names cannot begin with a number sign (#).

8168 

16

Cannot create two constraints named '%.*ls'. Duplicate constraint names are not allowed.

8169 

16

Syntax error converting from a character string to uniqueidentifier.

8170 

16

Insufficient result space to convert uniqueidentifier value to char.

8175 

10

Could not find table %.*ls. Will try to resolve this table name later.

8177 

16

Cannot use a column in the %hs clause unless it is contained in either an aggregate function or the GROUP BY clause.

8178 

16

Prepared statement '%.*ls' expects parameter %.*ls, which was not supplied.

8179 

16

Could not find prepared statement with handle %d.

8180 

16

Statement(s) could not be prepared.

8181 

16

Text for '%.*ls' is missing from syscomments. The object must be dropped and re-created before it can be used.

8190 

16

Cannot compile replication filter procedure without defining table being filtered.

8191 

16

Replication filter procedures can only contain SELECT, GOTO, IF, WHILE, RETURN, and DECLARE statements.

8192 

16

Replication filter procedures cannot have parameters.

8193 

16

Cannot execute a procedure marked FOR REPLICATION.

8194 

16

Cannot execute a USE statement while an application role is active.

8196 

16

Duplicate column specified as ROWGUIDCOL.

8197 

16

Windows NT user '%.*ls' does not have server access.

8198 

16

Could not obtain information about Windows NT group/user '%ls'.

8199 

16

In EXECUTE <procname>, procname can only be a literal or variable of type char, varchar, nchar, or nvarchar.

8501

16

MSDTC on server '%.*ls' is unavailable.

8502 

20

Unknown MSDTC token '0x%x' received.

8504 

20

Invalid transaction import buffer.

8506 

20

Invalid transaction state change requested from %hs to %hs.

8508 

20

QueryInterface failed for '%hs': %hs.

8509 

20

Import of MSDTC transaction failed: %hs.

8510 

20

Enlist of MSDTC transaction failed: %hs.

8511 

20

Unknown isolation level %d requested from MSDTC.

8512 

20

MSDTC Commit acknowledgement failed: %hs.

8513 

20

MSDTC Abort acknowledgement failed: %hs.

8514 

20

MSDTC PREPARE acknowledgement failed: %hs.

8515 

20

MSDTC Global state is invalid.

8517 

20

Failed to get MSDTC PREPARE information: %hs.

8518 

20

MSDTC BEGIN TRANSACTION failed: %hs.

8519 

16

Current MSDTC transaction must be committed by remote client.

8520 

20

Commit of internal MSDTC transaction failed: %hs.

8521 

20

Invalid awakening state. Slept in %hs; awoke in %hs.

8522 

20

Distributed transaction aborted by MSDTC.

8523 

15

PREPARE TRAN statement not allowed on MSDTC transaction.

8524 

16

The current transaction could not be exported to the remote provider. It has been rolled back.

8601 

17

Internal Query Processor Error: The query processor could not obtain access to a required interface.

8602 

16

The Index Tuning Wizard cannot process queries which contain index hints. Remove the index hints which reference table '%.*ls'.

8616 

10

The index hints for table '%.*ls' were ignored because the table was considered a fact table in the star join.

8617 

17

Invalid Query: CUBE and ROLLUP cannot compute distinct aggregates.

8618 

17

Warning: The query processor could not produce a query plan from the optimizer because the total length of all the columns in the GROUP BY clause exceeds 8000 bytes.

8619 

17

Warning: The query processor could not produce a query plan from the optimizer because the maximum row size of an intermediate result was too large to fit into a work table. Resubmit your query without the ROBUST PLAN hint.

8620 

17

Internal Query Processor Error: The query processor encountered an internal limit overflow.

8621 

16

Internal Query Processor Error: The query processor ran out of stack space during query optimization.

8622 

16

Query processor could not produce a query plan because of the hints defined in this query. Resubmit the query without specifying any hints and without using SET FORCEPLAN.

8623 

16

Internal Query Processor Error: The query processor could not produce a query plan.

8624 

16

Internal SQL Server error.

8625 

16

Warning: The join order has been enforced because a local join hint is used.

8626 

16

Only text pointers are allowed in work tables, never text, ntext, or image columns. The query processor produced a query plan that required a text, ntext, or image column in a work table.

8627 

16

The query processor could not produce a query plan because of the combination of hints and text, ntext, or image data passing through operators using work tables.

8628 

17

A time out occurred while waiting to optimize the query. Rerun the query.

8629 

16

The query processor could not produce a query plan from the optimizer because a query cannot update a text, ntext, or image column and a clustering key at the same time.

8630 

17

Internal Query Processor Error: The query processor encountered an unexpected error during execution.

8640 

17

Internal Query Processor Error: The query processor encountered an unexpected work table error during execution.

8642 

17

The query processor could not start the necessary thread resources for parallel query execution.

8644 

16

Internal Query Processor Error: The plan selected for execution does not support the invoked given execution routine.

8645

17

A time out occurred while waiting for memory resources to execute the query. Rerun the query.

8646 

21

The index entry for row ID %.*hs was not found in index ID %d, of table %d, in database '%.*ls'.

8647 

20

Scan on sysindexes for database ID %d, object ID %ld, returned a duplicate index ID %d. Run DBCC CHECKTABLE on sysindexes.

8648 

20

Could not insert a row larger than the page size into a hash table. Resubmit the query with the ROBUSTPLAN hint.

8649 

17

The query has been canceled because the estimated cost of this query (%d) exceeds the configured threshold of %d. Contact the system administrator.

8650 

13

Intra-query parallelism caused your server command (process ID #%d) to deadlock. Rerun the query without intra-query parallelism by using the query hint option (maxdop 1).

8651

17

Could not perform the requested operation because the minimum query memory is not available. Decrease the configured value for the 'min memory per query' server configuration option.

8680 

17

Internal Query Processor Error: The query processor encountered an unexpected error during the processing of a remote query phase.

8901 

13

Deadlock detected during DBCC. Complete the transaction in progress and retry this statement.

8902 

17

Memory allocation error during DBCC processing.

8903 

16

Extent %S_PGID in database ID %d is allocated in both GAM %S_PGID and SGAM %S_PGID.

8904 

16

Extent %S_PGID in database ID %d is allocated by more than one allocation object.

8905 

16

Extent %S_PGID in database ID %d is marked allocated in the GAM, but no SGAM or IAM has allocated it.

8906

16

Page %S_PGID in database ID %d is allocated in the SGAM %S_PGID and PFS %S_PGID, but was not allocated in any IAM. PFS flags '%hs'.

8907 

16

Mixed extent %S_PGID in database ID %d has %d free pages. It should be included in the SGAM %S_PGID.

8908

16

Table Corrupt: Database ID %d, object ID %d, index ID %d. Chain linkage mismatch. %S_PGID->next = %S_PGID, but %S_PGID->prev = %S_PGID.

8909 

16

Table Corrupt: Object ID %d, index ID %d, page ID %S_PGID. The PageId in the page header = %S_PGID.

8910 

16

Page %S_PGID in database ID %d is allocated to both object ID %d, index ID %d, and object ID %d, index ID %d.

8911 

10

The error has been repaired.

8912 

10

%.*ls fixed %d allocation errors and %d consistency errors in database '%ls'.

8913 

16

Extent %S_PGID is allocated to '%ls' and at least one other object.

8914 

10

Incorrect PFS free space information for page %S_PGID, object ID %d, index ID %d, in database ID %d. Expected value %hs, actual value %hs.

8915 

10

%S_PGID (number of mixed extents = %ld, mixed pages = %ld).

8916 

10

Object ID %ld, Index ID %ld, data extents %ld, pages %ld, mixed extent pages %ld.

8917 

10

Object ID %ld, Index ID %ld, index extents %ld, pages %ld, mixed extent pages %ld.

8918 

10

(number of mixed extents = %ld, mixed pages = %ld) in this database.

8919 

16

Single page allocation %S_PGID in table %ls, object ID %d, index ID %d is not allocated in PFS page ID %S_PGID.

8920 

16

Cannot perform a %ls operation inside a user transaction. Terminate the transaction and reissue the statement.

8921 

16

CHECKTABLE terminated. A failure was detected while collecting facts. Possibly tempdb out of space or a system table is corrupt. Check previous errors.

8922 

10

Could not repair this error.

8923 

10

The repair level on the DBCC statement caused this repair to be bypassed.

8924 

10

Repairing this error requires other errors to be corrected
first.

8925

16

Table Corrupt: Cross object linkage: Page %S_PGID, slot %d, in object ID %d, index ID %d, refers to page %S_PGID, slot %d, in object ID %d, index ID %d.

8926 

16

Table Corrupt: Cross object linkage: Parent page %S_PGID, slot %d, in object ID %d, index ID %d, and page %S_PGID, slot %d, in object ID %d, index ID %d, next refer to page %S_PGID but are not in the same object.

8927 

16

Object ID %d, index ID %d: The ghosted record count (%d) in the header does not match the number of ghosted records (%d) found on page %S_PGID.

8928 

16

Object ID %d, index ID %d: Page %S_PGID could not be processed. See other errors for details.

8929 

16

Object ID %d: Errors found in text ID %I64d owned by data record identified by %.*ls.

8930 

16

Table Corrupt: Object ID %d, index ID %d cross-object chain linkage. Page %S_PGID points to %S_PGID in object ID %d, index ID %d.

8931 

16

Table Corrupt: Object ID %d, index ID %d B-tree level mismatch, page %S_PGID. Level %d does not match level %d from parent %S_PGID or previous %S_PGID.

8932 

16

Table Corrupt: Object ID %d, index ID %d, column '%.*ls'. The column ID %d is not valid for this table. The valid range is from 1 to %d. System table corruption.

8933 

16

Table Corrupt: Object ID %d, index ID %d. The low key value on page %S_PGID (level %d) is not %ls the key value in the parent %S_PGID slot %d.

8934 

16

Table Corrupt: Object ID %d, index ID %d. The high key value on page %S_PGID (level %d) is not less than the low key value in the parent %S_PGID, slot %d of the next page %S_PGID.

8935 

16

Table Corrupt: Object ID %d, index ID %d. The previous link %S_PGID on page %S_PGID does not match the previous page %S_PGID that the parent %S_PGID, slot %d expects for this page.

8936 

16

Table Corrupt: Object ID %d, index ID %d. B-tree chain linkage mismatch. %S_PGID->next = %S_PGID, but %S_PGID->Prev = %S_PGID.

8937 

16

Table Corrupt: Object ID %d, index ID %d. B-tree page %S_PGID has two parent nodes %S_PGID, slot %d and %S_PGID, slot %d.

8938 

16

Table Corrupt: Page %S_PGID corrupt. Object ID %d, index ID %d. Unexpected page type %d.

8939 

16

Table Corrupt: Object ID %d, index ID %d, page %S_PGID. Test (%hs) failed. Values are %ld and %ld.

8940 

16

Table Corrupt: Object ID %d, index ID %d, page %S_PGID. Test (%hs) failed. Address 0x%x is not aligned.

8941 

16

Table Corrupt: Object ID %d, index ID %d, page %S_PGID. Test (%hs) failed. Slot %d, offset 0x%x is invalid.

8942 

16

Table Corrupt: Object ID %d, index ID %d, page %S_PGID. Test (%hs) failed. Slot %d, offset 0x%x overlaps with the prior row.

8943 

16

Table Corrupt: Object ID %d, index ID %d, page %S_PGID. Test (%hs) failed. Slot %d, row extends into freespace at 0x%x.

8944 

16

Table Corrupt: Object ID %d, index ID %d, page %S_PGID, row %d. Test (%hs) failed. Values are %ld and %ld.

8945 

16

Table Corrupt: Object ID %d, index ID %d will be rebuilt.

8946 

16

Table Corrupt: Allocation page %S_PGID has invalid %ls page header values. Type is %d. Check type, object ID and page ID on the page.

8947 

16

Table Corrupt: Multiple IAM pages for object ID %d, index ID %d contain allocations for the same interval. IAM pages %S_PGID and %S_PGID.

8948 

16

Database Corrupt: Page %S_PGID is marked with the wrong type in PFS page %S_PGID. PFS status 0x%x expected 0x%x.

8949 

10

%.*ls fixed %d allocation errors and %d consistency errors in table '%ls' (object ID %d).

8950 

16

%.*ls fixed %d allocation errors and %d consistency errors not associated with any single object.

8951 

16

Table Corrupt: Table '%ls' (ID %d). Missing or invalid key in index '%ls' (ID %d) for the row:

8952

16

Table Corrupt: Database '%ls', index '%ls.%ls' (ID %d) (index ID %d). Extra or invalid key for the keys:

8953 

10

Repair: Deleted text column, text ID %I64d, for object ID %d on page %S_PGID, slot %d.

8954 

10

%.*ls found %d allocation errors and %d consistency errors not associated with any single object.

8955 

16

Data row (%d:%d:%d) identified by (%ls) has index values (%ls).

8956

16

Index row (%d:%d:%d) with values (%ls) points to the data row identified by (%ls).

8957 

10

DBCC %ls (%ls%ls%ls) executed by %ls found %d errors and repaired %d errors.

8958 

10

%ls is the minimum repair level for the errors found by DBCC %ls (%ls %ls).

8959 

16

Table Corrupt: IAM page %S_PGID for object ID %d, index ID %d is linked in the IAM chain for object ID %d, index ID %d by page %S_PGID.

8960 

23

Table Corrupt: Page %S_PGID, slot %d, column %d is not a valid complex column.

8961 

23

Table Corrupt: Object ID %d. The text, ntext, or image node at page %S_PGID, slot %d, text ID %I64d does not match its reference from page %S_PGID, slot %d.

8963 

23

Table Corrupt: The text, ntext, or image node at page %S_PGID, slot %d, text ID %I64d has type %d. It cannot be placed on a page of type %d.

8964 

23

Table Corrupt: Object ID %d. The text, ntext, or image node at page %S_PGID, slot %d, text ID %I64d is not referenced.

8965 

23

Table Corrupt: Object ID %d. The text, ntext, or image node at page %S_PGID, slot %d, text ID %I64d is referenced by page %S_PGID, slot %d, but was not seen in the scan.

8966 

22

Could not read and latch page %S_PGID with latch type %ls. %ls failed.

8967 

16

Table Corrupt: Invalid value detected in %ls for Object ID %d, index ID %d. Row skipped.

8968 

16

Table Corrupt: %ls page %S_PGID (object ID %d, index ID %d) is out of the range of this database.

8969 

16

Table Corrupt: IAM chain linkage error: Object ID %d, index ID %d. The next page for IAM page %S_PGID is %S_PGID, but the previous link for page %S_PGID is %S_PGID.

8970 

16

Row corrupt: Object ID %d, index ID %d, page ID %S_PGID, row ID %d. Column '%.*ls' was created NOT NULL, but is NULL in the row.

8971 

16

Forwarded row mismatch: Object ID %d, page %S_PGID, slot %d points to forwarded row page %S_PGID, slot %d; the forwarded row points back to page %S_PGID, slot %d.

8972 

16

Forwarded row referenced by more than one row. Object ID %d, page %d, slot %d incorrectly points to forwarded row page %S_PGID, slot %d; the forwarded row correctly refers back to page %S_PGID, slot %d.

8973 

16

CHECKTABLE processing of object ID %d, index ID %d encountered page %S_PGID, slot %d twice. Possible internal error or allocation fault.

8974 

16

Text node referenced by more than one node. Object ID %d, text, ntext, or image node page %S_PGID, slot %d, text ID %I64d is pointed to by page %S_PGID, slot %d and by page %S_PGID, slot %d.

8975 

16

Page referenced by more than one page: Object ID %d, index ID %d. Page %S_PGID->next is an unmatched linkage to page %S_PGID. %S_PGID->next matches the previous linkage of the page.

8976

16

Table Corrupt: Object ID %d, index ID %d. Page %S_PGID not allocated or corrupt. Parent %S_PGID and previous %S_PGID refer to it.

8977 

16

Table Corrupt: Object ID %d, index ID %d. Parent node for page %S_PGID was not encountered.

8978 

16

Table Corrupt: Object ID %d, index ID %d. Page %S_PGID is missing a reference from previous page %S_PGID. Possible chain linkage problem.

8979 

16

Table Corrupt: Object ID %d, index ID %d. Page %S_PGID is missing references from parent (unknown) and previous (page %S_PGID) nodes. Possible bad root entry in sysindexes.

8980 

16

Table Corrupt: Object ID %d, index ID %d. Index node page %S_PGID, slot %d refers to child page %S_PGID and previous child %S_PGID, but they were not encountered.

8981 

16

Table Corrupt: Object ID %d, index ID %d. The next pointer of %S_PGID refers to page %S_PGID. Neither %S_PGID nor its parent were encountered. Possible bad chain linkage.

8982 

16

Table Corrupt: Cross object linkage. Page %S_PGID->next in object ID %d, index ID %d refers to page %S_PGID in object ID %d, index ID %d but is not in the same index.

8983 

10

Allocation page %S_PGID. Extents %d, used pages %d, referenced pages %d, mixed extents %d, mixed pages %d.

8984 

10

Object ID %d, index ID %d. Allocations for %S_PGID. IAM %S_PGID, extents %d, used pages %d, mixed pages %d.

8985 

16

Could not locate file '%.*ls' in sysfiles.

8986 

16

Too many errors found (%d) for object ID %d. To see all error messages rerun the statement using "WITH ALL_ERRORMSGS".

8987 

16

No help available for DBCC statement '%.*ls'.

8988 

10

The schema for database '%ls' is changing. May find spurious allocation problems due to schema changes in progress.

8989 

10

%.*ls found %d allocation errors and %d consistency errors in database '%ls'.

8990 

10

%.*ls found %d allocation errors and %d consistency errors in table '%ls' (object ID %d).

8991 

16

0x%.8x + 0x%.8x bytes is not a valid address range.

8992 

16

Database ID %d, object '%ls' (ID %d). Loop in data chain detected at %S_PGID.

8993 

16

Object ID %d, forwarding row page %S_PGID, slot %d points to page %S_PGID, slot %d. Did not encounter forwarded row. Possible allocation error.

8994 

16

Object ID %d, forwarded row page %S_PGID, slot %d should be pointed to by forwarding row page %S_PGID, slot %d. Did not encounter forwarding row. Possible allocation error.

8995 

16

System table '%.*ls' (object ID %d, index ID %d) is in filegroup %d. All system tables must be in filegroup %d.

8996 

16

IAM page %S_PGID for object ID %d, index ID %d controls pages in filegroup %d, that should be in filegroup %d.

8997 

16

Single page allocation %S_PGID for object ID %d, index ID %d is in filegroup %d; it should be in filegroup %d.

8998 

16

Page corruptions on the GAM, SGAM, or PFS pages do not allow CHECKALLOC to verify database ID %d pages from %S_PGID to %S_PGID. See other errors for cause.

8999 

10

Database tempdb allocation errors prevent further %ls processing.

Errors 9000 - 9999

Error

Severity

Description

9001 

10

The log for database '%.*ls' is not available.

9002

19

The log file for database '%.*ls' is full. Back up the transaction log for the database to free up some log space.

9003 

20

The LSN %S_LSN passed to log scan in database '%.*ls' is invalid.

9004 

21

The log for database '%.*ls' is corrupt.

Errors 10000 - 10999

Error

Severity

Description

10000

16

Unknown provider error.

10001

16

The provider reported an unexpected catastrophic failure.

10002

16

The provider did not implement the functionality.

10003

16

The provider ran out of memory.

10004

16

One or more arguments were reported invalid by the provider.

10005

16

The provider did not support an interface.

10006

16

The provider indicated an invalid pointer was used.

10007

16

The provider indicated an invalid handle was used.

10008 (DB-Library)

16

The provider terminated the operation.

10009

16

The provider did not give any information about the error.

10010

16

The data necessary to complete this operation was not yet available to the provider.

10021

16

Execution terminated by the provider because a resource limit was reached.

10022

16

The provider called a method from IRowsetNotify in the consumer, and the method has not yet returned.

10023

16

The provider does not support the necessary method.

10024 (DB-Library)

16

The provider indicates that the user did not have the permission to perform the operation.

10031

16

An error occurred because one or more properties could not be set.

10032

16

Cannot return multiple result sets (not supported by the provider).

10033

16

The specified index does not exist or the provider does not support an index scan on this data source.

10034

16

The specified table does not exist.

10035

16

No value was given for one or more of the required parameters.

10041

16

Could not set any property values.

10042

16

Cannot set any properties while there is an open rowset.

10051

16

An error occurred while setting the data.

10052

16

The insertion was canceled by the provider during notification.

10053 (DB-Library)

16

Could not convert the data value due to reasons other than sign mismatch or overflow.

10054 (DB-Library)

16

The data value for one or more columns overflowed the type used by the provider.

10055

16

The data violated the integrity constraints for one or more columns.

10056

16

The number of rows that have pending changes has exceeded the limit specified by the DBPROP_MAXPENDINGROWS property.

10057

16

Cannot create the row. Would exceed the total number of active rows supported by the rowset.

10058

16

The consumer cannot insert a new row before releasing previously-retrieved row handles.

10061

16

An error occurred while setting data for one or more columns.

10062

16

The change was canceled by the provider during notification.

10063

16

Could not convert the data value due to reasons other than sign mismatch or overflow.

10064

16

The data value for one or more columns overflowed the type used by the provider.

10065

16

The data violated the integrity constraints for one or more columns.

10066

16

The number of rows that have pending changes has exceeded the limit specified by the DBPROP_MAXPENDINGROWS property.

10067

16

The rowset was using optimistic concurrency and the value of a column has been changed after the containing row was last fetched or resynchronized.

10068

16

The consumer could not delete the row. A deletion is pending or has already been transmitted to the data source.

10069

16

The consumer could not delete the row. The insertion has been transmitted to the data source.

10075

16

An error occurred while deleting the row.

10081

16

The rowset uses integrated indexes and there is no current index.

10085

16

RestartPosition on the table was canceled during notification.

10086

16

The table was built over a live data stream and the position cannot be restarted.

10087

16

The provider did not release some of the existing rows.

10088

16

The order of the columns was not specified in the object that created the rowset. The provider had to reexecute the command to reposition the next fetch position to its initial position, and the order of the columns changed.

Errors 11000 - 11999

Error

Severity

Description

11000

16

Unknown status code for this column.

11001

16

Non-NULL value successfully returned.

11002

16

Deferred accessor validation occurred. Invalid binding for this column.

11003

16

Could not convert the data value due to reasons other than sign mismatch or overflow.

11004

16

Successfully returned a NULL value.

11005

16

Successfully returned a truncated value.

11006

16

Could not convert the data type because of a sign mismatch.

11007

16

Conversion failed because the data value overflowed the data type used by the provider.

11008

16

The provider cannot allocate memory or open another storage object on this column.

11009

16

The provider cannot determine the value for this column.

11010

16

The user did not have permission to write to the column.

11011

16

The data value violated the integrity constraints for the column.

11012

16

The data value violated the schema for the column.

11013

16

The column had a bad status.

11014

16

The column used the default value.

11015

16

The column was skipped when setting data.

11031

16

The row was successfully deleted.

11032

16

The table was in immediate-update mode, and deleting a single row caused more than one row to be deleted in the data source.

11033

16

The row was released even though it had a pending change.

11034

16

Deletion of the row was canceled during notification.

11036

16

The rowset was using optimistic concurrency and the value of a column has been changed after the containing row was last fetched or resynchronized.

11037

16

The row has a pending delete or the deletion had been transmitted to the data source.

11038

16

The row is a pending insert row.

11039

16

DBPROP_CHANGEINSERTEDROWS was VARIANT_FALSE and the insertion for the row has been transmitted to the data source.

11040

16

Deleting the row violated the integrity constraints for the column or table.

11041

16

The row handle was invalid or was a row handle to which the current thread does not have access rights.

11042

16

Deleting the row would exceed the limit for pending changes specified by the rowset property DBPROP_MAXPENDINGROWS.

11043

16

The row has a storage object open.

11044

16

The provider ran out of memory and could not fetch the row.

11045

16

User did not have sufficient permission to delete the row.

11046

16

The table was in immediate-update mode and the row was not deleted due to reaching a limit on the server, such as query execution timing out.

11047

16

Updating did not meet the schema requirements.

11048

16

There was a recoverable, provider-specific error, such as an RPC failure.

11100

16

The provider indicates that conflicts occurred with other properties or requirements.

11101

16

Could not obtain an interface required for text, ntext, or image access.

11102

16

The provider could not support a required row lookup interface.

11103

16

The provider could not support an interface required for the UPDATE/DELETE/INSERT statements.

11104

16

The provider could not support insertion on this table.

11105

16

The provider could not support updates on this table.

11106

16

The provider could not support deletion on this table.

11107

16

The provider could not support a row lookup position.

11108

16

The provider could not support a required property.

11109

16

The provider does not support an index scan on this data source.

Errors 13000 - 13999

Error

Severity

Description

13001

10

data page

13002

10

index page

13003

10

leaf page

13004

10

last

13005

10

root

13006

10

read from

13007

10

send to

13008

10

receive

13009

10

send

13010

10

read

13011

10

wait

13012

10

A USE database statement

13013

10

a procedure or trigger

13014

10

A DISTINCT clause

13015

10

a view

13016

10

An INTO clause

13017

10

An ORDER BY clause

13018

10

A COMPUTE clause

13019

10

a SELECT INTO statement

13020

10

option

13021

10

offset option

13022

10

statistics option

13023

10

parameter option

13024

10

function name

13026

10

parameter

13027

10

convert specification

13028

10

index

13029

10

table

13030

10

database

13031

10

procedure

13032

10

trigger

13033

10

view

13034

10

default

13035

10

rule

13036

10

system

13037

10

unknown type

13038

10

SET statement

13039

10

column

13040

10

type

13041

10

character string

13042

10

integer

13043

10

identifier

13044

10

number

13045

10

integer value

13046

10

floating point value

13047

10

object

13048

10

column heading

13076

10

an assignment

13077

10

a cursor declaration

13078

10

replication filter

13079

10

variable assignment

13080

10

statistics

13081

10

file

13082

10

filegroup

13083

10

server

13084

0

write

Errors 14000 - 14999

Error

Severity

Description

14001

16

The destination table must not be qualified.

14002

16

Could not find the 'Sync' subsystem with the task ID %ld.

14003

16

You must supply a publication name.

14004

16

%s must be in the current database.

14005

16

Could not drop publication. A subscription exists on it.

14006

16

Could not drop the publication.

14008

11

There are no publications.

14009

11

There are no articles for publication '%s'.

14010

16

The remote server is not defined as a subscription server.

14012

16

The @status parameter value must be either 'active' or 'inactive'.

14013

16

This database is not enabled for publication.

14014

16

The synchronization method (@sync_method) must be either '[bcp] native' or '[bcp] character'.

14015

16

The replication frequency (@repl_freq) must be either 'continuous' or 'snapshot'.

14016

16

The publication '%s' already exists.

14017

16

Invalid @restricted parameter value. Valid options are 'true' or 'false'.

14018

16

Could not create the publication.

14019

16

The @operation parameter value must be either 'add' or 'drop'.

14020

16

Could not obtain the column ID for the specified column. The column was not correctly added to the article.

14021

16

The column was not correctly added to the article.

14022

16

The parameter must be 'description', 'sync_object', 'type', 'status', 'ins_cmd', 'del_cmd', 'upd_cmd', 'filter', 'dest_table', 'creation_script', 'pre_creation_cmd', or 'script_options'.

14023

16

The type must be 'logbased', 'logbased manualfilter', 'logbased manualview', or 'logbased manualboth'.

14025

10

The article was successfully updated.

14027

11

%s does not exist in the current database.

14028

16

Only user tables and procedures can be published.

14029

16

The vertical partition switch must be either 'true' or 'false'.

14030

16

The article '%s' already exists in publication '%s'.

14031

16

User tables and views are the only valid synchronization objects.

14032

16

The value of parameter %s cannot be 'all'. It is reserved by replication stored procedures.

14033

16

Could not change replication frequency because there are active subscriptions on the publication.

14034

16

The publication name (@publication) cannot be the keyword 'all'.

14035

16

The replication option '%s' of database '%s' has already been set to true.

14036

16

Could not enable database for publishing.

14037

16

The replication option '%s' of database '%s' has already been set to false.

14038

16

Could not disable database for publishing.

14039

16

Could not construct column clause for article view. Reduce the number of columns or create the view manually.

14040

16

The server '%s' is already a subscriber.

14042

16

Could not create Subscriber.

14043

16

The parameter %s cannot be NULL.

14044

16

Owner-qualified %s names are not allowed.

14046

16

Could not drop article. A subscription exists on it.

14047

16

Could not drop %s.

14048

16

The server '%s' is not a Subscriber.

14049

16

Stored procedures for replication are the only objects that can be used as a filter.

14050

11

You do not have a subscription on this publication or article.

14051

16

The parameter value must be 'sync_type' or 'dest_db'.

14052

16

The @sync_type parameter value must be 'automatic' or 'none'.

14053

16

The subscription could not be updated at this time.

14054

10

The subscription was successfully updated.

14055

10

The subscription does not exist.

14056

16

The subscription could not be dropped at this time.

14057

16

The subscription could not be created.

14058

16

The subscription already exists.

14061

16

The @pre_creation_cmd parameter value must be 'none', 'drop', 'delete', or 'truncate'.

14062

10

The Subscriber was dropped.

14063

11

The remote server does not exist or has not been designated as a valid Subscriber.

14065

16

The @status parameter value must be 'active', 'inactive', or 'subscribed'.

14066

16

The previous status must be 'active', 'inactive', or 'subscribed'.

14067

16

The status value is the same as the previous status value.

14068

16

Could not update sysobjects. The subscription status could not be changed.

14069

16

Could not update sysarticles. The subscription status could not be changed.

14070

16

Could not update the distribution database subscription table. The subscription status could not be changed.

14071

16

Could not find the Distributor, or the distribution database, for the local server. The Distributor may not be installed, or the local server may not be configured as a Distribution Publisher at the Distributor.

14074

16

The server '%s' is already listed as a Publisher.

14075

16

The Publisher could not be created at this time.

14076

16

Could not grant replication login privilege to '%s'.

14077

10

The publication was successfully updated.

14078

16

The parameter must be 'description', 'taskid', 'sync_method', 'status', 'repl_freq', 'restricted', 'retention', 'immediate_sync', 'enabled_for_internet', 'allow_push', 'allow_pull', 'allow_anonymous', or 'retention'.

14079

16

Do not qualify the destination object name with a database. Use the 'dest_db' property of sp_changesubscription to specify a destination database.

14080

11

The remote server does not exist or has not been designated as a valid Publisher.

14085

16

The Subscriber information could not be obtained from the Distributor.

14088

16

The table '%s' must have a primary key in order to be published using the transaction-based method.

14091

16

The @type parameter passed to sp_helpreplicationdb must be either 'pub' or 'sub'.

14092

16

Could not change article because there is an existing subscription to the article.

14093

16

Cannot grant or revoke access directly on publication '%s' because it uses the default publication access list.

14094

16

Could not subscribe to article '%s' because the ODBC Subscriber '%s' does not support the @pre_creation_cmd parameter value 'truncate'.

14095

16

Could not subscribe to publication '%s' because ODBC Subscriber '%s' only supports the @sync_method parameter value 'bcp character' .

14096

16

The path and name of the table creation script must be specified if the @pre_creation_cmd parameter value is 'drop'.

14097

16

The @type parameter value must be 'no column names', 'include column names', 'string literals', or 'parameters'.

14098

16

Cannot drop Distribution Publisher '%s'. The remote Publisher is using '%s' as Distributor.

14099

16

The server '%s' is already defined as a Distributor.

14101

16

The publication '%s' already has a Snapshot Agent defined.

14105

10

You have successfully updated the distribution database property '%s'.

14106

10

Distribution retention periods must be greater than 0.

14107

10

The @max_distretention value must be larger than the @min_distretention value.

14108

10

Removed %ld history records from %s.

14109

10

The @security_mode parameter value must be 0 (SQL Server Authentication) or 1 (Windows NT Authentication).

14110

16

For sp_changearticle, the @property parameter value must be 'name', 'description', 'dest_object', 'creation_script', 'pre_creation_cmd', or 'schema_option'.

14111

16

The @pre_creation_cmd parameter value must be 'none' or 'drop'.

14112

16

This procedure can only be executed against table-based articles.

14113

16

Could not execute '%s'. Check '%s' in the install directory.

14114

16

'%s' is not configured as a Distributor.

14115

16

The property parameter value must be %s.

14117

16

'%s' is not configured as a distribution database.

14118

16

The @type parameter value must be 'proc exec', or 'serializable proc exec'.

14119

16

Could not add the distribution database '%s'. This distribution database already exists.

14120

16

Could not drop the distribution database '%s'. This distributor database is associated with a Publisher.

14121

16

Could not to drop the Distributor '%s'. This Distributor has associated distribution databases.

14122

16

The @article parameter value must be 'all' for immediate_sync publications.

14123

16

The subscription @sync_type parameter value 'manual' is no longer supported.

14124

16

An immediate_sync publication must have at least one article before it can be subscribed to.

14126

16

You do not have the required permissions to complete the operation.

14128

16

Invalid @subscription_type parameter value. Valid options are 'push' or 'pull'.

14129

16

The @status parameter value must be NULL for 'automatic' sync_type when you add subscriptions to an immediate_sync publication.

14135

16

There is no subscription on Publisher '%s', publisher database '%s', publication '%s'.

14136

16

The keyword 'all' is reserved by replication stored procedures.

14137

16

The @value parameter value must be either 'true' or 'false'.

14138

16

The @optname parameter value must be either 'publish' or 'merge publish'.

14139

16

The replication system table '%s' already exists.

14143

16

Cannot drop Distributor Publisher '%s'. There are Subscribers associated with it in the distribution database '%s'.

14144

16

Cannot drop Subscriber '%s'. There are subscriptions from it in the published database '%s'.

14145

16

You must give the path of a user-supplied article creation script if you enable the schema option of using user-supplied schema script (schema_option & 0x1 = 0).

14146

16

The article parameter '@schema_option' cannot be NULL.

14147

16

Restricted publications are no longer supported.

14148

16

Invalid '%s' value. Valid values are 'true' or 'false'.

14149

10

Removed %ld replication history records in %s seconds (%ld row/secs).

14150

10

Replication-%s: agent %s succeeded. %s

14151

18

Replication-%s: agent %s failed. %s

14152

10

Replication-%s: agent %s scheduled for retry. %s

14153

10

Replication-%s: agent %s warning. %s

14154

16

The Distributor parameter must be '@heartbeat_interval'.

14155

16

Invalid article ID specified for procedure script generation.

14156

16

The custom stored procedure was not specified in the article definition.

14157

10

The subscription created by Subscriber '%s' to publication '%s' has expired and has been dropped.

14158

10

Replication-%s: agent %s: %s.

14159

16

Could not change property '%s' for article '%s' because there is an existing subscription to the article.

14200

16

The specified '%s' is invalid.

14201

10

0 (all steps)..

14202

10

before or after @active_start_time

14203

10

sp_helplogins [excluding Windows NT groups]

14204

10

0 (non-idle), 1 (executing), 2 (waiting for thread), 3 (between retries), 4 (idle), 5 (suspended), 7 (performing completion actions)

14205

10

(unknown)

14206

10

0..n seconds

14207

10

-1 [no maximum], 0..n

14208

10

1..7 [1 = E-mail, 2 = Pager, 4 = NetSend]

14209

10

0..127 [1 = Sunday .. 64 = Saturday]

14210

10

notification

14211

10

server

14212

10

(all jobs)

14213

16

Core Job Details:

14214

16

Job Steps:

14215

16

Job Schedules:

14216

16

Job Target Servers:

14217

16

SQL Server Warning: '%s' has performed a forced defection of TSX server '%s'. Run sp_delete_targetserver at the MSX in order to complete the defection.

14218

10

hour

14219

10

minute

14220

10

second

14221

16

This job has one or more notifications to operators other than '%s'. The job cannot be targeted at remote servers as currently defined.

14222

16

Cannot rename the '%s' operator.

14223

16

Cannot modify or delete operator '%s' while this server is a %s.

14224

0

Warning: The server name given is not the current MSX server ('%s').

14225

16

Warning: Could not determine local machine name. This prevents MSX operations from being posted.

14226

0

%ld history entries purged.

14227

0

Server defected from MSX '%s'. %ld job(s) deleted.

14228

0

Server MSX enlistment changed from '%s' to '%s'.

14229

0

Server enlisted into MSX '%s'.

14230

0

SP_POST_MSX_OPERATION: %ld %s download instruction(s) posted.

14231

0

SP_POST_MSX_OPERATION Warning: The specified %s ('%s') is not involved in a multiserver job.

14232

16

Specify either a job_name, job_id, or an originating_server.

14233

16

Specify a valid job_id (or 0x00 for all jobs).

14234

16

The specified '%s' is invalid (valid values are returned by %s).

14235

16

The specified '%s' is invalid (valid values are greater than 0 but excluding %ld).

14236

0

Warning: Non-existent step referenced by %s.

14237

16

When an action of 'REASSIGN' is specified, the New Login parameter must also be supplied.

14238

0

%ld jobs deleted.

14239

0

%ld jobs reassigned to %s.

14240

0

Job applied to %ld new servers.

14241

0

Job removed from %ld servers.

14242

16

Only a system administrator can reassign ownership of a job.

14243

0

Job '%s' started successfully.

14244

16

Only a system administrator can reassign tasks.

14245

16

Specify either the @name, @id, or @loginname of the task(s) to be deleted.

14246

16

Specify either the @currentname or @id of the task to be updated.

14247

16

Only a system administrator can view tasks owned by others.

14248

16

This login is the owner of %ld job(s). You must delete or reassign these jobs before the login can be dropped.

14249

16

Specify either @taskname or @oldloginname when reassigning a task.

14250

16

The specified %s is too long. It must contain no more than %ld characters.

14251

16

Cannot specify '%s' as the operator to be notified.

14252

16

Cannot perform this action on a job you do not own.

14253

0

%ld (of %ld) job(s) stopped successfully.

14254

0

Job '%s' stopped successfully.

14255

16

The owner ('%s') of this job is either an invalid login, or is not a valid user of database '%s'.

14256

16

Cannot start job '%s' (ID %s) because it does not have any job server(s) defined.

14257

16

Cannot stop job '%s' (ID %s) because it does not have any job server(s) defined.

14258

16

Cannot perform this operation while SQLServerAgent is starting. Try again later.

14259

16

A schedule (ID %ld, '%s') for this job with this definition already exists.

14260

16

You do not have sufficient permission to run this command.

14261

16

The specified %s ('%s') already exists.

14262

16

The specified %s ('%s') does not exist.

14263

16

Target server '%s' is already a member of group '%s'.

14264

16

Target server '%s' is not a member of group '%s'.

14265

25

The MSSQLServer service aborted unexpectedly.

14266

16

The specified '%s' is invalid (valid values are: %s).

14267

16

Cannot add a job to the '%s' job category.

14268

16

There are no jobs at this server that originated from server '%s'.

14269

16

Job '%s' is already targeted at server '%s'.

14270

16

Job '%s' is not currently targeted at server '%s'.

14271

16

A target server cannot be named '%s'.

14272

16

Object-type and object-name must be supplied as a pair.

14273

16

You must provide either @job_id or @job_name (and, optionally, @schedule_name), or @schedule_id.

14274

16

Cannot add, update, or delete a job (or its steps or schedules) that originated from an MSX server.

14275

16

The originating server must be either '(local)' or '%s'.

14276

16

'%s' is a permanent %s category and cannot be deleted.

14277

16

The command script does not destroy all the objects that it creates. Revise the command script.

14278

16

The schedule for this job is invalid (reason: %s).

14279

16

Supply either @job_name or @originating_server.

14280

16

Supply either a job name (and job aspect), or one or more job filter parameters.

14281

0

Warning: The @new_owner_login_name parameter is not necessary when specifying a 'DELETE' action.

14282

16

Supply either a date (created or last modified) and a data comparator, or no date parameters at all.

14283

16

Supply @target_server_groups or @target_servers, or both.

14284

16

Cannot specify a job ID for a new job. An ID will be assigned by the procedure.

14285

16

Cannot add a local job to a multi-server job category.

14286

16

Cannot add a multi-server job to a local job category.

14287

16

The '%s' supplied has an invalid %s.

14288

16

%s cannot be less than %s.

14289

16

%s cannot contain '%s' characters.

14290

16

This job is currently targeted at the local server so cannot also be targeted at a remote server.

14291

16

This job is currently targeted at a remote server so cannot also be targeted at the local server.

14292

16

There are two or more tasks named '%s'. Specify %s instead of %s to uniquely identify the task.

14293

16

There are two or more jobs named '%s'. Specify %s instead of %s to uniquely identify the job.

14294

16

Supply either %s or %s to identify the job.

14295

16

Frequency Type 0x2 (OnDemand) is no longer supported.

14296

16

This server is already enlisted into MSX '%s'.

14297

16

Cannot enlist into the local machine.

14298

16

This server is not currently enlisted into an MSX.

14299

16

Server '%s' is an MSX. Cannot enlist one MSX into another MSX.

14300

16

Circular dependencies exist. Dependency evaluation cannot continue.

14301

16

Logins other than the current user can only be seen by members of the sysadmin role.

14302

16

You must upgrade your client to version 6.5 of SQL-DMO and SQL Server Enterprise Manager to connect to this server. The upgraded versions will administer both SQL Server version 6.5 and 6.0 (if sqlole65.sql is run).

14500

16

Supply either a non-zero message ID, non-zero severity, or non-null performance condition.

14501

16

An alert ('%s') has already been defined on this condition.

14502

16

The @target_name parameter must be supplied when specifying an @enum_type of 'TARGET'.

14503

16

The @target_name parameter should not be supplied when specifying an @enum_type of 'ALL' or 'ACTUAL'.

14504

16

'%s' is the fail-safe operator. You must make another operator the fail-safe operator before '%s' can be dropped.

14505

16

Specify a null %s when supplying a performance condition.

14506

16

Cannot set alerts on message ID %ld.

14507

16

A performance condition must be formatted as: 'object_name|counter_name|instance_name|comparator(> or < or =)|numeric value'.

14542

16

It is invalid for any TSQL step of a multiserver job to have a non-null %s value.

14543

16

Login '%s' owns one or more multiserver jobs. Ownership of these jobs can only be assigned to members of the %s role.

14544

16

This job is owned by '%s'. Only a job owned by a member of the %s role can be a multiserver job.

14545

16

The %s parameter is not valid for a job step of type '%s'.

14546

16

The %s parameter is not supported on Windows 95/98 platforms.

14547

10

Warning: This change will not be downloaded by the target server(s) until an %s for the job is posted using %s.

14548

10

Target server '%s' does not have any jobs assigned to it.

14549

10

(Description not requested.)

14550

10

Command-Line Subsystem

14551

10

Replication Snapshot Subsystem

14552

10

Replication Transaction-Log Reader Subsystem

14553

10

Replication Distribution Subsystem

14554

10

Replication Merge Subsystem

14555

10

Active Scripting Subsystem

14556

10

Transact-SQL Subsystem

14557

10

[Internal]

14558

10

(encrypted command)

14559

10

(append output file)

14560

10

(include results in history)

14561

10

(normal)

14562

10

(quit with success)

14563

10

(quit with failure)

14564

10

(goto next step)

14565

10

(goto step)

14566

10

(idle)

14567

10

(below normal)

14568

10

(above normal)

14569

10

(time critical)

14570

10

(Job outcome)

14571

10

No description available.

14572

10

@freq_interval must be at least 1 for a daily job.

14573

10

@freq_interval must be a valid day of the week bitmask [Sunday = 1 .. Saturday = 64] for a weekly job.

14574

10

@freq_interval must be between 1 and 31 for a monthly job.

14575

10

@freq_relative_interval must be one of 1st (0x1), 2nd (0x2), 3rd [0x4], 4th (0x8) or Last (0x10).

14577

10

@freq_recurrence_factor must be at least 1.

14578

10

Starts whenever the CPU usage has remained below %ld percent for %ld seconds.

14579

10

Automatically starts when SQLServerAgent starts.

14580

10

job

14585

16

Only the owner of DTS Package '%s' or a member of the sysadmin role may reassign its ownership.

14586

16

Only the owner of DTS Package '%s' or a member of the sysadmin role may create new versions of it.

14587

16

Only the owner of DTS Package '%s' or a member of the sysadmin role may drop it or any of its versions.

14588

10

ID.VersionID =

14589

10

[not specified]

14590

16

DTS Package '%s' already exists with a different ID in this category.

14591

16

DTS Category '%s' already exists in the specified parent category.

14592

16

DTS Category '%s' was found in multiple parent categories. You must uniquely specify the category to be dropped.

14593

16

DTS Category '%s' contains packages and/or other categories. You must drop these first, or specify a recursive drop.

14594

10

DTS Package

14595

16

DTS Package '%s' exists in different categories. You must uniquely specify the package.

14596

16

DTS Package '%s' exists in another category.

14597

16

DTS Package ID '%s' already exists with a different name.

14598

16

Cannot drop the Local, Repository, or LocalDefault DTS categories.

14599

10

Name

Errors 15000 - 15999

Error

Severity

Description

15000

16

Only members of the sysadmin role or the database owner can execute this stored procedure.

15001

16

%s does not exist.

15002

16

The procedure '%s' cannot be executed within a transaction.

15003

16

Only members of the %s role can execute this stored procedure.

15004

16

Name cannot be NULL.

15005

0

Statistics for all tables have been updated.

15006

16

'%s' is not a valid name because it contains invalid characters.

15007

16

The login '%s' does not exist.

15008

16

User '%s' does not exist in the current database.

15009

16

The object '%s' does not exist in database '%s'.

15010

16

The database '%s' does not exist. Use sp_helpdb to show available databases.

15011

16

Database option '%s' does not exist.

15012

16

The device '%s' does not exist. Use sp_helpdevice to show available devices.

15013

0

Table '%s': No columns without statistics found.

15014

16

The role '%s' does not exist in the current database.

15015

16

The server '%s' does not exist. Use sp_helpserver to show available servers.

15016

16

The default '%s' does not exist.

15017

16

The rule '%s' does not exist.

15018

0

Table '%s': Creating statistics for the following columns:

15019

16

The extended stored procedure '%s' does not exist.

15020

0

Statistics have been created for the %d listed columns of the above tables.

15021

16

There are no remote users mapped to any local user from remote server '%s'.

15022

16

The specified user name is already aliased.

15023

16

User or role '%s' already exists in the current database.

15024

16

The group '%s' already exists in the current database.

15025

16

The login '%s' already exists.

15026

16

Logical device '%s' already exists.

15027

16

There are no remote users mapped to local user '%s' from remote server '%s'.

15028

16

The server '%s' already exists.

15029

16

The data type '%s' already exists in the current database.

15030

16

The read-only bit cannot be turned off because the database is in standby mode.

15031

0

'Virtual_device' device added.

15032

16

The database '%s' already exists.

15033

16

'%s' is not a valid official language name.

15034

16

The application role password must not be NULL.

15035

16

'%s' is not a database device.

15036

16

The data type '%s' does not exist.

15037

16

The physical data type '%s' does not allow nulls.

15038

16

User-defined data types based on timestamp are not allowed.

15039

16

The language %s already exists in syslanguages.

15040

16

User-defined error messages must have an ID greater than 50000.

15041

16

User-defined error messages must have a severity level between 1 and 25.

15042

16

Only members of the sysadmin role can add messages with severity levels greater than 18 or those which use the TRUE (for WITH_LOG) option.

15043

16

You must specify 'REPLACE' to overwrite an existing message.

15044

16

'%s' is an unknown device type. Use 'disk', 'tape', or 'pipe'.

15045

16

The logical name cannot be NULL.

15046

16

The physical name cannot be NULL.

15047

16

The only permitted options for a tape device are 'skip' and 'noskip'.

15048

0

Valid values of database compatibility level are %d, %d, or %d.

15049

11

Cannot unbind from '%s'. Use ALTER TABLE DROP CONSTRAINT.

15050

11

Cannot bind default '%s'. The default must be created using the CREATE DEFAULT statement.

15051

11

Cannot rename the table because it is published for replication.

15052

0

Prior to updating sysdatabases entry for database '%s', mode = %d and status = %d (status suspect_bit = %d).

15053

16

Objects exist which are not owned by the database owner.

15054

0

The current compatibility level is %d.

15055

11

Error. Updating sysdatabases returned @@error <> 0.

15056

0

No row in sysdatabases was updated because mode and status are already correctly reset. No error and no changes made.

15057

16

List of %s name contains spaces, which are not allowed.

15058

16

List of %s has too few names.

15059

16

List of %s has too many names.

15060

16

List of %s names contains name(s) which have '%s' non-alphabetic characters.

15061

16

Add device request denied. A physical device named '%s' already exists.

15062

16

The guest user cannot be mapped to a login name.

15063

16

The login already has an account under a different user name.

15064

11

PRIMARY KEY and UNIQUE KEY constraints do not have space allocated.

15065

16

All user IDs have been assigned.

15066

16

A default-name mapping of a remote login from remote server '%s' already exists.

15067

16

'%s' is not a local user. Remote login denied.

15068

16

A remote user '%s' already exists for remote server '%s'.

15069

16

One or more users are using the database. The requested operation cannot be completed.

15070

0

Object '%s' was successfully marked for recompilation.

15071

16

Usage: sp_addmessage <msgnum>,<severity>,<msgtext> [,<language> [,FALSE | TRUE [,REPLACE]]]

15072

16

Usage: sp_addremotelogin remoteserver [, loginame [,remotename]]

15073

0

For row in sysdatabases for database '%s', the status bit %d was forced off and mode was forced to 0.

15074

0

Warning: You must recover this database prior to access.

15075

16

The data type '%s' is reserved for future use.

15076

16

Default, table, and user data types must be in the current database.

15077

16

Rule, table, and user data type must be in the current database.

15078

16

The table or view must be in the current database.

15079

10

Queries processed: %d.

15082

11

NULL is not an acceptable parameter value for this procedure. Use a percent sign instead.

15084

16

The column or user data type must be in the current database.

15085

16

Usage: sp_addtype name, 'data type' [,'NULL' | 'NOT NULL']

15086

16

Invalid precision specified. Precision must be between 1 and 38.

15087

16

Invalid scale specified. Scale must be less than precision and positive.

15088

16

The physical data type is fixed length. You cannot specify the length.

15089

11

Cannot change the '%s' option of a database while another user is in the database.

15090

16

There is already a local server.

15091

16

You must specify a length with this physical data type.

15092

16

Invalid length specified. Length must be between 1 and 8000 bytes.

15093

16

'%s' is not a valid date order.

15094

16

'%s' is not a valid first day.

15095

16

Insert into syslanguages failed. Language not added.

15096

16

Only members of the sysadmin role or '%s' can change the default language for '%s'.

15100

16

Usage: sp_bindefault defaultname, objectname [, 'futureonly']

15101

16

Cannot bind a default to a column of data type timestamp.

15102

16

Cannot bind a default to an identity column.

15103

16

Cannot bind a default to a column created with or altered to have a default value.

15104

16

You do not own a table named '%s' that has a column named '%s'.

15105

16

You do not own a data type with that name.

15106

16

Usage: sp_bindrule rulename, objectname [, 'futureonly']

15107

16

Cannot bind a rule to a column of data type text, ntext, image, or timestamp.

15108

16

Only members of the sysadmin role can change the owner of a database.

15109

16

Cannot change the owner of the master database.

15110

16

The proposed new database owner is already a user in the database.

15111

16

The proposed new database owner is already aliased in the database.

15123

16

The configuration option '%s' does not exist, or it may be an advanced option.

15124

16

The configuration option '%s' is not unique.

15125

16

Only members of the sysadmin role can change configuration parameters.

15127

16

Cannot set the default language to a language ID not defined in syslanguages.

15129

16

'%d' is not a valid value for configuration option '%s'.

15131

16

Usage: sp_dbremove <dbname> [,dropdev]

15132

16

Cannot change default database belonging to someone else.

15134

16

No alias exists for the specified user.

15139

16

The device is a RAM disk and cannot be used as a default device.

15140

16

Usage: sp_diskdefault logicalname {defaulton | defaultoff}

15142

16

Cannot drop the role '%s'.

15143

16

'%s' is not a valid option for the @updateusage parameter. Enter either 'true' or 'false'.

15144

16

The role has members. It must be empty before it can be dropped.

15174

16

Login '%s' owns one or more database(s). Change the owner of the following database(s) before dropping login:

15175

16

Login '%s' is aliased or mapped to a user in one or more database(s). Drop the user or alias before dropping the login.

15176

16

The only valid @parameter value is 'WITH_LOG'.

15177

16

Usage: sp_dropmessage <msg number> [,<language> | 'ALL']

15178

16

Cannot drop a message with an ID less than 50000.

15179

16

Message number %u does not exist.

15180

16

Cannot drop. The data type is being used.

15181

16

Cannot drop the database owner.

15182

16

Cannot drop the guest user from master or tempdb.

15183

16

The user owns objects in the database and cannot be dropped.

15184

16

The user owns data types in the database and cannot be dropped.

15185

16

There is no remote user '%s' mapped to local user '%s' from the remote server '%s'.

15190

16

There are still remote logins for the server '%s'.

15191

16

Usage: sp_dropserver server [, droplogins]

15193

16

This procedure can only be used on system tables.

15194

16

Cannot re-create index on this table.

15197

16

There is no text for object '%s'.

15198

16

The name supplied (%s) is not a user, role, or aliased login.

15200

16

There are no remote servers defined.

15201

16

There are no remote logins for the remote server '%s'.

15202

16

There are no remote logins defined.

15203

16

There are no remote logins for '%s'.

15204

16

There are no remote logins for '%s' on remote server '%s'.

15205

16

There are no servers defined.

15206

16

Invalid Remote Server Option: '%s'.

15210

16

Only members of the sysadmin role can use the loginame option. The password was not changed.

15211

16

Old (current) password incorrect for user. The password was not changed.

15216

16

'%s' is not a valid option for the @delfile parameter.

15218

16

Object '%s' is not a table.

15219

16

You do not own table '%s'. Only members of the sysadmin role or the table owner may perform this action.

15220

16

Usage: sp_remoteoption [remoteserver, loginame, remotename, optname, {true | false}]

15221

16

Remote login option does not exist or cannot be set by user. Run sp_remoteoption with no parameters to see options.

15222

16

Remote login option '%s' is not unique.

15223

11

Error: The input parameter '%s' is not allowed to be null.

15224

11

Error: The value for the @newname parameter contains invalid characters or violates a basic restriction (%s).

15225

11

No item by the name of '%s' could be found in the current database '%s', given that @itemtype was input as '%s'.

15226

16

Only members of the sysadmin role can change the name of a database.

15227

16

The database '%s' cannot be renamed.

15228

16

A member of the sysadmin role must set database '%s' to single user mode with sp_dboption before it can be renamed.

15229

16

Usage: sp_serveroption [server [,optname [,'true' | 'false']]]

15230

16

Server option '%s' does not exist or cannot be set by user. Run sp_serveroption with no parameters to see options.

15231

16

Server option '%s' is not unique.

15232

16

Only members of the sysadmin role may set server options.

15234

16

Object is stored in sysprocedures and has no space allocated directly.

15235

16

Views do not have space allocated.

15236

16

Column '%s' has no default.

15237

16

User data type '%s' has no default.

15238

16

Column '%s' has no rule.

15239

16

User data type '%s' has no rule.

15241

16

Usage: sp_dboption [dbname [,optname [,'true' | 'false']]]

15242

16

Database option '%s' is not unique.

15243

16

The option '%s' cannot be changed for the master database.

15244

16

Only members of the sysadmin role or the database owner may set database options.

15245

16

DBCC DBCONTROL error. Database was not placed offline.

15248

11

Error: The parameter @oldname is either ambiguous or the claimed @itemtype (%s) was wrong.

15249

11

Error: Explicit @itemtype '%s' is unrecognized (%d).

15250

16

The database name component of the object qualifier must be the name of the current database.

15251

16

Invalid '%s' specified. It must be %s.

15252

16

The primary or foreign key table name must be given.

15253

11

Syntax error parsing SQL identifier '%s'.

15254

16

Users other than the database owner or guest exist in the database. Drop them before removing the database.

15255

11

'%s' is not a valid value for @autofix. The only valid value is 'auto'.

15256

16

Usage: sp_certify_removable <dbname> [,'auto']

15257

16

The database that you are attempting to certify cannot be in use at the same time.

15258

16

The database must be owned by a member of the sysadmin role before it can be removed.

15261

16

Usage: sp_create_removable <dbname>,<syslogical>,<sysphysical>,<syssize>,<loglogical>,<logphysical>,<logsize>,<datalogical1>,<dataphysical1>,<datasize1> [,<datalogical2>,<dataphysical2>,<datasize2>...<datalogical16>,<dataphysical16>,<datasize16>]

15262

0

Invalid file size entered. All files must be at least 1 MB.

15264

16

Could not create the '%s' portion of the database.

15266

16

Cannot make '%s' database removable.

15269

16

Logical data device '%s' not created.

15270

16

You cannot specify a length for user data types based on sysname.

15271

16

Invalid @with_log parameter value. Valid values are 'true' or 'false'.

15275

16

FOREIGN KEY constraints do not have space allocated.

15277

16

The only valid @parameter_value values are 'true' or 'false'.

15278

16

Login '%s' is already mapped to user '%s' in database '%s'.

15279

16

You must add the us_english version of this message before you can add the '%s' version.

15280

16

All localized versions of this message must be dropped before the us_english version can be dropped.

15283

16

The name '%s' contains too many characters.

15284

16

The user has granted or revoked privileges to the following in the database and cannot be dropped.

15285

16

The special word '%s' cannot be used for a logical device name.

15286

16

Terminating this procedure. The @action '%s' is unrecognized. Try 'REPORT', 'UPDATE_ONE', or 'AUTO_FIX'.

15287

16

Terminating this procedure. '%s' is a forbidden value for the login name parameter in this procedure.

15288

16

Terminating this procedure. Only %s has the permissions to run the action '%s'.

15289

16

Terminating this procedure. Cannot have an open transaction when this is run.

15290

16

Terminating this procedure. The Action '%s' is incompatible with the other parameter values ('%s', '%s').

15291

16

Terminating this procedure. The %s name '%s' is absent or invalid.

15292

0

The row for user '%s' will be fixed by updating its login link to a login already in existence.

15293

0

Barring a conflict, the row for user '%s' will be fixed by updating its link to a new login. Consider changing the new password from null.

15294

0

The number of orphaned users fixed by adding new logins and then updating users was %d.

15295

0

The number of orphaned users fixed by updating users was %d.

15298

0

New login created.

15300

11

No recognized letter is contained in the parameter value for General Permission Type (%s). Valid letters are in this set: %s .

15302

11

Database_Name should not be used to qualify owner.object for the parameter into this procedure.

15303

11

The "user options" config value (%d) was rejected because it would set incompatible options.

15304

16

The severity level of the '%s' version of this message must be the same as the severity level (%ld) of the us_english version.

15305

16

The @TriggerType parameter value must be 'insert', 'update', or 'delete'.

15306

16

Cannot change the compatibility level of replicated or distributed databases.

15307

16

Could not change the merge publish option because the server is not set up for replication.

15308

16

You must set database '%s' to single user mode with sp_dboption before fixing indexes on system tables.

15311

16

The file named '%s' does not exist.

15312

16

The file named '%s' is a primary file and cannot be removed.

15318

0

All fragments for database '%s' on device '%s' are now dedicated for log usage only.

15319

17

Error: DBCC DBREPAIR REMAP failed for database '%s' (device '%s').

15321

16

There was some problem removing '%s' from sysaltfiles.

15322

0

File '%s' was removed from tempdb, and will take effect upon server restart.

15323

16

The selected index does not exist on table '%s'.

15324

16

The option %s cannot be changed for the '%s' database.

15325

16

The current database does not contain a %s named '%ls'.

15326

0

No extended stored procedures exist.

15327

0

The database is now offline.

15328

0

The database is offline already.

15330

11

There are no matching rows on which to report.

15331

11

The user '%s' cannot take the action auto_fix because another user has SUID = %d.

15333

11

Error: the qualified @oldname references a database (%s) other than the current database.

15334

11

Error: Only members of the sysadmin role or the database owner can rename items they do not own.

15335

11

Error: The @newname value '%s' is already in use as a %s name and would cause a duplicate that is not permitted.

15337

0

Caution: sysdepends shows that other objects (views, procedures and so on) are referencing this object by its old name. These objects will become invalid, and should be dropped and re-created promptly.

15338

0

The %s was renamed to '%s'.

15339

0

Creating '%s'.

15340

0

Alias user added.

15341

0

Granted database access to '%s'.

15342

0

Replacing message.

15343

0

New message added.

15354

0

Usage: sp_detachdb <dbname>, [TRUE|FALSE]

15358

0

User-defined filegroups should be made read-only.

15363

16

The role '%s' already exists in the current database.

15379

11

The server option value '%s' supplied is unrecognized.

15386

11

For input parameter @OptionName you entered the value '%s'. The number of valid option names matching this value is %d (not equal to 1). Terminating this procedure.

15387

11

If the qualified object name specifies a database, that database must be the current database.

15388

11

There are no objects matching the input name '%s' in the current database.

15389

11

The value '%s' for the @OptionValue parameter is unrecognized.

15390

11

Only members of the sysadmin role or the database owner can modify '%s' settings for objects owned by other users.

15391

0

All %d matched objects now have their '%s' setting as '%s'. Updates were required for %d objects.

15392

11

Only members of the sysadmin role can modify the settings for option %s.

15393

16

Commit service transaction (XACT) ID does not exist.

15395

11

The qualified old name could not be found for item type '%s'.

15396

11

Cannot change option %s for an object without first performing a DROP statement then a CREATE statement.

15397

11

Could not change option %s. Not more than one object can be changed per execution for this option. %d objects match the parameter values in the current attempt.

15398

11

Only objects in the master database and owned by a member of the sysadmin role can have the setting changed for option %s.

15399

11

Could not change option %s. This type of change is restricted to objects that have no parameters or columns.

15400

11

Could not change an object of type %s. The setting of option %s cannot be changed for objects of this type. Bypassing object '%s'. Other valid, matching objects will be processed now.

15401

11

Windows NT user or group '%s' not found. Check the name again.

15402

11

'%s' is not a fixed server role.

15403

11

Insufficient permission to add a member to the fixed role '%s'.

15405

11

Cannot use the reserved user or role name '%s'.

15407

11

'%s' is not a valid Windows NT name. Give the complete name: <domain\username>.

15409

11

'%s' is not a role.

15410

11

User or role '%s' does not exist in this database.

15412

11

'%s' is not a known fixed role.

15413

11

Cannot make a role a member of itself.

15415

11

User is a member of more than one group. sp_changegroup is set up for backward compatibility and expects membership in one group at most.

15416

16

Usage: sp_dbcmptlevel [dbname [, compatibilitylevel]]

15417

16

Insufficient permission to change the compatibility level of the '%s' database.

15418

16

Only members of the sysadmin role or the database owner may set the database compatibility level.

15419

16

Supplied parameter @sid should be binary(16).

15420

16

The group '%s' does not exist in this database.

15421

16

The user owns role(s) in the database and cannot be dropped.

15422

16

Application roles can only be activated at the ad hoc level.

15423

0

The password for application role '%s' has been changed.

15424

0

New role added.

15425

0

New application role added.

15426

16

You must specify a provider name with this set of properties.

15427

16

You must specify a provider name for unknown product '%ls'.

15428

16

You cannot specify a provider or any properties for product '%ls'.

15429

16

'%ls' is an invalid product name.

15430

19

Limit exceeded for number of servers.

15431

16

You must specify the @rolename parameter.

15432

16

Stored procedure '%s' can only be executed at the ad hoc level.

15433

16

Supplied parameter @sid is in use.

15434

16

Could not drop login '%s' as the user is currently logged in.

15435

0

Database successfully published.

15436

0

Database successfully enabled for subscriptions.

15437

0

Database successfully published using merge replication.

15438

0

Database is already online.

15439

0

Database is now online.

15440

0

Database is no longer published.

15441

0

Database is no longer enabled for subscriptions.

15442

0

Database is no longer enabled for merge publications.

15443

0

Checkpointing database that was changed.

15444

0

'Disk' device added.

15445

0

'Diskette' device added.

15446

0

'Tape' device added.

15447

0

'Pipe' device added.

15448

0

New remote login created.

15449

0

Type added.

15450

0

New language inserted.

15451

0

%s messages altered.

15452

0

No alternate languages are available.

15453

0

us_english is always available, even though it is not in syslanguages.

15454

0

Language deleted.

15456

0

Valid configuration options are:

15457

0

Configuration option changed. Run the RECONFIGURE statement to install.

15458

0

Database removed.

15459

0

In the current database, the specified object references the following:

15460

0

In the current database, the specified object is referenced by the following:

15461

0

Object does not reference any object, and no objects reference it.

15462

0

File '%s' closed.

15463

0

Device dropped.

15466

0

Message dropped.

15467

0

Type has been dropped.

15468

0

Remote login dropped.

15469

0

No constraints have been defined for this object.

15470

0

No foreign keys reference this table.

15471

0

The object comments have been encrypted.

15472

0

The object does not have any indexes.

15473

0

Settable remote login options.

15474

11

Only members of the sysadmin role can set remote login options.

15475

0

The database is renamed and in single user mode.

15476

0

A member of the sysadmin role must reset the database to multiuser mode with sp_dboption.

15477

0

Caution: Changing any part of an object name could break scripts and stored procedures.

15478

0

Password changed.

15479

0

Login dropped.

15480

0

Could not grant login access to '%s'.

15481

0

Granted login access to '%s'.

15482

0

Could not deny login access to '%s'.

15483

0

Denied login access to '%s'.

15484

0

Could not revoke login access from '%s'.

15485

0

Revoked login access from '%s'.

15486

0

Default database changed.

15487

0

%s's default language is changed to %s.

15488

0

'%s' added to role '%s'.

15489

0

'%s' dropped from role '%s'.

15490

0

The dependent aliases were also dropped.

15491

0

User has been dropped from current database.

15492

0

Alias user dropped.

15493

0

Role dropped.

15494

0

The application role '%s' is now active.

15495

0

Application role dropped.

15496

0

Group changed.

15497

0

Could not add login using sp_addlogin (user = %s). Terminating this procedure.

15498

17

Inside txn_1a_, update failed. Will roll back (1a1).

15499

0

The dependent aliases were mapped to the new database owner.

15500

0

The dependent aliases were dropped.

15501

0

Database owner changed.

15502

0

Setting database owner to SA.

15503

0

Giving ownership of all objects to the database owner.

15504

0

Deleting users except guest and the database owner from sysusers.

15505

0

The object owner has been changed.

15506

0

Server added.

15507

0

Remote logins for remote server '%s' have been dropped.

15508

0

Server dropped.

15509

0

Settable server options.

15510

0

Server network name set.

15511

0

Default bound to column.

15512

0

Default bound to data type.

15513

0

The new default has been bound to columns(s) of the specified user data type.

15514

0

Rule bound to table column.

15515

0

Rule bound to data type.

15516

0

The new rule has been bound to column(s) of the specified user data type.

15517

0

Option %s turned on.

15518

0

Option %s turned off.

15519

0

Default unbound from table column.

15520

0

Default unbound from data type.

15521

0

Columns of the specified user data type had their defaults unbound.

15522

0

Rule unbound from table column.

15523

0

Rule unbound from data type.

15524

0

Columns of the specified user data type had their rules unbound.

15525

0

sp_checknames is used to search for non 7-bit ASCII characters.

15526

0

in several important columns of system tables. The following

15527

0

columns are searched:

15528

0

In master:

15536

0

In all databases:

15543

0

Looking for non 7-bit ASCII characters in the system tables of database '%s'.

15544

0

Table.column '%s'

15545

0

The following database names contain non 7-bit ASCII characters.

15546

0

If you wish to change these names, use '%s'.

15547

0

The following logins have default database names that contain

15548

0

non 7-bit ASCII characters. If you wish to change these names use

15549

0

sp_defaultdb.

15550

0

The following servers have 'initialization file' names that contain

15551

0

non 7-bit ASCII characters. If you wish to change these names,

15552

0

use UPDATE.

15553

0

Database '%s' has no object, user, and so on

15554

0

names that contain non 7-bit ASCII characters.

15555

0

The database name provided '%s' must be the current database when executing this stored procedure.

15564

0

The following device names contain non 7-bit ASCII characters.

15565

0

The following login names contain non 7-bit ASCII characters.

15566

0

The following remote login names contain non 7-bit ASCII characters.

15567

0

The following server names contain non 7-bit ASCII characters.

15568

0

The following column and parameter names contain non 7-bit ASCII characters.

15569

0

The following index names contain non 7-bit ASCII characters.

15570

0

The following object names contain non 7-bit ASCII characters.

15571

0

The following segment names contain non 7-bit ASCII characters.

15572

0

The following data type names contain non 7-bit ASCII characters.

15573

0

The following user or role names contain non 7-bit ASCII characters.

15600

15

An invalid parameter or option was specified for procedure '%s'.

15601

16

Fulltext Search is not enabled for the current database. Use sp_fulltext_database to enable full-text search.

15602

16

Full-Text catalog '%ls' does not exist.

15603

16

A full-text catalog named '%ls' already exists in this database.

15604

16

Cannot drop full-text catalog '%ls' because it contains a full-text index.

15605

16

A full-text index for table '%ls' has already been created.

15606

16

You must first create a full-text index on table '%ls'.

15607

16

'%ls' is not a valid index to enforce a full-text search key. You must specify a unique, non-nullable, single-column index.

15608

16

Full-text search has already been activated for table '%ls'.

15609

16

Cannot activate full-text search for table '%ls' because no columns have been enabled for full-text search.

15610

16

You must deactivate full-text search on table '%ls' before adding columns to or removing columns from the full-text index.

15611

16

Column '%ls' of table '%ls' cannot be used for full-text search because it is not a character-based column.

15612

16

DBCC DBCONTROL error. Database was not made read-only.

15613

0

The database is now read-only.

15614

0

The database already is read-only.

15615

16

DBCC DBCONTROL error. Database was not made single user.

15616

0

The database is now single user.

15617

0

The database already is single user.

15618

0

The database is now read/write.

15619

0

The database already is read/write.

15620

0

The database is now multiuser.

15621

0

The database already is multiuser.

15622

10

No permission to access database '%s'.

Errors 16000 - 16999

Error

Severity

Description

16801

11

sp_dropwebtask requires at least one defined parameter @outputfile or @procname.

16802

11

sp_dropwebtask cannot find the specified task.

16803

11

sp_runwebtask requires at least one defined parameter @outputfile or @procname.

16804

11

SQL Web Assistant: Could not establish a local connection to SQL Server.

16805

11

SQL Web Assistant: Could not execute the SQL statement.

16806

11

SQL Web Assistant: Could not bind the parameter to the SQL statement.

16807

11

SQL Web Assistant: Could not obtain a bind token.

16808

11

SQL Web Assistant: Could not find the existing trigger. This could be due to encryption.

16809

11

SQL Web Assistant failed on the call to SQLGetData.

16810

11

SQL Web Assistant failed on the call to SQLFetch.

16811

11

SQL Web Assistant failed to bind a results column.

16812

11

SQL Web Assistant: The @query parameter must be specified.

16813

11

SQL Web Assistant: Parameters can be passed either by name or position.

16814

11

SQL Web Assistant: Invalid parameter.

16815

11

SQL Web Assistant: @procname is not valid.

16816

11

SQL Web Assistant: @outputfile is not valid.

16817

11

SQL Web Assistant: Could not read the given file.

16820

11

SQL Web Assistant failed because the state of the Web task in msdb..MSwebtasks is invalid.

16821

11

SQL Web Assistant: Could not open the output file.

16822

11

SQL Web Assistant: Could not open the template file.

16823

11

SQL Web Assistant: Could not allocate enough memory to satisfy this request.

16824

11

SQL Web Assistant: The template file specified in the Web task has a bad size.

16825

11

SQL Web Assistant: Could not read the template file.

16826

11

SQL Web Assistant: Could not find the specified marker for data insertion in the template file.

16827

11

SQL Web Assistant: Could not write to the output file.

16828

11

SQL Web Assistant: @tabborder must be tinyint.

16829

11

SQL Web Assistant: @singlerow must be 0 or 1. Cannot specify this parameter with @nrowsperpage.

16830

11

SQL Web Assistant: The @blobfmt parameter specification is invalid.

16831

11

SQL Web Assistant: The output file name is mandatory for every column specified in the @blobfmt parameter.

16832

11

SQL Web Assistant: Procedure called with too many parameters.

16833

11

SQL Web Assistant: @nrowsperpage must be a positive number and it cannot be used with @singlerow.

16834

11

SQL Web Assistant: Read/write operation on text, ntext, or image column failed.

16838

11

SQL Web Assistant: Could not find the table in the HTML file.

16839

11

SQL Web Assistant: Could not find the matching end table tag in the HTML file.

16841

11

SQL Web Assistant: The @datachg parameter cannot be specified with the given @whentype value.

16842

11

SQL Web Assistant: Could not find and drop the necessary trigger for updating the Web page.

16843

11

SQL Web Assistant: Could not add the necessary trigger for the @datachg parameter. There could be an existing trigger on the table with missing or encrypted text.

16844

11

SQL Web Assistant: Incorrect syntax for the @datachg parameter.

16845

11

SQL Web Assistant: @datachg must be specified for the given @whentype option.

16846

11

SQL Web Assistant: @unittype and/or @numunits must be specified for the given @whentype option.

16847

11

SQL Web Assistant: @fixedfont must be 0 or 1.

16848

11

SQL Web Assistant: @bold must be 0 or 1.

16849

11

SQL Web Assistant: @italic must be 0 or 1.

16850

11

SQL Web Assistant: @colheaders must be 0 or 1.

16851

11

SQL Web Assistant: @lastupdated must be 0 or 1.

16852

11

SQL Web Assistant: @HTMLheader must be in the range
1 to 6.

16853

11

SQL Web Assistant: @username is not valid.

16854

11

SQL Web Assistant: @dbname is not valid.

16855

11

SQL Web Assistant: @whentype must be in the range 1 to 9.

16856

11

SQL Web Assistant: @unittype must be in the range 1 to 4.

16857

11

SQL Web Assistant: @targetdate is invalid. It must be a valid date after 1900-01-01.

16858

11

SQL Web Assistant: The @targettime parameter must be between 0 and 240000.

16859

11

SQL Web Assistant: @dayflags must be 1, 2, 4, 8, 16, 32, or 64.

16860

11

SQL Web Assistant: @numunits must be greater than 0.

16861

11

SQL Web Assistant: @targetdate must be specified for the given @whentype option.

16862

11

SQL Web Assistant: @dayflags must be specified for the given @whentype option.

16863

11

SQL Web Assistant: URL specification is invalid.

16864

11

SQL Web Assistant: @blobfmt is invalid. The file must include the full path to the output_file location.

16865

11

SQL Web Assistant: URL hyperlink text column must not be of the image data type.

16866

11

SQL Web Assistant: Could not obtain the number of columns in @query.

16867

11

SQL Web Assistant: URL hyperlink text column is missing in @query.

16868

11

SQL Web Assistant failed on the call to SQLColAttribute.

16869

11

SQL Web Assistant: Columns of data type image cannot have a template.

16870

11

SQL Web Assistant: Internal error. Could not read @ parameters.

16871

11

SQL Web Assistant: Invalid @charset. Execute sp_enumcodepages for a list of character sets.

16873

11

SQL Web Assistant: Invalid @codepage. Execute sp_enumcodepages for a list of code pages.

16874

11

SQL Web Assistant: Internal error. Cannot translate to the specified code page.

16875

11

SQL Web Assistant: Translation to the desired code page is unavailable on this system.

16876

11

SQL Web Assistant: Internal error. Could not obtain COM interface ID.

16877

11

SQL Web Assistant: Internal error. Could not obtain COM language ID.

16878

11

SQL Web Assistant: Internal error. Could not initialize COM library.

16879

11

SQL Web Assistant: Internal error. Could not translate from Unicode to the specified code page.

16880

11

SQL Web Assistant: Internal error. Could not create translation object. Make sure that the file MLang.dll is in your system directory.

16881

16

SQL Web Assistant: This version is not supported on Win32s of Windows 3.1.

16882

16

SQL Web Assistant: Web task not found. Verify the name of the task for possible errors.

16883

16

SQL Web Assistant: Could not list Web task parameters. xp_readwebtask requires @procname.

16884

16

SQL Web Assistant: Procedure name is required to convert Web tasks.

16885

16

SQL Web Assistant: Could not upgrade the Web task to 7.0. The Web task will remain in 6.5 format and will need to be re-created.

16886

16

SQL Web Assistant: Could not update Web tasks system table. The Web task remains in 6.5 format.

16887

16

SQL Web Assistant: @procname parameter is missing. The parameter is required to upgrade a Web task to 7.0.

16888

16

SQL Web Assistant: Source code page is not supported on the system. Ensure @charset and @codepage language files are installed on your system.

16889

16

SQL Web Assistant: Could not send Web task row to the client.

16890

16

SQL Web Assistant: ODS error occurred. Could not send Web task parameters.

16901

16

%hs: This feature has not been implemented yet.

16902

16

%hs: The value of parameter %hs is invalid.

16903

16

%hs procedure called with incorrect number of parameters.

16904

16

sp_cursor: optype: You can only specify ABSOLUTE in conjunction with DELETE or UPDATE.

16905

16

The cursor is already open.

16907

16

%hs is not allowed in cursor statements.

16909

16

%hs: The cursor identifier value provided (%x) is not valid.

16911

16

%hs: The fetch type %hs cannot be used with forward only cursors.

16914

16

%hs procedure called with too many parameters.

16915

16

A cursor with the name '%.*ls' already exists.

16916

16

A cursor with the name '%.*ls' does not exist.

16917

16

Cursor is not open.

16922

16

Cursor Fetch: Implicit conversion from data type %s to %s is not allowed.

16924

16

Cursorfetch: The number of variables declared in the INTO list must match that of selected columns.

16925

16

The fetch type %hs cannot be used with dynamic cursors.

16926

16

sp_cursoroption: The column ID (%d) does not correspond to a text, ntext, or image column.

16927

16

sp_cursoroption: The cursor already has a name.

16929

16

The cursor is READ ONLY.

16930

16

The requested row is not in the fetch buffer.

16931

16

There are no rows in the current fetch buffer.

16932

16

The cursor has a FOR UPDATE list and the requested column to be updated is not in this list.

16933

16

The cursor does not include the table being modified.

16934

16

Optimistic concurrency check failed. The row was modified outside of this cursor.

16935

16

No parameter values were specified for the sp_cursor-%hs statement.

16936

16

sp_cursor: One or more values parameters were invalid.

16937

16

A server cursor is not allowed on a stored procedure with more than one SELECT statement. Use a default result set or client cursor.

16938

16

sp_cursoropen/sp_cursorprepare: The statement parameter can only be a single select or a single stored procedure.

16940

16

Cannot specify UPDLOCK or TABLOCKX with READ ONLY or INSENSITIVE cursors.

16941

16

Cursor updates are not allowed on tables opened with the NOLOCK option.

16942

16

Could not generate asynchronous keyset. The cursor has been deallocated.

16943

16

Could not complete cursor operation because the table schema changed after the cursor was declared.

16944

16

Cannot specify UPDLOCK or TABLOCKX on a read-only table in a cursor.

16945

16

The cursor was not declared.

16946

16

Could not open the cursor because one or more of its tables have gone out of scope.

16947

10

No rows were updated or deleted.

16948

16

The variable '%.*ls' is not a cursor variable, but it is used in a place where a cursor variable is expected.

16949

16

The variable '%.*ls' is a cursor variable, but it is used in a place where a cursor variable is not valid.

16950

10

The variable '%.*ls' does not currently have a cursor allocated to it.

16951

16

The variable '%.*ls' cannot be used as a parameter because a CURSOR OUTPUT parameter must not have a cursor allocated to it before execution of the procedure.

16952

16

A cursor variable cannot be used as a parameter to a remote procedure call.

16953

10

Updatable keyset cursors on remote tables require a transaction with the REPEATABLE_READ or SERIALIZABLE isolation level.

16954

16

Executing SQL directly; no cursor.

16955

16

Could not create an acceptable cursor.

16956

10

Cursor created was not of the requested type.

16997

16

Could not create cursor because worktable rows of size %d exceed maximum rowsize of %d bytes. Use fewer columns in the declaration.

16998

20

Internal Cursor Error: A cursor work table operation failed.

16999

20

Internal Cursor Error: The cursor is in an invalid state.

Errors 17000 - 17999

Error

Severity

Description

17000

10

Usage: sp_autostats <table_name> [, {ON|OFF} [, <index_name>] ]

17026

10

Using '%1' version '%2'.

17050

16

initerrlog: Could not open error log file '%1'. Operating system error = %2.

17052

10

%1

17053

16

%1: Operating system error %2 encountered.

17054

16

LogEvent: Failed to report the current event. Operating system error = %1.

17055

16

%1 :%n%2

17059

16

Operating system error %1!d!.

17065

16

SQL Server Assertion: File: <%1>, line = %2!d! %nFailed Assertion = '%3' %4.

17066

16

SQL Server Assertion: File: <%1>, line=%2!d! %nFailed Assertion = '%3'.

17067

16

SQL Server Assertion: File: <%1>, line = %2!d! %n%3.

17068

10

PrintStack Request

17112

16

Invalid command option %1!c!.

17113

16

initconfig: Error %2 opening '%1' for configuration information.

17114

16

initconfig: Error %2 reading configuration information from '%1'.

17117

10

initconfig: Number of user connections reduced to %1!ld!.

17118

10

upinit: Warning: Could not raise priority of %1 thread.

17119

10

initconfig: Number of server processes reduced to %1!ld!.

17120

16

SQL Server could not spawn %1 process.

17121

16

SQL Server could not spawn first connection handler.

17122

16

initdata: Warning: Could not set working set size to %1!d! KB.

17123

16

initdata: Could not create thread local storage.

17127

16

initdata: No memory for kernel buffer hash table.

17128

16

initdata: No memory for kernel buffers.

17130

16

initdata: No memory for kernel locks.

17131

16

initdata: Not enough memory for descriptor hash tables.

17132

16

initdata: Not enough memory for descriptors.

17134

16

initmaster: Could not allocate process status structure (PSS).

17138

16

Could not allocate enough memory for data initialization.

17140

16

Could not dispatch SQL Server by Service Control Manager. Operating system error = %1.

17141

16

Could not register Service Control Handler. Operating system error = %1.

17142

16

SQL Server has been paused. No new connections will be allowed.

17143

16

%1: Could not set Service Control Status. Operating system error = %2.

17144

10

SQL Server is disallowing new connections due to 'pause' request from Service Control Manager.

17145

10

Service Control Handler received an invalid control code = %1!d!.

17146

10

SQL Server is allowing new connections due to 'continue' request from Service Control Manager.

17147

10

SQL Server terminating because of system shutdown.

17148

10

SQL Server is terminating due to 'stop' request from Service Control Manager.

17150

16

%1: Error in spawning console process.

17151

10

Maximum number of pages in batch I/O is limited to %1!ld!.

17154

16

initdata: Not enough memory for procedure cache/hash table.

17156

16

initeventlog: Could not initiate the EventLog Service for the key '%1'.

17157

16

%1: Could not initialize Communication Layer.

17158

16

Could not use OPENDSNT.DLL version '%1'. OPENDSNT.DLL version '%2' was expected.

17160

16

Could not use SQLEVN70.DLL version '%1'. SQLEVN70.DLL version '%2' was expected.

17161

10

Master device sector size is %1!d!. SQL Server cannot use the NO_BUFFERING option during I/O.

17162

10

SQL Server is starting at priority class '%1'(%2!d! %3 detected).

17204

16

%1: Could not open device %2 for virtual device number (VDN) %3!d!.

17207

16

%1: Operating system error %3 during the creation/opening of physical device %2.

17208

16

%1: File '%2' has an incorrect size (%3!d! MB, should be %4!d! MB).

17218

16

%1: Operating system error %2 on device '%3' (virtual page %4).

17249

16

%1: Negative outstanding I/O count in process ID = %2!d!.

17252

16

%1: Actual bytes transferred (%2!d!) does not match requested amount (%3!d!) on device '%4' (virtual page %5).

17253

10

The sector size for device %1 is %2!d!. SQL Server cannot use the NO_BUFFERING option during I/O on this device.

17254

10

Warning: Cannot use NO_BUFFERING option on '%1'. Operating system error %2.

17300

16

Not enough memory for process status structure (PSS) allocation.

17302

16

The maximum limit for connections has been reached.

17303

16

freepss: Bad process status structure (PSS) value.

17304

10

Warning: Clean_process system function called from another thread. Outstanding I/O may not complete.

17308

16

%1: Process %2!d! generated an access violation. SQL Server is terminating this process.

17309

16

The current contents of process' input buffer are '%1'.

17310

16

%1: Process %2!d! generated fatal exception %3!lx! %4. SQL Server is terminating this process.

17311

16

SQL Server is aborting. Fatal exception %1!lx! caught.

17402

10

Database '%1' set to single user mode.

17422

16

closetable: Called with null session descriptor (SDES), server process ID (SPID) %1!d!.

17423

16

closetable: Table already closed for session descriptor (SDES) %1!08lx!.

17424

10

Warning: OPEN OBJECTS parameter may be too low.

17426

16

Run sp_configure to increase the parameter value.

17429

16

The srchindex system function failed for index ID = %1!d!, sridoff = %2!d!.

17430

10

Database '%1' set to read only mode.

17550

10

DBCC TRACEON %d, server process ID (SPID) %d.

17551

10

DBCC TRACEOFF %d, server process ID (SPID) %d.

17557

16

DBCC DBRECOVER failed for database ID %d.

17558

10

%\*** Bypassing recovery for database ID %d.

17560

10

DBCC DBREPAIR: '%ls' index restored for '%ls.%ls'.

17561

10

'%ls' index restored for '%ls.%ls'.

17569

16

DBCC cannot find the library initialization function %ls.

17570

16

DBCC cannot find the function %ls in the library %ls.

17571

20

DBCC function %ls in the library %ls generated an access violation. SQL Server is terminating process %d.

17572

16

DBCC cannot free DLL %ls. SQL Server depends on this DLL to function properly.

17654

10

Warning: Process status structure (PSS) found with open session descriptor (SDES). PSPID %1!d!, PSUID %2!d!, PCURDB %3!d!, range entry %4!d!, SDESP 0x%5!lx!, object ID %6!ld!.

17657

10

Attempting to change default sort order ID from %1!d! to %2!d!.

17658

10

SQL Server started in single user mode. Updates allowed to system catalogs.

17660

10

Starting without recovery.

17661

10

Recovering all databases but not clearing tempdb.

17669

10

Table still open. Database ID %1!d!, table ID %2!ld!.

17674

10

Login: %1 %2, server process ID (SPID): %3!d!, kernel process ID (KPID): %4!d!.

17676

10

SQL Server shutdown due to Ctrl-C or Ctrl-Break signal.

17750

16

Cannot load the DLL %ls, or one of the DLLs it references. Reason: %ls.

17751

16

Cannot find the function %ls in the library %ls. Reason: %ls.

17752

16

Extended procedure memory allocation failed for '%ls'.

17753

16

%.*ls can only be executed in the master database.

17801

16

Unknown internal error value.

17802

16

Could not create server event thread.

17803

16

Insufficient memory available.

17804

16

Invalid 'nbytes' value.

17805

16

Invalid buffer received from client.

17806

16

Invalid event specification.

17807

16

Invalid event '%1!ld!'.

17808

16

Invalid starting position specified.

17809 (ODS)

10

Could not connect. The maximum number of '%1!ld!' configured user connections are already connected. The system administrator can change the maximum to a higher value using sp_configure.

17810

16

Could not set up Named Pipe.

17811

16

Requested data-conversion does not exist.

17812

16

Data conversion resulted in overflow.

17813

16

Could not convert data due to syntax error in source field.

17814

16

Invalid function parameter.

17815

10

No longer waiting for client connections using '%1!hs!'.

17816

16

No active RPC or parameter value out of range.

17817

16

No active RPC or no parameters.

17818

16

No active RPC or parameter name not found.

17819

16

No active RPC.

17820

16

Invalid data type parameter.

17821

16

Could not set up subchannel.

17822

16

Could not load ListenOn Net-Library '%1!hs!'.

17823

16

Could not read from ListenOn connection.

17824 (Open Data Services)

16

Could not write to ListenOn connection '%1!hs!', loginname '%2!ls!', hostname '%3!ls!'. Connection closed.

17825

16

Could not close ListenOn connection.

17826

16

Could not set up ListenOn connection '%1!hs!'.

17827

10

The maximum number of '%1!ld!' remote connections are currently in use.

17828

16

Could not read from local subchannel Named Pipe.

17829

16

Could not copy buffer to subchannel thread, subchannel closed.

17830

16

A subchannel protocol error has occurred.

17831

16

Could not load ListenOn Net-Library '%1!hs!' version '%2!hs!'. Need Net-Library version '%3!hs!' or greater.

17832

16

Connection opened but invalid login packet(s) sent. Connection closed.

17833

16

ListenOn connection '%1!hs!' is already in use.

17834

10

Using '%1!hs!' version '%2!hs!' to listen on '%3!hs!'.

17835

16

Configured for local access only.

17836

16

Could not create I/O completion port.

17837

16

char data type%0

17838

16

variable-length char data type%0

17839

16

binary data type%0

17840

16

variable-length binary data type%0

17841

16

1-byte integer data type%0

17842

16

2-byte integer data type%0

17843

16

4-byte integer data type%0

17844

16

bit data type%0

17845

16

datetime data type%0

17846

16

datetime data type, nulls allowed%0

17847

16

money data type%0

17848

16

money data type, nulls allowed%0

17849

16

4-byte float data type, nulls allowed%0

17850

16

8-byte float data type%0

17851

16

8-byte float data type, nulls allowed%0

17852

16

4-byte datetime data type, nulls allowed%0

17853

16

4-byte money data type%0

17854

16

event type%0

17855

16

done packet status field%0

17856

16

error severity type%0

17857

16

4-byte integer data type, nulls allowed%0

17858

16

image data type%0

17859

16

text data type%0

17868

16

numeric data type%0

17869

16

numeric data type, nulls allowed%0

17870

16

decimal data type%0

17871

16

decimal data type, nulls allowed%0

17872

16

bit data type, nulls allowed%0

17873

16

8000-byte variable-length binary data type%0

17874

16

8000-byte variable-length character data type%0

17875

16

8000-byte binary data type%0

17876

16

8000-byte character data type%0

17877

16

8000-byte Unicode character data type%0

17878

16

8000-byte Unicode variable-length character data type%0

17879

16

Unicode text data type%0

17880

16

uniqueidentifier data type%0

Errors 18000 - 18999

Error

Severity

Description

18002

20

Stored function '%.*ls' in the library '%.*ls' generated an access violation. SQL Server is terminating process %d.

18052

16

Error: %1!d!, Severity: %2!d!, State: %3!d!.

18053

16

Error: %1!d!, Severity: %2!d!, State: %3!d!%n%4%5.

18100

10

Process ID %d killed by hostname %.*ls, host process ID %d.

18101

10

Non-Unicode sort order being reconfigured:

18102

10

old value = %d new value = %d

18103

10

Non-Unicode character set also being reconfigured:

18112

10

Non-Unicode sort order successfully changed.

18113

10

SQL Server shutdown after verifying system indexes.

18114

16

Cannot install '%1' because there can be at most %2!d! languages in cache.

18122

10

Unicode locale ID being reconfigured:

18123

10

Unicode comparison style being reconfigured:

18124

10

Unicode collation successfully changed.

18200

16

%1: Backup device ID %2!d! out of range.

18201

16

ksconsole: Cannot create ConsBufMutex: %1.

18203

16

ksconsole: Cannot create %1 : %2.

18204

16

%1: Backup device '%2' failed to %3. Operating system
error = %4.

18205

16

%1: Could not initialize console operation.

18207

16

%1: Null request packet.

18208

16

%1: Backup device ID %2!d! is not active.

18209

16

ksconsole: Could not send request to console client.

18210

16

%1: %2 failure on backup device '%3'. Operating system
error %4.

18211

16

ksconsole: Could not receive request from console client.

18213

16

ksconsole: Console input request for type 0x%1!x!, ID 0x%2!x! failed.

18214

16

%1: Server console thread not running.

18215

16

%1: Response type 0x%2!x!, ID 0x%3!x! not found in request.

18216

16

%1: Could not access console mutex. Operating system
error %2.

18217

16

%1: Type 0x%2!x! not implemented.

18218

16

%1: Incorrect number of parameters: %2!d!.

18219

16

ksconsole: Could not close console connection.

18221

10

ksconsole: Reinitializing the console.

18223

16

%1: No console client connected. Start CONSOLE.EXE.

18225

10

Tape '%1' (Family ID: %2, sequence %3) mounted on tape drive '%4'.

18227

10

Unnamed tape (Family ID: %1, sequence %2) mounted on tape drive '%3'.

18257

10

%1: Device or media does not support %2.

18264

10

Database backed up with following information: Database: %1, creation date and time: %2(%3), pages dumped: %4!d!, first LSN: %5, last LSN: %6, sort order: %7!d!, striped: %8, number of dump devices: %9!d!, device information: (%10).

18265

10

Log backed up with following information: Database: %1, creation date and time: %2(%3), first LSN: %4, last LSN: %5, striped: %6, number of dump devices: %7!d!, device information: (%8).

18266

10

Database file backed up with following information: Database: %1, creation date and time: %2(%3), file list: (%4), pages dumped: %5!d!, sort order: %6!d!, striped: %7, number of dump devices: %8!d!, device information: (%9).

18267

10

Database restored: Database: %1, creation date and time: %2(%3), first LSN: %4, last LSN: %5, striped: %6, number of dump devices: %7!d!, device information: (%8).

18268

10

Log restored: Database: %1, creation date and time: %2(%3), first LSN: %4, last LSN: %5, striped: %6, number of dump devices: %7!d!, device information: (%8).

18269

10

Database file restored: Database: %1, creation date and time: %2(%3), file list: (%4), striped: %5, number of dump devices: %6!d!, device information: (%7).

18270

10

Database incremental changes backed up with following information: Database: %1, creation date and time: %2(%3), pages dumped: %4!d!, first LSN: %5, last LSN: %6, full backup LSN: %7, sort order: %8!d!, striped: %9, number of dump devices: %10!d!, device

18271

10

Database incremental changes restored: Database: %1, creation date and time: %2(%3), first LSN: %4, last LSN: %5, striped: %6, number of dump devices: %7!d!, device information: (%8).

18272

16

I/O error on backup or restore restart-checkpoint file '%1'. Operating system error %2. The statement is proceeding but is non-restartable.

18400

16

Checkpoint process is terminating due to a fatal exception.

18450

14

Login failed for user '%ls'. Reason: Not defined as a valid user of a trusted SQL Server connection.

18452

14

Login failed for user '%ls'. Reason: Not associated with a trusted SQL Server connection.

18453

14

Login succeeded for user '%ls'. Connection: Trusted.

18454

14

Login succeeded for user '%ls'. Connection: Non-Trusted.

18455

14

Login succeeded for user '%ls'.

18456

14

Login failed for user '%ls'.

18457

14

Login failed for user '%ls'. Reason: User name contains a mapping character or is longer than 30 characters.

18458

14

Login failed. The maximum simultaneous user count of %d licenses for this server has been exceeded. Additional licenses should be obtained and registered through the Licensing application in the Windows NT Control Panel.

18459

14

Login failed. The maximum workstation licensing limit for SQL Server access has been exceeded.

18460

14

Login failed. The maximum simultaneous user count of %d licenses for this '%ls' server has been exceeded. Additional licenses should be obtained and installed or you should upgrade to a full version.

18482

16

Could not connect to server '%ls' because '%ls' is not defined as a remote server.

18483

16

Could not connect to server '%ls' because '%ls' is not defined as a remote login at the server.

18485

16

Could not connect to server '%ls' because it is not configured for remote access.

18490

16

Maximum number of processors supported is '%1!ld!'.

18491

16

Could not start due to invalid serial number.

18492

16

The license agreement has been violated for this '%1' version of SQL Server. Cannot start.

18500

16

Could not load startup handler DLL '%1'.

18501

16

Could not load startup handler function '%1'.

18502

16

Could not add startup handler '%1'.

18666

17

Could not free up descriptor in rel_desclosed() system function.

18750

16

%ls: The parameter '%ls' is invalid.

18751

16

%ls procedure called with incorrect number of parameters.

18752

16

Another log reader is replicating the database.

18754

16

Could not open table %d.

18755

16

Could not allocate memory for replication.

18756

16

Could not get replication information for table %d.

18757

16

The database is not published.

18759

16

Replication failure. File '%ls', line %d.

18760

16

Invalid %ls statement for article %d.

18761

16

Commit record at (%ls) has already been distributed. Check DBTABLE.

18762

16

Invalid begin LSN (%ls) for commit record (%ls). Check DBTABLE.

18763

16

Commit record (%ls) reports oldest active LSN as (0:0:0).

18764

16

Execution of filter stored procedure %d failed. See the SQL Server errorlog for more information.

18765

16

Begin LSN specified for replication log scan is invalid.

18766

16

The replbeginlsn field in the DBTABLE is invalid.

18767

16

The specified begin LSN (%ls) for replication log scan occurs before replbeginlsn (%ls).

18768

16

The specified LSN (%ls) for repldone log scan occurs before the current start of log (%ls).

18769

16

The specified LSN (%ls) for repldone log scan is not a replicated commit record.

18831

16

;// Database ID %d. Could not find object descriptor for object ID %ld.

18833

16

Database ID %d. Could not find clustered index on system table ID %ld. This index should exist in all databases. Run DBCC CHECKTABLE on sysindexes in the database.

18836

16

Database ID %d. Could not find object ID %ld in sysobjects. This system catalog should exist in all databases. Run DBCC CHECKTABLE on sysobjects in this database.

18841

16

Could not locate entry in sysdatabases for database '%.*ls'. No entry found with that name.

18843

16

Could not find database ID %d in sysdatabases.

18872

16

Rec_finish: getnext SCAN_NOINDEX on sysdatabases.dbid=%d failed.

18874

16

Rec_complete: Could not open controlling database (ID %d) of controlling database in multi-database transaction.

18875

16

Recovering database '%.*s'.

18876

16

%d transactions rolled forward in database '%.*ls' (%d).

18877

16

%d transactions rolled back in database '%.*ls' (%d).

18878

16

Recovery complete.

18883

16

;//Database ID %d: Attempt to mark database SUSPECT. Getnext NC scan on sysobjects.dbid failed.

18884

16

;//Database '%.*s' (ID %d). Recovery failed. Run DBCC.

18885

16

Page #%lx from table ID #%ld, database ID #%d, not found in cache.

18886

16

Page #%lx from sysindexes in database ID #%X not in cache after reading it into cache.

18887

16

Cannot recover the master database. Exiting.

18892

16

Extent ID %ld which should belong to syslogs belongs to object ID %ld.

18894

16

No more room in the transaction table.

18895

16

Transaction (%d, %d) not found in the transaction table.

18901

16

Could not build an allocation map for the database '%.*s'. Database does not have a DBINFO structure.

Errors 19000 -19999

Error

Severity

Description

19000

16

ODBC error encountered, State = %1, native error = %2, error message = %3.

19001

16

Windows NT Error encountered, %1.

19002

16

MS SQL SNMP Extension Agent starting, %1, version %2.

19003

16

MS SQL SNMP Extension Agent reconnecting.

19004

16

MS SQL SNMP Extension Agent stopping.

19020

16

RPC Net-Library listening on: %1.

Errors 20000 - 20999

Error

Severity

Description

20001

0

There is no nickname for article '%s' in publication '%s'.

20002

0

The filter '%s' already exists for article '%s' in publication '%s'.

20003

0

Could not generate nickname for '%s'.

20007

16

The system tables for merge replication could not be dropped successfully.

20008

16

The system tables for merge replication could not be created successfully.

20009

16

The article '%s' could not be added to the publication '%s'.

20010

16

The Snapshot Agent corresponding to the publication '%s' could not be dropped.

20011

16

Cannot set incompatible publication properties. The 'allow_anonymous' property of a publication depends on the 'immediate_sync' property.

20012

16

The subscription type '%s' is not allowed on publication '%s'.

20013

16

The publication property '%s' cannot be changed when there are subscriptions on it.

20014

16

Invalid @schema_option value.

20015

16

Could not remove directory '%ls'. Check the security context of xp_cmdshell and close other processes that may be accessing the directory.

20016

16

Invalid @subscription_type value. Valid values are 'pull' or 'anonymous'.

20017

16

The Subscriber side subscription does not exist.

20018

16

The @optional_command_line is too long. Use an agent definition file.

20019

16

The value must be 'name', 'description', 'subset_filterclause', 'column_tracking', 'article_resolver', 'resolver_procedure', 'status', 'pre_creation_command', 'creation_script', or 'schema_option'.

20020

16

The article resolver supplied is either invalid or nonexistent.

20021

16

The subscription could not be found.

20023

16

Invalid @subscriber_type value. Valid options are 'local', 'global', 'anonymous', or 'repub'.

20025

16

The publication name must be unique. The specified publication name '%s' has already been used.

20026

16

The publication '%s' does not exist.

20027

16

The article '%s' does not exist.

20028

16

The Distributor has not been installed correctly. Could not enable database for publishing.

20029

16

The distributor has not been installed correctly. Could not disable database for publishing.

20030

16

The article '%s' already exists in another publication with a different column tracking option.

20031

16

Could not delete the row could because it was not present.

20032

16

'%s' is not defined as a Subscriber for '%s'.

20033

16

Invalid publication type.

20034

16

Publication '%s' does not support '%s' subscriptions.

20036

16

The Distributor has not been installed correctly.

20037

16

The article '%s' already exists in another publication with a different article resolver.

20038

16

The article filter could not be added to the article '%s' in the publication '%s'.

20039

16

The article filter could not be dropped from the article '%s' in the publication '%s'.

20040

16

Could not drop the article(s) from the publication '%s'.

20041

16

Transaction rolled back. Could not execute trigger. Retry your transaction.

20043

16

Could not change the article '%s' because the publication has already been activated.

20044

16

The priority property is invalid for local subscribers.

20045

16

You must supply an article name.

20046

16

The article does not exist.

20047

16

You are not authorized to perform this operation.

20049

16

The priority value should not be larger than 100.0.

20050

16

The retention period must be greater than or equal to %d.

20051

16

The Subscriber is not a registered Subscriber.

20054

16

Current database is not enabled for publishing.

20055

16

Table '%s' cannot be published for merge replication because it has a timestamp column.

20056

16

Table '%s' cannot be republished.

20057

16

The profile name '%s' already exists for the specified agent type.

20058

16

The @agent_type must be 1 (Snapshot), 2 (Logreader), 3 (Distribution), or 4 (Merge)

20059

16

The @profile_type must be 0 (system) or 1 (Custom)

20060

16

Compatibility level can not be smaller than 60.

20061

16

The compatibility level of this database must be set to 70 or higher to be enabled for merge publishing.

20062

16

Update of columns with the rowguidcol property is not allowed.

20064

16

Cannot drop profile. Either it is not defined, or is defined as the default profile.

20065

16

Cannot drop profile, because it is in use.

20066

16

Profile not defined.

20067

16

The parameter name '%s' already exists for the specified profile.

20068

16

The article cannot be created on table '%s' because it has more than %d columns.

20069

16

Cannot validate a merge article that uses looping join filters.

20070

16

Cannot update subscription row.

20071

16

Cannot find the publication named '%s'.

20072

16

Cannot update Subscriber information row.

20073

16

Articles can only be added or changed at the publisher.

20074

16

Only tables can be published for merge replication.

20075

16

The @status parameter value must be 'active', 'inactive', or 'unsynced'.

20076

16

The @sync_mode parameter value must be 'native' or 'character'.

20077

16

Problem encountered generating replica nickname.

20078

16

The @property parameter value must be 'sync_type', 'priority', or 'description'.

20079

16

Invalid @subscription_type parameter value. Valid options are 'push', 'pull', or 'both'.

20080

16

Cannot publish table '%s' for merge replication because it has a computed column.

20081

16

Publication property '%s' cannot be NULL.

20082

16

Column '%s' cannot be published for replication because it is a computed column.

20083

16

Table '%s' cannot be published for replication because it includes a computed column.

20084

16

Publication '%s' cannot be subscribed to by Subscriber database '%s'.

20086

16

Publication '%s' does not support the nosync type because it contains a table that does not have a rowguidcol column.

20087

16

You cannot push an anonymous subscription.

20088

16

You can only assign priorities that are greater than or equal to 0 and less than 100.

20089

16

Could not get license information correctly.

20090

16

Could not get version information correctly.

20091

16

sp_mergesubscription_cleanup is used to clean up push subscriptions. Use sp_dropmergepullsubscription to clean up pull or anonymous subscriptions.

20100

16

Cannot drop Subscriber '%s'. There are existing subscriptions.

20500

16

The updatable Subscriber stored procedure '%s' does not exist in sysobjects.

20501

16

Could not insert into sysarticleupdates using sp_articlecolumn.

20502

16

Invalid '%s' value. Valid values are 'read only' or 'sync tran'.

20503

16

Invalid '%s' value in '%s'. The publication is not enabled for updatable Subscribers.

20505

16

Could not drop synchronous update stored procedure '%s' in '%s'.

20506

16

Source table '%s' not found in '%s'.

20507

16

Table '%s' not found in '%s'.

20508

16

Updatable Subscribers: The text/ntext/image values inserted at Subscriber will be NULL.

20509

16

Updatable Subscribers: The text/ntext/image values cannot be updated at Subscriber.

20510

16

Updatable Subscribers: Cannot update identity columns.

20511

16

Updatable Subscribers: Cannot update timestamp columns.

20512

16

Updatable Subscribers: Rolling back transaction.

20515

16

Updatable Subscribers: Rows do not match between Publisher and Subscriber. Refresh rows at Subscriber.

20516

16

Updatable Subscribers: Replica is not updatable.

20517

16

Updatable Subscribers: Update of replica's primary key is not allowed unless published table has a timestamp column.

20518

16

Updatable Subscribers: INSERT and DELETE operations are not supported unless published table has a timestamp column.

20519

16

Updatable Subscribers: INSERT operations on tables with identity or timestamp columns are not allowed unless a primary key is defined at the Subscriber.

20520

16

Updatable Subscribers: UPDATE operations on tables with identity or timestamp columns are not allowed unless a primary key is defined at the Subscriber.

20521

16

sp_MSmark_proc_norepl: Must be a member of the db_owner or sysadmin roles.

20522

16

sp_MSmark_proc_norepl: Invalid object name '%s'.

20523

16

Could not validate the article '%s'. It is not activated.

20524

10

Table '%s' may be out of synchronization. Rowcount difference (actual: %d, expected: %d). Rowcount method %d used
(0 = Full, 1 = Fast).

20525

10

Table '%s' is out of synchronization. Rowcounts (actual: %d, expected %d). Checksum difference (actual: %s, expected: %s).

20526

10

Table '%s' passed rowcount (%d) validation. Rowcount method %d used (0 = Full, 1 = Fast).

20527

10

Table '%s' passed rowcount (%d) and checksum validation. (Note: checksum is not compared for any text and image columns.)

20528

10

Log agent startup message.

20529

10

Starting agent.

20530

10

Run agent.

20531

10

Detect nonlogged agent shutdown.

20532

10

Replication Agent Schedule.

20533

10

Replication agents checkup.

20534

10

Detects replication agents that are not actively logging history.

20535

10

Removes replication agent history from the distribution database.

20536

10

Replication: Agent failure.

20537

10

Replication: Agent retry.

20538

10

Replication: Expired subscription dropped.

20540

10

Replication: Agent success.

20541

10

Removes replicated transactions from the distribution database.

20542

10

Detects and removes expired subscriptions from published databases.

20545

10

Default agent profile.

20546

10

Verbose history agent profile.

20547

10

Agent profile for detailed history logging.

20548

10

Slow link agent profile.

20549

10

Agent profile for low bandwidth connections.

20552

10

Could not clean up the distribution transaction tables.

20553

10

Could not clean up the distribution history tables.

20554

10

The agent is suspect. No response within last %ld minutes.

20555

10

6.x publication.

20556

10

Detected heartbeats for all running replication agents.

20557

10

Agent shutdown. For more information see the SQL Server Agent job history for job '%s'.

20558

10

Table '%s' passed full rowcount validation after failing the fast check. DBCC UPDATEUSAGE will be automatically initiated.

20559

10

Conditional Fast Rowcount method requested without specifying an expected count. Fast method will be used.

20560

10

An expected checksum value was passed, but checksums will not be compared because rowcount only checking was requested.

20561

10

Generated expected rowcount value of %d for %s.

20562

10

User delete.

20563

10

No longer belongs in this partial.

20564

10

System delete.

20565

10

Replication: Subscriber has failed data validation.

20566

10

Replication: Subscriber has passed data validation.

20567

10

Agent history clean up: %s.

20568

10

Distribution clean up: %s.

20569

10

Expired subscription clean up.

20570

10

Reinitialize subscriptions having data validation failures.

20571

10

Reinitializes all subscriptions that have data validation failures.

20572

10

Subscriber '%s' subscription to article '%s' in publication '%s' has been reinitialized after a validation failure.

20573

10

Replication: Subscription reinitialized after validation failure.

20574

10

Subscriber '%s' subscription to article '%s' in publication '%s' failed data validation.

20575

10

Subscriber '%s' subscription to article '%s' in publication '%s' passed data validation.

20576

10

Subscriber '%s' subscription to article '%s' in publication '%s' has been reinitialized after a synchronization failure.

20577

10

No entries were found in msdb..sysreplicationalerts.

20578

10

Replication: Agent custom shutdown

20579

10

Generated expected rowcount value of %d and expected checksum value of %s for %s.

Errors 21000 -21999

Error

Severity

Description

21000

16

Cannot subscribe to an inactive publication.

21001

16

Cannot add a Distribution Agent at the Subscriber for a push subscription.

21002

16

The Distribution Agent for this subscription already exists (%s).

21003

16

Changing publication names is no longer supported.

21004

16

Cannot publish the stored procedure '%s' because it is encrypted.

21005

10

For backward compatibility, sp_addpublisher can be used to add a Distribution Publisher. However, you should use sp_adddistpublisher, which is more flexible.

21006

16

Cannot use sp_addpublisher to add a Distribution Publisher this time. Use sp_adddistpublisher instead.

21007

16

Cannot add the remote Distributor at this time. Make sure that the local server is configured as a Distribution Publisher at the Distributor.

21008

16

Cannot uninstall the Distributor because there are Subscribers defined.

21009

16

The specified filter procedure is already associated with a table.

21010

16

Removed %ld replicated transactions consisting of %ld statements in %ld seconds (%ld rows/sec).

21011

16

Deactivated subscriptions.

21012

16

Cannot change the 'allow_push' property of the publication to false. There are push subscriptions on it.

21013

16

Cannot change the 'allow_pull' property of the publication to false. There are pull subscriptions on it.

21014

16

The @optname parameter value must be 'transactional' or 'merge'.

21015

16

The replication option '%s' has been set to TRUE already.

21016

16

The replication option '%s' has been set to FALSE already.

21018

16

There are too many consecutive snapshot transactions in the distribution database. Rerun the Log Reader Agent or clean up the distribution database.

21021

16

Drop the Distributor first before you uninstall replication.

21022

16

Cannot set incompatible publication properties. The 'immediate_sync' property of a publication is dependent on the 'independent agent' property of a publication.

21023

16

'%s' is no longer supported.

21024

16

The stored procedure '%s' is already published as an incompatible type.

21025

16

The string being encrypted cannot have null characters.

21026

16

Cannot have an anonymous subscription on a publication that does not have an independent agent.

21027

16

'%s' replication stored procedures are not installed. Use sp_replicationoption to install them first.

21028

16

Replication components are not installed on this server. Run SQL Server Setup again and select the option to install replication.

21029

16

Cannot drop a push subscription entry at the subscriber unless @drop_push is 'true'.

21030

16

Names of SQL Server replication agents cannot be changed.

21031

16

'post_script' is not supported for stored procedure articles.

21032

16

Could not subscribe because non-SQL Server Subscriber '%s' does not support 'sync tran' update mode.

21033

16

Cannot drop server '%s' as Distribution Publisher because there are databases enabled for replication on that server.

21034

16

Rows inserted or updated at the Subscriber are not allowed to be outside the article partition.

21035

16

You have successfully updated the Distribution Publisher property '%s'.

21036

16

Another %s agent for the subscription(s) is running.

21037

16

Invalid working directory '%s'.

21038

16

Windows NT Authentication mode is not supported by the server.

21039

16

The destination owner name is not supported for publications that can be subscribed to by non-SQL Server Subscribers.

21040

16

Publication '%s' does not exist.

21041

16

A remote Distribution Publisher is not allowed on this server version.

21042

16

The Distribution Publisher property, 'distributor_password', has no usage and is not supported for a Distributor running on Windows NT.

21043

16

The Distributor is not installed.

21044

16

Cannot ignore the remote Distributor (@ignore_remote_distributor cannot be 1) when enabling the database for publishing or merge publishing.

21045

16

Cannot uninstall the Distributor because there are databases enabled for publishing or merge publishing.

21046

16

Cannot change Distribution Publisher property 'distribution_db' because the remote Publisher is using the current distribution database.

21047

16

Cannot drop the local Distribution Publisher because there are Subscribers defined.

21048

16

Cannot add login '%s' to the publication access list because it does not have access to the distribution server '%s'.

21049

16

The login '%s' does not have access permission on publication '%s'.

21050

16

Only members of the sysadmin or db_owner roles can perform this operation.

21051

16

Could not subscribe because non-SQL Server Subscriber '%s' does not support custom stored procedures.

21052

16

Transactional publications are supported on Windows NT platforms only.

21053

16

The parameter must be 'description', 'status', 'retention', 'sync_mode', 'allow_push', 'allow_pull', 'allow_anonymous', 'enabled_for_internet', 'centralized_conflicts', or 'snapshot_ready'.

21054

16

Updatable Subscribers: RPC to Publisher failed.

21055

15

Invalid parameter %s specified for %s.

21056

16

The subscription to publication '%s' has expired or does not exist.

21057

16

Anonymous Subscribers are not allowed to have updatable subscriptions.

21058

16

An updatable subscription to publication '%s' on Subscriber '%s' already exists.

21059

16

Cannot reinitialize subscriptions of non-immediate-sync publications.

21060

16

Could not subscribe because non-SQL Server Subscriber '%s' does not support parameterized statements.

21061

16

Invalid article status %d specified when adding article '%s'.

21062

16

The row size of table '%s' exceeds the replication limitation of 6000 bytes.

21063

16

Table '%s' cannot participate in updatable subscriptions because it is published for merge replication.

21070

16

This subscription does not support automatic reinitialization (subscribed with the 'no sync' option). To reinitialize this subscription, you must drop and re-create the subscription.

21071

10

Cannot reinitialize article '%s' in subscription '%s:%s' to publication '%s' (subscribed with the 'no sync' option).

21072

16

The subscription has not been synchronized within the maximum retention period. You must reinitialize the subscription to receive data.

21073

16

The publication specified does not exist.

21074

16

The subscription has expired and must be reinitialized at the Publisher.

21075

10

The initial snapshot for publication '%s' is not yet available.

21076

10

The inital snapshot for article '%s' is not yet available.

21077

10

Deactivated initial snapshot for anonymous publication(s). New subscriptions must wait for the next scheduled snapshot.

21078

16

Table '%s' does not exist in the Subscriber database.

21079

16

The RPC security information for the Publisher is missing or invalid. Use sp_link_publication to set it.

21080

16

The timestamp column has to be in the vertical partition of the article that is enabled for updatable subscriptions.

21081

16

Server setting 'Allow triggers to be fired which fire other triggers (nested triggers)' has to be on at updatable subscribers.

21082

16

Database property 'IsRecursiveTriggersEnabled' has to be true for subscribing databases at updatable subscribers.

21083

16

Database compatibility level at immediate-updating Subscribers cannot be less than 7.0.

21084

16

Publication '%s' does not allow anonymous subscriptions.

21085

16

The retention period must be less than retention period for the distribution database.

21086

16

The retention period for the distribution database must be greater than the retention period of any existing non-merge publications.

21087

16

Anonymous Subscribers or Subscribers at this server are not allowed to create merge publications. 

21088

10

The initial snapshot for the publication is not yet available.

21107

16

'%ls' is not a table or view.

21108

16

This edition of SQL Server does not support transactional publications. 

21109

16

The parameters @xact_seqno_start and @xact_seqno_end must be identical if @command_id is specified.

21110

16

All parameters must be specified if @command_id is specified.

21111

16

'%s' is not a valid parameter for the Snapshot Agent.

21112

16

'%s' is not a valid parameter for the Log Reader Agent.

21113

16

'%s' is not a valid parameter for the Distribution Agent.

21114

16

'%s' is not a valid parameter for the Merge Agent.

21115

16

'%s' is not a valid value for the '%s' parameter. The value must be a positive integer.

21116

16

'%s' is not a valid value for the '%s' parameter. The value must be 1, 2, or 3.

21117

16

'%s' is not a valid value for the '%s' parameter. The value must be 0, 1, or 2.

21118

16

'%s' is not a valid value for the '%s' parameter. The value must be greater than or equal to 0 and less than or equal to 10000.

21119

16

'%s' is not a valid value for the '%s' parameter. The value must be a non-negative integer.

21120

16

Only members of the sysadmin fixed server role and db_owner fixed database role can drop subscription '%s' to publication '%s'.

21121

16

Only members of the sysadmin fixed server role and '%s' can drop the pull subscription to the publication '%s'.

21122

16

Cannot drop the distribution database '%s' because it is currently in use.

21123

16

The agent profile '%s' could not be found at the Distributor.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft