Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/202

Click to flip

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.