Server Error Messages 5000 - 5099

Number

Severity

Text and Explanation

5001

16

 User must be in Master Database.

Explanation: Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction. Check the command and working database context.

5002

16

 Database %.*s does not exist; check sysdatabases.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

5004

16

 ALTER DATABASE failed. The size value is invalid.

Explanation: Command failed due to invalid or illegal request. Specify a positive (and minimum allowed) value for the size parameter of the alter database command.

5005

10

Extending database by %ld pages (%d.%d megabytes) on disk %.*s

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

5006

16

 Could not find enough space on disks to extend database %.*s.

Explanation: Refer to the writeup for this error.

5008

16

 System does not support Deextend Database currently.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

5009

16

 ALTER DATABASE failed. Some disk names listed in command were not found. Check that names exist and are spelled correctly before re-running command.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

5011

14

 Only the owner of database %.*s or a user with System Administrator (SA) role can ALTER it.

Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command.

5013

16

 Cannot extend the MASTER database onto any device other than `master'. The ALTER DATABASE was aborted.

Explanation: Refer to the writeup for this error.

5015

16

CREATE or ALTER DATABASE failed. The size specified must be %d megabyte(s) or greater.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

5016

10

 ALTER DATABASE failed. The Model database may not be larger than the Temporary database. Alter tempdb first.

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

5017

16

 ALTER DATABASE failed. Database %.*s not created with `for load' option.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

5018

10

 Caution:  You have set up this database to include space on disk %d for both data and the transaction log.  This can make recovery impossible if that disk fails.

Explanation: This is an informational message. Keeping data and log separate is recommended.

5020

14

 Permission denied.  @@curwrite has to be set equal to the database's hurdle in order for the alter to proceed.

Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command.

5021

14

 Too many dbmaxhold specifications made.

Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command.

5022

16

 Invalid dbmaxhold provided.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

5023

14

 Permission denied.  The database maxhold you specified does not dominate your minwrite.

Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command.

5024

14

 Permission denied.  The database maxhold you specified is not dominated by your maxwrite.

Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command.

5025

14

 Permission denied.  The database maxhold you specified does not dominate the current database maxhold.

Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command.

5026

10

 Updating database maxhold.

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

5028

16

 ALTER DATABASE failed. This command will not make changes to a database that would cause the number of device fragments to exceed the maximum of 128. Recreate the database and try again.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

5029

16

ALTER DATABASE failed. Log space in master database has reached the last chance threshold. Please free-up log space in master database and try again. 

Explanation: This is a serious condition. Refer to “Managing Free Space With Thresholds” in the System Administration Guide for immediate corrective action.

5030

16

The database %S_DBID is in the middle of a load sequence. Altering it will not let you load other transaction dumps in the dump-set. If you still prefer to do it please use OVERRIDE option. 

Explanation: Retry the command after completing the load sequence.

5031

10

Database %S_DBID which is currently offline has been altered from size %d pages to %d pages. 

Explanation: This is an informational message.

5032

10

Alter database on '%S_DBID' broke the load sequence for that database.  

Explanation: The alter command was executed in the middle of a transaction load sequence.

5033

16

Attempt to alter database '%S_DBID' failed because it is in read-only mode.

Explanation: Determine why the query attempted to alter a read-only database. See the writeup for Error 3906.

5036

16

ALTER DATABASE failed either because the database is failed over or system proxy databases are enabled on the server in failed over mode. 

Explanation: A database maintenance operation failed. Take any corrective action indicated by the message. Check the Adaptive Server error log.

5037

17

ALTER DATABASE for database ’%S_DBID’ was unsuccessful; it failed to update log space values in internal persistent data structure. 

Explanation: Command failed due to resource limitation. Modify the command to fit available resources, retry when the resource is available, or contact your System Administrator to address the resource problem.

5038

10

 Warning: Using ALTER DATABASE to extend the log segment will cause user thresholds on the log segment within 128 pages of the last chance threshold to be disabled. 

Explanation: This is an informational message but may require follow-up action. Contact your System Administrator.