Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
202 Cards in this Set
- Front
- Back
1948
|
Severity level 16 -- Duplicate index names '%.*ls' and '%.*ls' detected on table '%.*ls'.
|
|
1004
|
Severity level 16 -- Invalid column prefix '%.*ls': No table name specified
|
|
1040
|
Severity level 15 -- Mixing old and new syntax in CREATE/ALTER DATABASE statement is not allowed.
|
|
1055
|
Severity level 15 -- '%.*ls' is an invalid name because it contains a NULL character.
|
|
1063
|
Severity level 16 -- A filegroup cannot be added using ALTER DATABASE ADD FILE. Use ALTER DATABASE ADD FILEGROUP.
|
|
1809
|
Severity level 10 -- To achieve optimal performance, update all statistics on the '%.*ls' database by running sp_updatestats.
|
|
1766
|
Severity level 16 -- Foreign key references to temporary tables are not supported. Foreign key '%.*ls'.
|
|
1774
|
Severity level 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'.
|
|
1753
|
Severity level 16 -- Column '%.*ls.%.*ls' is not the same length as referencing column '%.*ls.%.*ls' in foreign key '%.*ls'.
|
|
1773
|
Severity level 16 -- Foreign key '%.*ls' has implicit reference to object '%.*ls' which does not have a primary key defined on it.
|
|
1942
|
Severity level 16 -- Index cannot be created on view '%.*ls' because the view contains text, ntext or image columns.
|
|
1049
|
Severity level 15 -- Mixing old and new syntax to specify cursor options is not allowed.
|
|
1776
|
Severity level 16 -- There are no primary or candidate keys in the referenced table '%.*ls' that match the referencing column list in the foreign key '%.*ls'.
|
|
1906
|
Severity level 11 -- Cannot create an index on '%.*ls', because this table does not exist in database '%.*ls'.
|
|
1902
|
Severity level 16 -- Cannot create more than one clustered index on table '%.*ls'. Drop the existing clustered index '%.*ls' before creating another.
|
|
1779
|
Severity level 16 -- Table '%.*ls' already has a primary key defined on it.
|
|
1068
|
Severity level 16 -- Only one list of index hints per table is allowed.
|
|
1778
|
Severity level 16 -- Column '%.*ls.%.*ls' is not the same data type as referencing column '%.*ls.%.*ls' in foreign key '%.*ls'.
|
|
1777
|
Severity level 14 -- User does not have correct permissions on referenced table '%.*ls' to create foreign key '%.*ls'.
|
|
1955
|
Severity level 16 -- Index on view '%.*ls' cannot be created because the view contains a nondeterministic computed column.
|
|
1780
|
Severity level 20 -- Could not find column ID %d in syscolumns for object ID %d in database ID %d.
|
|
1786
|
Severity level 16 -- Either column '%.*ls.%.*ls' or referencing column '%.*ls.%.*ls' in foreign key '%.*ls' is a timestamp column. This data type cannot be used with cascading referential integrity constraints.
|
|
1804
|
Severity level 10 -- There is no disk named '%.*ls'. Checking other disk names.
|
|
1801
|
Severity level 16 -- Database '%.*ls' already exists.
|
|
1803
|
Severity level 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 accommodate a copy of the model database.
|
|
1807
|
Severity level 17 -- Could not obtain exclusive lock on database '%.*ls'. Retry the operation later.
|
|
1806
|
Severity level 16 -- CREATE DATABASE failed. The default collation of database '%.*ls' cannot be set to '%.*ls'.
|
|
1811
|
Severity level 16 -- '%.*ls' is the wrong type of device for CREATE DATABASE or ALTER DATABASE. Check sysdevices. The statement is aborted.
|
|
1808
|
Severity level 21 -- Default devices are not supported.
|
|
1813
|
Severity level 16 -- Could not open new database '%.*ls'. CREATE DATABASE is aborted.
|
|
1812
|
Severity level 16 -- CREATE DATABASE failed. COLLATE clause cannot be used with the FOR ATTACH option.
|
|
1814
|
Severity level 10 -- Could not create tempdb. If space is low, extend the amount of space and restart.
|
|
1903
|
Severity level 16 -- Index keys are too large. The %d bytes needed to represent the keys for index %d exceeds the size limit of %d bytes.
|
|
1939
|
Severity level 16 -- Index %S_MSG cannot be created on view '%.*ls' because the view is not schema bound.
|
|
1913
|
Severity level 16 -- There is already an index on table '%.*ls' named '%.*ls'.
|
|
1904
|
Severity level 16 -- Cannot specify more than %d column names for statistics or index key list. %d specified.
|
|
1909
|
Severity level 16 -- Cannot use duplicate column names in index key list. Column name '%.*ls' listed more than once.
|
|
1911
|
Severity level 16 -- Column name '%.*ls' does not exist in the target table.
|
|
1910
|
Severity level 16 -- Cannot create more than %d nonclustered indices or column statistics on one table.
|
|
1923
|
Severity level 10 -- The clustered index has been dropped.
|
|
1047
|
Severity level 15 -- Conflicting locking hints specified.
|
|
1704
|
Severity level 16 -- Only members of the sysadmin role can create the system table '%.*ls'.
|
|
1066
|
Severity level 10 -- Warning. Line %d: The option '%ls' is obsolete and has no effect.
|
|
1041
|
Severity level 15 -- Option %.*ls is not allowed for a LOG file.
|
|
1511
|
Severity level 20 -- Sort cannot be reconciled with transaction log.
|
|
1620
|
Severity level 21 -- Cannot start C2 audit trace. SQL Server is shutting down.
|
|
1531
|
Severity level 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'.
|
|
1522
|
Severity level 20 -- Sort failure. Prevented overwriting of allocation page in database '%.*ls' by terminating sort.
|
|
1530
|
Severity level 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.
|
|
1529
|
Severity level 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].
|
|
1221
|
Severity level 20 -- Invalid lock class for release call.
|
|
1540
|
Severity level 16 -- Cannot sort a row of size %d, which is greater than the allowable maximum of %d.
|
|
1505
|
Severity level 14 -- CREATE UNIQUE INDEX terminated because a duplicate key was found for index ID %d. Most significant primary key is '%S_KEY'.
|
|
1533
|
Severity level 20 -- Cannot share extent %S_PGID among more than eight sort runs.
|
|
1501
|
Severity level 20 -- Sort failure.
|
|
1532
|
Severity level 20 -- New sort run starting on page %S_PGID found extent not marked as shared.
|
|
1075
|
Severity level 15 -- RETURN statements in scalar valued functions must include an argument.
|
|
1534
|
Severity level 20 -- Extent %S_PGID not found in shared extent directory.
|
|
1070
|
Severity level 15 -- CREATE INDEX option '%.*ls' is no longer supported.
|
|
1535
|
Severity level 20 -- Cannot share extent %S_PGID with shared extent directory full.
|
|
1102
|
Severity level 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 contain an error.
|
|
1538
|
Severity level 20 -- Cannot insert into a sort not in row input phase.
|
|
1536
|
Severity level 20 -- Cannot build a nonclustered index on a memory-only work table.
|
|
1537
|
Severity level 20 -- Cannot suspend a sort not in row input phase.
|
|
1072
|
Severity level 16 -- A REMOTE hint can only be specified with an INNER JOIN clause.
|
|
1706
|
Severity level 16 -- System table '%.*ls' was not created, because ad hoc updates to system catalogs are not enabled.
|
|
1708
|
Severity level 10 -- Warning: The table '%.*ls' has been created but its maximum row size (%d) exceeds the maximum number of bytes per row (%d). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds %d bytes.
|
|
1619
|
Severity level 21 -- Could not open tempdb. Cannot continue.
|
|
1705
|
Severity level 16 -- You must create system table '%.*ls' in the master database.
|
|
1044
|
Severity level 15 -- Cannot use an existing function name to specify a stored procedure name.
|
|
1941
|
Severity level 16 -- Nonunique clustered index cannot be created on view '%.*ls' because only unique clustered indexes are allowed.
|
|
1752
|
Severity level 16 -- Could not create DEFAULT for column '%.*ls' as it is not a valid column in the table '%.*ls'.
|
|
1940
|
Severity level 16 -- Cannot create %S_MSG on view '%.*ls'. It does not have a unique clustered index.
|
|
1701
|
Severity level 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.
|
|
1920
|
Severity level 10 -- Skipping rebuild of index ID %d, which is on a read-only filegroup.
|
|
1621
|
Severity level 10 -- Server started with '-f'. Auditing will not be started.
|
|
1750
|
Severity level 10 -- Could not create constraint. See previous errors.
|
|
1914
|
Severity level 16 -- Index cannot be created on object '%.*ls' because the object is not a user table or view.
|
|
1916
|
Severity level 16 -- CREATE INDEX options %ls and %ls are mutually exclusive.
|
|
1709
|
Severity level 16 -- Cannot use TEXTIMAGE_ON when a table has no text, ntext, or image columns.
|
|
1918
|
Severity level 10 -- Index (ID = %d) is being rebuilt.
|
|
1919
|
Severity level 16 -- Column '%.*ls'. Cannot create index on a column of text, ntext, or image data type.
|
|
1947
|
Severity level 16 -- Index cannot be created on view '%.*ls' because the view contains a self-join on '%.*ls'.
|
|
1037
|
Severity level 15 -- The CASCADE, WITH GRANT or AS options cannot be specified with statement permissions.
|
|
1905
|
Severity level 21 -- Could not find 'zero' row for index '%.*ls' the table in sysindexes.
|
|
1772
|
Severity level 16 -- Foreign key '%.*ls' defines an invalid relationship between a user table and system table.
|
|
1754
|
Severity level 16 -- Defaults cannot be created on columns with an IDENTITY attribute. Table '%.*ls', column '%.*ls'.
|
|
1921
|
Severity level 16 -- Invalid filegroup '%.*ls' specified.
|
|
1035
|
Severity level 15 -- Incorrect syntax near '%.*ls', expected '%.*ls'.
|
|
1016
|
Severity level 15 -- Outer join operators cannot be specified in a query containing joined tables.
|
|
1002
|
Severity level 16 -- Line %d: Specified scale %d is invalid.
|
|
1001
|
Severity level 16 -- Line %d: Length or precision specification %d is invalid.
|
|
1907
|
Severity level 16 -- Cannot re-create index '%.*ls'. The new index definition does not match the constraint being enforced by the existing index.
|
|
1069
|
Severity level 16 -- Index hints are only allowed in a FROM clause.
|
|
1703
|
Severity level 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.
|
|
1003
|
Severity level 15 -- Line %d: %ls clause allowed only for %ls.
|
|
1938
|
Severity level 16 -- Index cannot be created on %S_MSG '%.*ls' because the underlying object '%.*ls' has a different owner.
|
|
1015
|
Severity level 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.
|
|
1014
|
Severity level 15 -- TOP clause contains an invalid value.
|
|
1006
|
Severity level 15 -- CREATE TRIGGER contains no statements.
|
|
1005
|
Severity level 15 -- Line %d: Invalid procedure number (%d). Must be between 1 and 32767.
|
|
1013
|
Severity level 15 -- Tables or functions '%.*ls' and '%.*ls' have the same exposed names. Use correlation names to distinguish them.
|
|
1008
|
Severity level 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.
|
|
1011
|
Severity level 15 -- The correlation name '%.*ls' is specified multiple times in a FROM clause.
|
|
1010
|
Severity level 15 -- Invalid escape character '%.*ls'.
|
|
1033
|
Severity level 16 -- The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.
|
|
1036
|
Severity level 15 -- File option %hs is required in this CREATE/ALTER DATABASE statement.
|
|
1019
|
Severity level 15 -- Invalid column list after object name in GRANT/REVOKE statement.
|
|
1755
|
Severity level 16 -- Defaults cannot be created on columns of data type timestamp. Table '%.*ls', column '%.*ls'.
|
|
1027
|
Severity level 15 -- Too many expressions are specified in the GROUP BY clause. The maximum number is %d when either CUBE or ROLLUP is specified.
|
|
1022
|
Severity level 10 -- FIPS Warning: Line %d has the non-ANSI clause '%ls'.
|
|
1024
|
Severity level 10 -- FIPS Warning: Line %d has the non-ANSI function '%ls'.
|
|
1021
|
Severity level 10 -- FIPS Warning: Line %d has the non-ANSI statement '%ls'.
|
|
1032
|
Severity level 16 -- Cannot use the column prefix '%.*ls'. This must match the object in the UPDATE clause '%.*ls'.
|
|
1029
|
Severity level 15 -- Browse mode is invalid for subqueries and derived tables.
|
|
1057
|
Severity level 15 -- The IDENTITY function cannot be used with a SELECT INTO statement containing a UNION operator.
|
|
1053
|
Severity level 15 -- For DROP STATISTICS, you must give both the table and the column name in the form 'tablename.column'.
|
|
1058
|
Severity level 15 -- Cannot specify both READ_ONLY and FOR READ ONLY on a cursor declaration.
|
|
1056
|
Severity level 15 -- The maximum number of elements in the select list is %d and you have supplied %d.
|
|
1039
|
Severity level 16 -- Option '%.*ls' is specified more than once.
|
|
1523
|
Severity level 20 -- Sort failure. Prevented incorrect extent deallocation by aborting sort.
|
|
1054
|
Severity level 15 -- Syntax '%ls' is not allowed in schema-bound objects.
|
|
1045
|
Severity level 15 -- Aggregates are not allowed in this context. Only scalar expressions are allowed.
|
|
1007
|
Severity level 15 -- The %S_MSG '%.*ls' is out of the range for numeric representation (maximum precision 38).
|
|
1043
|
Severity level 15 -- '%hs' is not yet implemented.
|
|
1950
|
Severity level 16 -- Index on view '%.*ls' cannot be created because the view contains an imprecise expression in a GROUP BY clause
|
|
1042
|
Severity level 15 -- Conflicting %ls optimizer hints specified.
|
|
1038
|
Severity level 15 -- Cannot use empty object or column names. Use a single space if necessary.
|
|
1922
|
Severity level 16 -- Filegroup '%.*ls' has no files assigned to it. Tables, indexes, and text, ntext, and image columns cannot be created on this filegroup.
|
|
1052
|
Severity level 15 -- Conflicting %ls options %ls and %ls.
|
|
1046
|
Severity level 15 -- Subqueries are not allowed in this context. Only scalar expressions are allowed.
|
|
1050
|
Severity level 15 -- This syntax is only allowed within the stored procedure sp_executesql.
|
|
1901
|
Severity level 16 -- Column '%.*ls'. Cannot create index on a column of bit data type.
|
|
1051
|
Severity level 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.
|
|
1048
|
Severity level 15 -- Conflicting cursor options %ls and %ls.
|
|
1949
|
Severity level 16 -- Index on view '%.*ls' cannot be created because function '%s' yields nondeterministic results.
|
|
1946
|
Severity level 16 -- Operation failed. The index entry of length %d bytes for the index '%.*ls' exceeds the maximum length of %d bytes.
|
|
1770
|
Severity level 16 -- Foreign key '%.*ls' references invalid column '%.*ls' in referenced table '%.*ls'.
|
|
1109
|
Severity level 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.
|
|
1062
|
Severity level 16 -- The TOP N WITH TIES clause is not allowed without a corresponding ORDER BY clause.
|
|
1059
|
Severity level 15 -- Cannot set or reset the %ls option within a procedure.
|
|
1060
|
Severity level 15 -- The number of rows in the TOP clause must be an integer.
|
|
1061
|
Severity level 16 -- The text/ntext/image constants are not yet implemented.
|
|
1952
|
Severity level 16 -- Index on view '%.*ls' cannot be created because the view contains an imprecise expression in a join.
|
|
1528
|
Severity level 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].
|
|
1205
|
Severity level 13 -- Transaction (Process ID %d) was deadlocked on {%Z} resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
|
|
1067
|
Severity level 15 -- The SET SHOWPLAN statements must be the only statements in the batch.
|
|
1781
|
Severity level 16 -- Column already has a DEFAULT bound to it.
|
|
1065
|
Severity level 15 -- The NOLOCK, READUNCOMMITTED, and READPAST lock hints are only allowed in a SELECT statement.
|
|
1064
|
Severity level 16 -- A filegroup cannot be used with log files.
|
|
1784
|
Severity level 16 -- Cannot create the foreign key '%.*ls' because the referenced column '%.*ls.%.*ls' is a computed column.
|
|
1951
|
Severity level 16 -- Index on view '%.*ls' cannot be created because the view contains an imprecise expression in the WHERE clause.
|
|
1079
|
Severity level 15 -- A variable cannot be used to specify a search condition in a fulltext predicate when accessed through a cursor.
|
|
1073
|
Severity level 15 -- '%.*ls' is not a recognized cursor option for cursor %.*ls.
|
|
1071
|
Severity level 16 -- Cannot specify a JOIN algorithm with a remote JOIN.
|
|
1077
|
Severity level 15 -- INSERT into an identity column not allowed on table variables.
|
|
1076
|
Severity level 15 -- Function '%s' requires at least %d argument(s).
|
|
1074
|
Severity level 15 -- Creation of temporary functions is not allowed.
|
|
1204
|
Severity level 19 -- The SQL Server cannot obtain a LOCK resource at this time. Rerun your statement when there are fewer active users or ask the system administrator to check the SQL Server lock and memory configuration.
|
|
1103
|
Severity level 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.
|
|
1078
|
Severity level 15 -- '%.*ls %.*ls' is not a recognized option.
|
|
1101
|
Severity level 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.
|
|
1760
|
Severity level 16 -- Constraints of type %ls cannot be created on columns of type %ls.
|
|
1203
|
Severity level 20 -- Process ID %d attempting to unlock unowned resource %.*ls.
|
|
1201
|
Severity level 20 -- The page_lock system function was called with a mode %d that is not permitted.
|
|
1105
|
Severity level 17 -- Could not allocate space for object '%.*ls' in database '%.*ls' because the '%.*ls' filegroup is full.
|
|
1508
|
Severity level 14 -- CREATE INDEX terminated because a duplicate row was found. Primary key is '%S_KEY'.
|
|
1012
|
Severity level 15 -- The correlation name '%.*ls' has the same exposed name as table '%.*ls'.
|
|
1206
|
Severity level 18 -- Transaction manager has canceled the distributed transaction.
|
|
1031
|
Severity level 15 -- Percent values must be between 0 and 100.
|
|
1211
|
Severity level 13 -- Process ID %d was chosen as the deadlock victim with P_BACKOUT bit set.
|
|
1507
|
Severity level 10 -- Warning: Deleted duplicate row. Primary key is '%S_KEY'.
|
|
1959
|
Severity level 16 -- Cannot create index on view or computed column because this database is not SQL Server compatible.
|
|
1220
|
Severity level 17 -- No more lock classes available from transaction.
|
|
1222
|
Severity level 13 -- Lock request time out period exceeded.
|
|
1510
|
Severity level 17 -- Sort failed. Out of space or locks in database '%.*ls'.
|
|
1802
|
Severity level 11 -- CREATE DATABASE failed. Some file names listed could not be created. Check previous errors.
|
|
1957
|
Severity level 16 -- Index on view '%.*ls' cannot be created because the view requires a conversion involving dates or variants.
|
|
1958
|
Severity level 16 -- This edition of SQL Server does not support indexed views.
|
|
1223
|
Severity level 16 -- Attempting to release application lock '%.*ls' that is not currently held.
|
|
1956
|
Severity level 16 -- Index on view '%.*ls' cannot be created because the view uses a nondeterministic user-defined function.
|
|
1509
|
Severity level 20 -- Row compare failure.
|
|
1756
|
Severity level 10 -- Skipping FOREIGN KEY constraint '%.*ls' definition for temporary table.
|
|
1769
|
Severity level 16 -- Foreign key '%.*ls' references invalid column '%.*ls' in referencing table '%.*ls'.
|
|
1787
|
Severity level 16 -- Cannot define foreign key constraint '%.*ls' with cascaded DELETE or UPDATE on table '%.*ls' because the table has an INSTEAD OF DELETE or UPDATE TRIGGER defined on it.
|
|
1785
|
Severity level 16 -- Introducing FOREIGN KEY constraint '%.*ls' on table '%.*ls' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
|
|
1788
|
Severity level 16 -- Cascading foreign key '%.*ls' cannot be created where the referencing column '%.*ls.%.*ls' is an identity column.
|
|
1763
|
Severity level 16 -- Cross-database foreign key references are not supported. Foreign key '%.*ls'.
|
|
1954
|
Severity level 16 -- Index on view '%.*ls' cannot be created because the view uses a column bound to a rule.
|
|
1805
|
Severity level 10 -- The CREATE DATABASE process is allocating %.2f MB on disk '%.*ls'.
|
|
1759
|
Severity level 16 -- Invalid column '%.*ls' is specified in a constraint or computed-column definition.
|
|
1028
|
Severity level 15 -- The CUBE and ROLLUP options are not allowed in a GROUP BY ALL clause.
|
|
1025
|
Severity level 10 -- FIPS Warning: The length of identifier '%.*ls' exceeds 18.
|
|
1757
|
Severity level 16 -- Column '%.*ls.%.*ls' is not of same collation as referencing column '%.*ls.%.*ls' in foreign key '%.*ls'.
|
|
1953
|
Severity level 16 -- Index on view '%.*ls' cannot be created because some arguments are missing in a built-in function.
|
|
1020
|
Severity level 15 -- Column list cannot be specified for object-level permissions.
|
|
1768
|
Severity level 16 -- Foreign key '%.*ls' references object '%.*ls' which is not a user table.
|
|
1943
|
Severity level 16 -- Index cannot be created on view '%.*ls' because the view has one or more nondeterministic expressions.
|
|
1767
|
Severity level 16 -- Foreign key '%.*ls' references invalid table '%.*ls'.
|
|
1023
|
Severity level 15 -- Invalid parameter %d specified for %ls.
|
|
1945
|
Severity level 16 -- Warning! The maximum key length is %d bytes. The index '%.*ls' has maximum length of %d bytes. For some combination of large values, the insert/update operation will fail.
|
|
1944
|
Severity level 16 -- Index '%.*ls' was not created. This index has a key length of at least %d bytes. The maximum permissible key length is %d bytes.
|