SQL Server Errors or Failures Error: 1087 to Error: 1124

SQLServerF1

 

Error: 1087, Severity: 15,
Must declare the table variable “%.*ls”.

Error: 1088, Severity: 15,
Cannot find the object “%.*ls” because it does not exist or you do not have permissions.

Error: 1089, Severity: 15,
The SET FMTONLY OFF statement must be the last statement in the batch.

Error: 1090, Severity: 15,
Invalid default for parameter %d.

Error: 1091, Severity: 15,
The option “%ls” is not valid for this function.

Error: 1092, Severity: 16,
In this context %d statistics name(s) cannot be specified for option ‘%ls’.

Error: 1093, Severity: 16,
%.*ls is not a valid broker name.

Error: 1094, Severity: 15,
Cannot specify a schema name as a prefix to the trigger name for database and server level triggers.

Error: 1095, Severity: 15,
%.*ls has already been specified as an event type.

Error: 1096, Severity: 15,
Default parameter values for CLR types, nvarchar(max), varbinary(max), and xml are not supported.

Error: 1097, Severity: 15,
Cannot use If UPDATE within this CREATE TRIGGER statement.

Error: 1098, Severity: 15,
The specified event type(s) is/are not valid on the specified target object.

Error: 1099, Severity: 15,
The ON clause is not valid for this statement.

Error: 1101, Severity: 17,
Could not allocate a new page for database ‘%.*ls’ because of insufficient disk space in filegroup ‘%.*ls’. Create the necessary space by dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing fi

Error: 1105, Severity: 17,
Could not allocate space for object ‘%.*ls’%.*ls in database ‘%.*ls’ because the ‘%.*ls’ filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on

Error: 1119, Severity: 16,
Removing IAM page %S_PGID failed because someone else is using the object that this IAM page belongs to.

Error: 1121, Severity: 17,
Space allocator cannot allocate page in database %d.

Error: 1122, Severity: 14,
Table error: Page %S_PGID. Test (%ls) failed. Address 0x%x is not aligned.

Error: 1123, Severity: 14,
Table error: Page %S_PGID. Unexpected page type %d.

Error: 1124, Severity: 14,
Table error: Page %S_PGID. Test (%ls) failed. Slot %d, offset 0x%x is invalid.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

Thanks,
SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.

 

Leave a Reply

Your email address will not be published. Required fields are marked *