SQL Error Type List with description from error 1- 500

SQL Error Type List with description from 1 to 500 with Severity Level

Error Type =1, Error Description Version date of last upgrade: 10/11/90.. Error Severity Level=10

Error Type =21, Error Description Warning: Fatal error %d occurred at %S_DATE. Note the error and time, and contact your system administrator.. Error Severity Level=10

Error Type =53, Error Description An error has occurred while establishing a connection to the server. When connecting to SQL Server, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server ) (.Net SqlClient Data Provider).. Error Severity Level=10

Error Type =101, Error Description Query not allowed in Waitfor.. Error Severity Level=15

Error Type =102, Error Description Incorrect syntax near '%.*ls'.. Error Severity Level=15

Error Type =103, Error Description The %S_MSG that starts with '%.*ls' is too long. Maximum length is %d.. Error Severity Level=15

Error Type =104, Error Description ORDER BY items must appear in the select list if the statement contains a UNION operator.. Error Severity Level=15

Error Type =105, Error Description Unclosed quotation mark before the character string '%.*ls'.. Error Severity Level=15

Error Type =106, Error Description Too many table names in the query. The maximum allowable is %d.. Error Severity Level=16

Error Type =107, Error Description The column prefix '%.*ls' does not match with a table name or alias name used in the query.. Error Severity Level=15

Error Type =108, Error Description The ORDER BY position number is out of range of the number of items in the select list.. Error Severity Level=15

Error Type =109, Error Description 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.. Error Severity Level=15

Error Type =110, Error Description 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.. Error Severity Level=15

Error Type =111, Error Description CREATE FUNCTION' must be the first statement in a query batch.. Error Severity Level=15

Error Type =112, Error Description Variables are not allowed in the %ls statement.. Error Severity Level=15

Error Type =113, Error Description Missing end comment mark '*/'.. Error Severity Level=15

Error Type =114, Error Description Browse mode is invalid for a statement that assigns values to a variable.. Error Severity Level=15

Error Type =115, Error Description The FOR UPDATE clause is invalid for statements containing set operators.. Error Severity Level=15

Error Type =116, Error Description Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.. Error Severity Level=15

Error Type =117, Error Description The object name "Object Name" contains more than the maximum number of prefixes. The maximum is 2.. Error Severity Level=15

Error Type =118, Error Description Only members of the sysadmin role can specify the %ls option for the %ls statement.. Error Severity Level=15

Error Type =119, Error Description 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'.. Error Severity Level=15

Error Type =120, Error Description 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.. Error Severity Level=15

Error Type =121, Error Description 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.. Error Severity Level=15

Error Type =122, Error Description The %ls option is allowed only with %ls syntax.. Error Severity Level=15

Error Type =123, Error Description Batch/procedure exceeds maximum length of %d characters.. Error Severity Level=15

Error Type =124, Error Description CREATE PROCEDURE contains no statements.. Error Severity Level=15

Error Type =125, Error Description Case expressions may only be nested to level %d.. Error Severity Level=15

Error Type =126, Error Description Invalid pseudocolumn "%.*ls".. Error Severity Level=15

Error Type =127, Error Description A TOP N value may not be negative.. Error Severity Level=15

Error Type =128, Error Description The name '<Column Name>' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.. Error Severity Level=15

Error Type =129, Error Description Fillfactor %d is not a valid percentage; fillfactor must be between 1 and 100.. Error Severity Level=15

Error Type =130, Error Description Cannot perform an aggregate function on an expression containing an aggregate or a subquery.. Error Severity Level=16

Error Type =131, Error Description The size (<Data Type Size>) given to the type 'varchar / char / nvarchar / nchar / binary / varbinary' exceeds the maximum allowed for any data type (8000).

The size (<Data Type Size>) given to the column '<Column Name>' exceeds the maximum allowed for any data type (8000).. Error Severity Level=15

Error Type =132, Error Description The label '%.*ls' has already been declared. Label names must be unique within a query batch or stored procedure.. Error Severity Level=15

Error Type =133, Error Description A GOTO statement references the label '<Label Name>' but the label has not been declared.. Error Severity Level=15

Error Type =134, Error Description The variable name '%.*ls' has already been declared. Variable names must be unique within a query batch or stored procedure.. Error Severity Level=15

Error Type =135, Error Description Cannot use a BREAK statement outside the scope of a WHILE statement.. Error Severity Level=15

Error Type =136, Error Description Cannot use a CONTINUE statement outside the scope of a WHILE statement.. Error Severity Level=15

Error Type =137, Error Description Must declare the scalar variable '<Variable Name>'.. Error Severity Level=15

Error Type =138, Error Description Correlation clause in a subquery not permitted.. Error Severity Level=15

Error Type =139, Error Description Cannot assign a default value to a local variable.. Error Severity Level=15

Error Type =140, Error Description Can only use IF UPDATE within a CREATE TRIGGER statement.. Error Severity Level=15

Error Type =141, Error Description A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.. Error Severity Level=15

Error Type =142, Error Description Incorrect syntax for definition of the '%ls' constraint.. Error Severity Level=15

Error Type =143, Error Description 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.. Error Severity Level=15

Error Type =144, Error Description Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.. Error Severity Level=15

Error Type =145, Error Description ORDER BY items must appear in the select list if SELECT DISTINCT is specified.. Error Severity Level=15

Error Type =146, Error Description Could not allocate ancillary table for a subquery. Maximum number of tables in a query (%d) exceeded.. Error Severity Level=15

Error Type =147, Error Description 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.. Error Severity Level=15

Error Type =148, Error Description Incorrect time syntax in time string '<Wait Time>' used with WAITFOR.. Error Severity Level=15

Error Type =149, Error Description Time value '%.*ls' used with WAITFOR is not a valid value. Check date/time syntax.. Error Severity Level=15

Error Type =150, Error Description Both terms of an outer join must contain columns.. Error Severity Level=15

Error Type =151, Error Description %.*ls' is an invalid money value.. Error Severity Level=15

Error Type =152, Error Description The same large data placement option "%.*ls" has been specified twice.. Error Severity Level=15

Error Type =153, Error Description Invalid usage of the option %.*ls in the %ls statement.. Error Severity Level=15

Error Type =154, Error Description a COMPUTE clause is not allowed in a SELECT INTO statement.. Error Severity Level=15

Error Type =155, Error Description <DATEADD option>' is not a recognized DATEADD option.. Error Severity Level=15

Error Type =156, Error Description Incorrect syntax near the keyword '%.*ls'.. Error Severity Level=15

Error Type =157, Error Description An aggregate may not appear in the set list of an UPDATE statement.. Error Severity Level=15

Error Type =158, Error Description An aggregate may not appear in the OUTPUT clause.. Error Severity Level=15

Error Type =159, Error Description SQL Server 2005, SQL Server 2008 - Must specify the table name and index name for the DROP INDEX statement.

SQL Server 2000 - For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname.. Error Severity Level=15

Error Type =160, Error Description Rule does not contain a variable.. Error Severity Level=15

Error Type =161, Error Description Rule contains more than one variable.. Error Severity Level=15

Error Type =162, Error Description Invalid expression in the TOP clause.. Error Severity Level=15

Error Type =163, Error Description The compute by list does not match the order by list.. Error Severity Level=15

Error Type =164, Error Description Each GROUP BY expression must contain at least one column that is not an outer reference.

GROUP BY expressions must refer to column names that appear in the select list.. Error Severity Level=15

Error Type =165, Error Description Privilege %ls may not be granted or revoked.. Error Severity Level=16

Error Type =166, Error Description CREATE VIEW' does not allow specifying the database name as a prefix to the object name.. Error Severity Level=15

Error Type =167, Error Description Cannot create a trigger on a temporary object.. Error Severity Level=16

Error Type =168, Error Description The %S_MSG '%.*ls' is out of the range of computer representation (%d bytes).. Error Severity Level=15

Error Type =169, Error Description A column has been specified more than once in the order by list. Columns in the order by list must be unique.. Error Severity Level=15

Error Type =170, Error Description Line %d: Incorrect syntax near '%.*ls'.. Error Severity Level=15

Error Type =171, Error Description Cannot use SELECT INTO in browse mode.. Error Severity Level=15

Error Type =172, Error Description Cannot use HOLDLOCK in browse mode.. Error Severity Level=15

Error Type =173, Error Description The definition for column <Column Name> must include a data type.. Error Severity Level=15

Error Type =174, Error Description The dateadd function requires 3 arguments.. Error Severity Level=15

Error Type =175, Error Description An aggregate may not appear in a computed column expression or check constraint.. Error Severity Level=15

Error Type =176, Error Description The FOR BROWSE clause is no longer supported in views. Set the database compatibility level to 80 or lower for this statement to be allowed.. Error Severity Level=15

Error Type =177, Error Description The IDENTITY function can only be used when the SELECT statement has an INTO clause.. Error Severity Level=15

Error Type =178, Error Description A RETURN statement with a return value cannot be used in this context.. Error Severity Level=15

Error Type =179, Error Description Cannot use the OUTPUT option when passing a constant to a stored procedure.. Error Severity Level=15

Error Type =180, Error Description There are too many parameters in this %ls statement. The maximum number is %d.. Error Severity Level=15

Error Type =181, Error Description SQL Server 2008 - Cannot use the OUTPUT option in a DECLARE, CREATE AGGREGATE or CREATE FUNCTION statement.

SQL Server 2005 - Cannot use the OUTPUT option in a DECLARE or CREATE FUNCTION statement.

SQL Server 2000 - Cannot use the OUTPUT option in a DECLARE statement.. Error Severity Level=15

Error Type =182, Error Description Table and column names must be supplied for the READTEXT or WRITETEXT utility.. Error Severity Level=15

Error Type =183, Error Description The scale (<Scale Value>) for column '<Column Name>' must be within the range 0 to <Precision Value>.. Error Severity Level=15

Error Type =184, Error Description DEFAULT cannot be specified more than once for filegroups of the same content type.. Error Severity Level=15

Error Type =185, Error Description Data stream is invalid for WRITETEXT statement in bulk form.. Error Severity Level=15

Error Type =186, Error Description Data stream missing from WRITETEXT statement.. Error Severity Level=15

Error Type =187, Error Description The valid range for MAX_QUEUE_READERS is 0 to 32767.. Error Severity Level=16

Error Type =188, Error Description Cannot specify a log device in a CREATE DATABASE statement without also specifying at least one non-log device.. Error Severity Level=15

Error Type =189, Error Description The %ls function requires %d to %d arguments.. Error Severity Level=15

Error Type =190, Error Description An invalid date or time was specified in the statement.. Error Severity Level=15

Error Type =191, Error Description Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.. Error Severity Level=15

Error Type =192, Error Description The scale must be less than or equal to the precision.. Error Severity Level=16

Error Type =193, Error Description The object or column name starting with '%.*ls' is too long. The maximum length is %d characters.. Error Severity Level=15

Error Type =194, Error Description A SELECT INTO statement cannot contain a SELECT statement that assigns values to a variable.. Error Severity Level=15

Error Type =195, Error Description Function Name' is not a recognized function name.. Error Severity Level=15

Error Type =196, Error Description SELECT INTO must be the first query in an SQL statement containing a UNION, INTERSECT or EXCEPT operator.. Error Severity Level=15

Error Type =197, Error Description EXECUTE cannot be used as a source when inserting into a table variable.. Error Severity Level=15

Error Type =198, Error Description Browse mode is invalid for statements containing a UNION operator.. Error Severity Level=15

Error Type =199, Error Description An INSERT statement cannot contain a SELECT statement that assigns values to a variable.. Error Severity Level=15

Error Type =201, Error Description Procedure '<Procedure Name>' expects parameter '<Parameter Name>', which was not supplied.. Error Severity Level=16

Error Type =202, Error Description Invalid type '%s' for WAITFOR. Supported data types are CHAR/VARCHAR, NCHAR/NVARCHAR, and DATETIME. WAITFOR DELAY supports the INT and SMALLINT data types.. Error Severity Level=16

Error Type =203, Error Description The name '%.*ls' is not a valid identifier.. Error Severity Level=16

Error Type =204, Error Description Normalization error in node %ls.. Error Severity Level=20

Error Type =205, Error Description All queries in an SQL statement containing a UNION operator must have an equal number of expressions in their target lists.. Error Severity Level=16

Error Type =206, Error Description Operand type clash: %ls is incompatible with %ls. Error Severity Level=16

Error Type =207, Error Description Invalid column name '%.*ls'.. Error Severity Level=16

Error Type =208, Error Description Invalid object name '%.*ls'.. Error Severity Level=16

Error Type =209, Error Description Ambiguous column name '%.*ls'.. Error Severity Level=16

Error Type =210, Error Description Syntax error converting datetime from binary/varbinary string.. Error Severity Level=16

Error Type =211, Error Description SyntaxPossible schema corruption. Run DBCC CHECKCATALOG.. Error Severity Level=12

Error Type =212, Error Description Expression result length exceeds the maximum. %d max, %d found.. Error Severity Level=16

Error Type =213, Error Description Insert Error: Column name or number of supplied values does not match table definition.. Error Severity Level=16

Error Type =214, Error Description Procedure expects parameter '%ls' of type '%ls'.. Error Severity Level=16

Error Type =215, Error Description Parameters supplied for object '%.*ls' which is not a function. If the parameters are intended as a table hint, a WITH keyword is required.. Error Severity Level=16

Error Type =216, Error Description Parameters were not supplied for the function '%.*ls'.. Error Severity Level=16

Error Type =217, Error Description Maximum stored procedure, function, trigger, or view nesting level exceeded (limit %d).. Error Severity Level=16

Error Type =218, Error Description Could not find the type '%.*ls'. Either it does not exist or you do not have the necessary permission.. Error Severity Level=16

Error Type =219, Error Description The type '%.*ls' already exists, or you do not have permission to create it.. Error Severity Level=16

Error Type =220, Error Description Arithmetic overflow error for data type %ls, value = %ld.. Error Severity Level=16

Error Type =221, Error Description FIPS Warning: Implicit conversion from %ls to %ls.. Error Severity Level=10

Error Type =222, Error Description The base type "%.*ls" is not a valid base type for the alias data type.. Error Severity Level=16

Error Type =223, Error Description Object ID %ld specified as a default for table ID %ld, column ID %d is missing or not of type default.. Error Severity Level=11

Error Type =224, Error Description Object ID %ld specified as a rule for table ID %ld, column ID %d is missing or not of type default.. Error Severity Level=11

Error Type =225, Error Description The parameters supplied for the %ls "%.*ls" are not valid.. Error Severity Level=16

Error Type =226, Error Description %ls statement not allowed within multi-statement transaction.. Error Severity Level=16

Error Type =227, Error Description %.*ls is not a valid function, property, or field.. Error Severity Level=15

Error Type =228, Error Description Method '%.*ls' of type '%.*ls' in assembly '%.*ls' does not return any value.. Error Severity Level=15

Error Type =229, Error Description %ls permission denied on object '%.*ls', database '%.*ls', owner '%.*ls'.. Error Severity Level=14

Error Type =230, Error Description %ls permission denied on column '%.*ls' of object '%.*ls', database '%.*ls', owner '%.*ls'.. Error Severity Level=14

Error Type =231, Error Description No such default. ID = %ld, database ID = %d.. Error Severity Level=11

Error Type =232, Error Description Arithmetic overflow error for type %ls, value = %f.. Error Severity Level=16

Error Type =233, Error Description The column '%.*ls' in table '%.*ls' cannot be null.. Error Severity Level=16

Error Type =234, Error Description There is insufficient result space to convert a money value to varchar / nvarchar / char / nchar.. Error Severity Level=16

Error Type =235, Error Description Cannot convert a char value to money. The char value has incorrect syntax.. Error Severity Level=16

Error Type =236, Error Description The conversion from char data type to money resulted in a money overflow error.. Error Severity Level=16

Error Type =237, Error Description There is insufficient result space to convert a money value to int / smallint / tinyint.. Error Severity Level=16

Error Type =238, Error Description There is insufficient result space to convert the %ls value (= %d) to the money data type.. Error Severity Level=16

Error Type =239, Error Description Duplicate common table expression name '%.*ls' was specified.. Error Severity Level=16

Error Type =240, Error Description Types don't match between the anchor and the recursive part in column "<Column Name>" of recursive query "<Recursive CTE>".. Error Severity Level=16

Error Type =241, Error Description Syntax error converting datetime from character string.. Error Severity Level=16

Error Type =242, Error Description The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.. Error Severity Level=16

Error Type =243, Error Description Type <Data Type> is not a defined system type.. Error Severity Level=16

Error Type =244, Error Description The conversion of the %ls value '%.*ls' overflowed an %hs column. Use a larger integer column.. Error Severity Level=16

Error Type =245, Error Description Syntax error converting the varchar value to a column of data type int.. Error Severity Level=16

Error Type =246, Error Description No anchor member was specified for recursive query "%.*ls".. Error Severity Level=16

Error Type =247, Error Description An anchor member was found in the recursive part of recursive query "%.*ls".. Error Severity Level=16

Error Type =248, Error Description The conversion of the %ls value '%.*ls' overflowed an int column. Maximum integer value exceeded.. Error Severity Level=16

Error Type =249, Error Description The type "%ls" is not comparable. It cannot be used in the %ls clause.. Error Severity Level=16

Error Type =251, Error Description Could not allocate ancillary table for query optimization. Maximum number of tables in a query (%d) exceeded.. Error Severity Level=16

Error Type =252, Error Description Recursive common table expression '<Common Table Expression Name>' does not contain a top-level UNION ALL operator.. Error Severity Level=16

Error Type =253, Error Description Recursive member of a common table expression '<Common Table Expression Name>' has multiple recursive references.. Error Severity Level=16

Error Type =254, Error Description Prefixed columns are not allowed in the column list of a PIVOT operator.. Error Severity Level=16

Error Type =255, Error Description Pseudocolumns are not allowed in the column list of a PIVOT operator.. Error Severity Level=16

Error Type =256, Error Description The data type int is invalid for the substring function. Allowed types are: char/varchar, nchar/nvarchar, and binary/varbinary.. Error Severity Level=16

Error Type =257, Error Description Implicit conversion from data type %ls to %ls is not allowed. Use the CONVERT function to run this query.. Error Severity Level=16

Error Type =258, Error Description Cannot call methods on %ls.. Error Severity Level=16

Error Type =259, Error Description Ad hoc updates to system catalogs are not enabled. The system administrator must reconfigure SQL Server to allow this.. Error Severity Level=16

Error Type =260, Error Description Disallowed implicit conversion from data type %ls to data type %ls, table '%.*ls', column '%.*ls'. Use the CONVERT function to run this query.. Error Severity Level=16

Error Type =261, Error Description %.*ls' is not a recognized function.. Error Severity Level=16

Error Type =262, Error Description %ls permission denied in database '%.*ls'.. Error Severity Level=16

Error Type =263, Error Description Must specify table to select from.. Error Severity Level=16

Error Type =264, Error Description Column name '%.*ls' appears more than once in the result column list.. Error Severity Level=16

Error Type =265, Error Description The column name "%.*ls" specified in the %ls operator conflicts with the existing column name in the %ls argument.. Error Severity Level=16

Error Type =266, Error Description Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = %ld, current count = %ld.. Error Severity Level=16

Error Type =267, Error Description Object '%.*ls' cannot be found.. Error Severity Level=16

Error Type =268, Error Description Cannot run SELECT INTO in this database. The database owner must run sp_dboption to enable this option.. Error Severity Level=16

Error Type =270, Error Description Object '%.*ls' cannot be modified.. Error Severity Level=16

Error Type =271, Error Description SQL Server 2005, SQL Server 2008, SQL Server 2012 - The column '<Column Name>' cannot be modified because it is either a computed column or is the result of a UNION operator.

SQL Server 2000 - Column '<Column Name>' cannot be modified because it is a computed column.. Error Severity Level=16

Error Type =272, Error Description Cannot update a timestamp column.. Error Severity Level=16

Error Type =273, Error Description 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.. Error Severity Level=16

Error Type =275, Error Description Prefixes are not allowed in value or pivot columns of an UNPIVOT operator.. Error Severity Level=16

Error Type =276, Error Description Pseudocolumns are not allowed as value or pivot columns of an UNPIVOT operator.. Error Severity Level=16

Error Type =277, Error Description The column "%.*ls" is specified multiple times in the column list of the UNPIVOT operator.. Error Severity Level=16

Error Type =278, Error Description The text, ntext, and image data types cannot be used in a GROUP BY clause.. Error Severity Level=16

Error Type =279, Error Description The text, ntext, and image data types are invalid in this subquery or aggregate expression.. Error Severity Level=16

Error Type =280, Error Description Only text, ntext, and image columns are valid with the TEXTPTR function.. Error Severity Level=16

Error Type =281, Error Description <Style number> is not a valid style number when converting from %ls to a character string.. Error Severity Level=16

Error Type =282, Error Description The '%.*ls' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.. Error Severity Level=10

Error Type =283, Error Description READTEXT cannot be used on inserted or deleted tables within an INSTEAD OF trigger.. Error Severity Level=16

Error Type =284, Error Description Rules cannot be bound to text, ntext, or image data types.. Error Severity Level=16

Error Type =285, Error Description The READTEXT, WRITETEXT, and UPDATETEXT statements cannot be used with views or functions.. Error Severity Level=16

Error Type =286, Error Description The logical tables INSERTED and DELETED cannot be updated.. Error Severity Level=16

Error Type =287, Error Description The %ls statement is not allowed within a trigger.. Error Severity Level=16

Error Type =288, Error Description The PATINDEX function operates on char, nchar, varchar, nvarchar, text, and ntext data types only.. Error Severity Level=16

Error Type =290, Error Description Invalid EXECUTE statement using object "%ls", method "%ls".. Error Severity Level=16

Error Type =291, Error Description CAST or CONVERT: invalid attributes specified for type '%.*ls'. Error Severity Level=16

Error Type =292, Error Description There is insufficient result space to convert a smallmoney value to varchar/nvarchar.. Error Severity Level=16

Error Type =293, Error Description Cannot convert char value to smallmoney. The char value has incorrect syntax.. Error Severity Level=16

Error Type =294, Error Description The conversion from char data type to smallmoney data type resulted in a smallmoney overflow error.. Error Severity Level=16

Error Type =295, Error Description Syntax error converting character string to smalldatetime data type.. Error Severity Level=16

Error Type =296, Error Description The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.. Error Severity Level=16

Error Type =297, Error Description The user does not have permission to perform this action.. Error Severity Level=16

Error Type =298, Error Description The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error.. Error Severity Level=16

Error Type =299, Error Description The DATEADD function was called with bad type %ls.. Error Severity Level=16

Error Type =300, Error Description %ls permission was denied on object '%.*ls', database '%.*ls'.. Error Severity Level=14

Error Type =301, Error Description Query contains an outer-join request that is not permitted.. Error Severity Level=16

Error Type =302, Error Description The newsequentialid() built-in function can only be used in a DEFAULT expression for a column of type 'uniqueidentifier' in a CREATE TABLE or ALTER TABLE statement. It cannot be combined with other operators to form a complex scalar expression.. Error Severity Level=16

Error Type =303, Error Description 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.. Error Severity Level=16

Error Type =304, Error Description %d' is out of range for index option '%.*ls'. See sp_configure option '%ls' for valid values.. Error Severity Level=16

Error Type =305, Error Description The XML data type cannot be compared or sorted, except when using the IS NULL operator.. Error Severity Level=16

Error Type =306, Error Description The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.. Error Severity Level=16

Error Type =307, Error Description Index ID %d on table '%.*ls' (specified in the FROM clause) does not exist.. Error Severity Level=16

Error Type =308, Error Description Index '%.*ls' on table '%.*ls' (specified in the FROM clause) does not exist.. Error Severity Level=16

Error Type =309, Error Description Cannot use index "%.*ls" on table "%.*ls" in a hint. XML indexes are not allowed in hints.. Error Severity Level=16

Error Type =310, Error Description The value <MAXRECURSION value> specified for the MAXRECURSION option exceeds the allowed maximum of %d.. Error Severity Level=16

Error Type =311, Error Description Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables.. Error Severity Level=16

Error Type =312, Error Description Cannot reference text, ntext, or image columns in a filter stored procedure.. Error Severity Level=16

Error Type =313, Error Description An insufficient number of arguments were supplied for the procedure or function %.*ls.. Error Severity Level=16

Error Type =314, Error Description Cannot use GROUP BY ALL with the special tables INSERTED or DELETED.. Error Severity Level=16

Error Type =315, Error Description Index "%.*ls" on table "%.*ls" (specified in the FROM clause) is disabled or resides in a filegroup which is not online.. Error Severity Level=16

Error Type =316, Error Description The index ID %d on table "%.*ls" (specified in the FROM clause) is disabled or resides in a filegroup which is not online.. Error Severity Level=16

Error Type =317, Error Description Table-valued function '<Function Name>' cannot have a column alias.. Error Severity Level=16

Error Type =318, Error Description The table (and its columns) returned by a table-valued method need to be aliased.. Error Severity Level=16

Error Type =319, Error Description Incorrect syntax near the keyword 'with'. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.. Error Severity Level=16

Error Type =320, Error Description The compile-time variable value for '%.*ls' in the OPTIMIZE FOR clause must be a literal.. Error Severity Level=16

Error Type =321, Error Description %.*ls is not a recognized table hints option. If it is intended as a parameter to a table-valued function or to the CHANGETABLE function, ensure that your database compatibility mode is set to 90.. Error Severity Level=15

Error Type =322, Error Description The variable "%.*ls" is specified in the OPTIMIZE FOR clause, but is not used in the query.. Error Severity Level=16

Error Type =323, Error Description The 'COMPUTE' clause is not allowed in a statement containing an INTERSECT or EXCEPT operator.. Error Severity Level=16

Error Type =324, Error Description The 'ALL' version of the %.*ls operator is not supported.. Error Severity Level=15

Error Type =325, Error Description Incorrect syntax near '%.*ls'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the SET COMPATIBILITY_LEVEL option of ALTER DATABASE.. Error Severity Level=15

Error Type =326, Error Description Multi-part identifier '%.*ls' is ambiguous. Both columns '%.*ls' and '%.*ls' exist.. Error Severity Level=16

Error Type =327, Error Description Function call '%.*ls' is ambiguous: both a user-defined function and a method call with this name exist.. Error Severity Level=16

Error Type =328, Error Description A cursor plan could not be generated for the given statement because the textptr() function was used on a LOB column from one of the base tables.. Error Severity Level=16

Error Type =329, Error Description Each GROUP BY expression must contain at least one column reference.. Error Severity Level=16

Error Type =330, Error Description The target '<Object Name>' of the OUTPUT INTO clause cannot be a view or common table expression.. Error Severity Level=15

Error Type =331, Error Description The target table '<Table Name>' of the OUTPUT INTO clause cannot have any enabled triggers.. Error Severity Level=15

Error Type =332, Error Description The target table '<Table Name>' of the OUTPUT INTO clause cannot be on either side of a (primary key, foreign key) relationship. Found reference constraint '<Primary Key or Foreign Key Constraint Name>'.. Error Severity Level=15

Error Type =333, Error Description The target table '<Table Name>' of the OUTPUT INTO clause cannot have any enabled check constraints or any enabled rules. Found check constraint or rule '<CHECK Constraint Name>'.. Error Severity Level=15

Error Type =334, Error Description The target table '<Table Name>' of the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause.. Error Severity Level=15

Error Type =335, Error Description Function call cannot be used to match a target table in the FROM clause of a DELETE or UPDATE statement. Use function name '%.*ls' without parameters instead.. Error Severity Level=16

Error Type =336, Error Description Incorrect syntax near '%.*ls'. If this is intended to be a common table expression, you need to explicitly terminate the previous statement with a semi-colon.. Error Severity Level=15

Error Type =337, Error Description Warning: the floating point value '%.*ls' is too small. It will be interpreted as 0.. Error Severity Level=10

Error Type =338, Error Description READEXT, WRITETEXT, and UPDATETEXT statements cannot be used with views, remote tables, and inserted or deleted tables inside triggers.. Error Severity Level=16

Error Type =339, Error Description DEFAULT or NULL are not allowed as explicit identity values.. Error Severity Level=16

Error Type =340, Error Description Cannot create the trigger "%.*ls" on view "%.*ls". AFTER triggers cannot be created on views.. Error Severity Level=16

Error Type =341, Error Description Replication filter procedures may not contain columns of large object, large value, XML or CLR type.. Error Severity Level=16

Error Type =342, Error Description Column "%.*ls" is not allowed in this context, and the user-defined function or aggregate "%.*ls" could not be found.. Error Severity Level=16

Error Type =343, Error Description Unknown object type '%.*ls' used in a CREATE, DROP, or ALTER statement.. Error Severity Level=16

Error Type =344, Error Description Remote function reference '%.*ls' is not allowed, and the column name '%.*ls' could not be found or is ambiguous.. Error Severity Level=16

Error Type =345, Error Description Function '%.*ls' is not allowed in the OUTPUT clause, because it performs user or system data access, or is assumed to perform this access. A function is assumed by default to perform data access if it is not schemabound.. Error Severity Level=16

Error Type =346, Error Description The parameter "<Parameter Name>" can not be declared READONLY since it is not a table-valued parameter.. Error Severity Level=15

Error Type =347, Error Description The table-valued parameter "%.*ls" cannot be declared as an OUTPUT parameter.. Error Severity Level=16

Error Type =348, Error Description The table variable "%.*ls" can not be passed to a stored procedure with the OUTPUT option.. Error Severity Level=16

Error Type =349, Error Description The procedure "%.*ls" has no parameter named "%.*ls".. Error Severity Level=16

Error Type =350, Error Description The column "%.*ls" does not have a valid data type. A column cannot be of a user-defined table type.. Error Severity Level=16

Error Type =351, Error Description Column, parameter, or variable %.*ls. : Cannot find data type %.*ls.. Error Severity Level=16

Error Type =352, Error Description The table-valued parameter "%.*ls" must be declared with the READONLY option.. Error Severity Level=15

Error Type =353, Error Description Function '%.*ls' is not allowed in the %S_MSG clause when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement. This is because the function performs user or system data access, or is assumed to perform this access. By default, a function is assumed to perform data access if it is not schema-bound.. Error Severity Level=16

Error Type =354, Error Description The target '%.*ls' of the INSERT statement cannot be a view or common table expression when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.. Error Severity Level=15

Error Type =355, Error Description The target table '<Table Name>' of the INSERT statement cannot have any enabled triggers when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.. Error Severity Level=15

Error Type =356, Error Description The target table '%.*ls' of the INSERT statement cannot be on either side of a (primary key, foreign key) relationship when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement. Found reference constraint '%ls'.. Error Severity Level=15

Error Type =357, Error Description The target table '%.*ls' of the INSERT statement cannot have any enabled rules when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement. Found rule '%ls'.. Error Severity Level=15

Error Type =358, Error Description The target table '%.*ls' of the MERGE statement cannot have any enabled rules. Found rule '%ls'.. Error Severity Level=15

Error Type =359, Error Description The target '%.*ls' of an OUTPUT INTO clause has an index with the ignore_dup_key option and cannot be used when an OUTPUT clause is also used.. Error Severity Level=15

Error Type =360, Error Description The target column list of an INSERT, UPDATE, or MERGE statement cannot contain both a sparse column and the column set that contains the sparse column. Rewrite the statement to include either the sparse column or the column set, but not both.. Error Severity Level=15

Error Type =361, Error Description The number of target columns that are specified in an INSERT, UPDATE, or MERGE statement exceeds the maximum of %d. This total number includes identity, timestamp, and columns that have default values. To correct this error, change the query to target a sparse column set instead of single sparse columns.. Error Severity Level=16

Error Type =362, Error Description The query processor could not produce a query plan because the name '%.*ls' in the FORCESEEK hint on table or view '<Object Name>' did not match the key column names of the index '<Index Name>'.. Error Severity Level=16

Error Type =363, Error Description The query processor could not produce a query plan because the FORCESEEK hint on table or view '<Object Name>' cannot be used with the %S_MSG specified by index '%.*ls'.. Error Severity Level=16

Error Type =364, Error Description The query processor could not produce a query plan because the FORCESEEK hint on view '<View Name>' is used without a NOEXPAND hint. Resubmit the query with the NOEXPAND hint or remove the FORCESEEK hint on the view.. Error Severity Level=16

Error Type =365, Error Description The query processor could not produce a query plan because the FORCESEEK hint on table or view '<Object Name>' specified more seek columns than the number of key columns in index '%.*ls'.. Error Severity Level=16

Error Type =366, Error Description The query processor could not produce a query plan because the FORCESEEK hint on table or view '<Object Name>' cannot be used with the column store index '%.*ls'.. Error Severity Level=16

Error Type =401, Error Description Unimplemented statement or expression %ls.. Error Severity Level=16

Error Type =402, Error Description The data types %s and %s are incompatible in the %s operator.. Error Severity Level=16

Error Type =403, Error Description Invalid operator for data type. Operator equals add, type equals text.. Error Severity Level=16

Error Type =404, Error Description The column reference "inserted.%.*ls" is not allowed because it refers to a base table that is not being modified in this statement.. Error Severity Level=16

Error Type =405, Error Description A remote table cannot be used as a DML target in a statement which includes an OUTPUT clause or a nested DML statement.. Error Severity Level=16

Error Type =406, Error Description %ls cannot be used in the PIVOT operator because it is not invariant to NULLs.. Error Severity Level=16

Error Type =407, Error Description Internal error. The string routine in file %hs, line %d failed with HRESULT 0x%x.. Error Severity Level=16

Error Type =408, Error Description A constant expression was encountered in the ORDER BY list, position %i.. Error Severity Level=16

Error Type =409, Error Description The %ls operation cannot take a %ls data type as an argument.. Error Severity Level=16

Error Type =410, Error Description COMPUTE clause #%d 'BY' expression #%d is not in the order by list.. Error Severity Level=20

Error Type =411, Error Description COMPUTE clause #%d, aggregate expression #%d is not in the select list.. Error Severity Level=16

Error Type =412, Error Description The column "%.*ls" is not updatable because it is derived or constant.. Error Severity Level=16

Error Type =413, Error Description Correlated parameters or sub-queries are not supported by the inline function "%.*ls".. Error Severity Level=16

Error Type =414, Error Description UPDATE is not allowed because the statement updates view "%.*ls" which participates in a join and has an INSTEAD OF UPDATE trigger.. Error Severity Level=16

Error Type =415, Error Description DELETE is not allowed because the statement updates view "%.*ls" which participates in a join and has an INSTEAD OF DELETE trigger.. Error Severity Level=16

Error Type =416, Error Description The service queue "%.*ls" cannot be directly updated.. Error Severity Level=16

Error Type =417, Error Description TOP is not allowed in an UPDATE or DELETE statement against a partitioned view.. Error Severity Level=16

Error Type =418, Error Description Objects exposing CLR type columns are not allowed in distributed queries. Use a pass-through query to access the remote object '%.*ls'.. Error Severity Level=16

Error Type =420, Error Description The text, ntext, and image data types cannot be used in an ORDER BY clause.. Error Severity Level=16

Error Type =421, Error Description The text/ntext/image data type cannot be selected as DISTINCT because it is not comparable.. Error Severity Level=16

Error Type =422, Error Description Common table expression defined but not used.. Error Severity Level=16

Error Type =423, Error Description Xml data type methods are not supported in check constraints. Create a scalar user-defined function to wrap the method invocation. The error occurred at table "%.*ls".. Error Severity Level=16

Error Type =424, Error Description Xml data type methods are not supported in computed column definitions of table variables and return tables of table-valued functions. The error occurred at column "%.*ls", table "%.*ls", in the %ls statement.. Error Severity Level=16

Error Type =425, Error Description Data type %ls of receiving variable is not equal to the data type %ls of column '%.*ls'.. Error Severity Level=16

Error Type =426, Error Description The length %d of the receiving variable is less than the length %d of the column '%.*ls'.. Error Severity Level=16

Error Type =427, Error Description Could not load sysprocedures entries for constraint ID %d in database ID %d.. Error Severity Level=20

Error Type =428, Error Description Could not find row in sysconstraints for constraint ID %d in database ID %d.. Error Severity Level=20

Error Type =429, Error Description Could not find new constraint ID %d in sysconstraints, database ID %d, at compile time.. Error Severity Level=20

Error Type =430, Error Description Could not resolve table name for object ID %d, database ID %d, when compiling foreign key.. Error Severity Level=20

Error Type =431, Error Description Could not bind foreign key constraint. Too many tables involved in the query.. Error Severity Level=19

Error Type =432, Error Description Xml data type methods are not supported in check constraints anymore. Please drop the constraint or create a scalar user-defined function to wrap the method invocation. The error occurred at table "%.*ls".. Error Severity Level=16

Error Type =433, Error Description Could not find CHECK constraint for '%.*ls', although the table is flagged as having one.. Error Severity Level=20

Error Type =434, Error Description Function '%ls' is not allowed in the OUTPUT clause.. Error Severity Level=16

Error Type =435, Error Description Xml data type methods are not supported in computed column definitions. Create a scalar user-defined function to wrap the method invocation. The error occurred at column "%.*ls", table "%.*ls", in the %ls statement.. Error Severity Level=16

Error Type =436, Error Description Could not open referenced table ID %d in database ID %d.. Error Severity Level=20

Error Type =437, Error Description Could not resolve the referenced column name in table ID %d.. Error Severity Level=20

Error Type =438, Error Description Could not resolve the referencing column name in table ID %d.. Error Severity Level=20

Error Type =439, Error Description Could not find FOREIGN KEY constraints for table '%.*ls' in database ID %d although the table is flagged as having them.. Error Severity Level=20

Error Type =440, Error Description Internal query compilation error. The stack overflow could not be handled.. Error Severity Level=16

Error Type =441, Error Description Cannot use the '%ls' function on a remote data source.. Error Severity Level=16

Error Type =442, Error Description The NEST argument must be a column reference. Expressions are not allowed.. Error Severity Level=16

Error Type =443, Error Description Invalid use of 'getdate' within a function.

Invalid use of 'INSERT' within a function.

Invalid use of 'UPDATE' within a function.. Error Severity Level=16

Error Type =444, Error Description Select statements included within a function cannot return data to a client.. Error Severity Level=16

Error Type =445, Error Description COLLATE clause cannot be used on expressions containing a COLLATE clause.. Error Severity Level=16

Error Type =446, Error Description Cannot resolve collation conflict for %ls operation.. Error Severity Level=16

Error Type =447, Error Description Expression type %ls is invalid for COLLATE clause.. Error Severity Level=16

Error Type =448, Error Description Invalid collation '%.*ls'.. Error Severity Level=16

Error Type =449, Error Description Collation conflict caused by collate clauses with different collation '%.*ls' and '%.*ls'.. Error Severity Level=16

Error Type =450, Error Description Code page translations are not supported for the text data type. From: %d To: %d.. Error Severity Level=16

Error Type =451, Error Description Cannot resolve collation conflict for column %d in %ls statement.. Error Severity Level=16

Error Type =452, Error Description COLLATE clause cannot be used on user-defined data types.. Error Severity Level=16

Error Type =453, Error Description Collation '%.*ls' is supported on Unicode data types only and cannot be set at the database or server level.. Error Severity Level=16

Error Type =454, Error Description The UNNEST argument must be a nested table column.. Error Severity Level=16

Error Type =455, Error Description The last statement included within a function must be a return statement.. Error Severity Level=16

Error Type =456, Error Description Implicit conversion of %ls value to %ls cannot be performed because the resulting collation is unresolved due to collation conflict.. Error Severity Level=16

Error Type =457, Error Description Implicit conversion of %ls value to %ls cannot be performed because the collation of the value is unresolved due to a collation conflict.. Error Severity Level=16

Error Type =458, Error Description Cannot create the SELECT INTO target table "%.*ls" because the xml column "%.*ls" is typed with a schema collection "%.*ls" from database "%.*ls". Xml columns cannot refer to schemata across databases.. Error Severity Level=16

Error Type =459, Error Description Collation '%.*ls' is supported on Unicode data types only and cannot be applied to char, varchar or text data types.. Error Severity Level=16

Error Type =460, Error Description DISTINCT operator is not allowed in the recursive part of a recursive common table expression '<Common Table Expression Name>'.. Error Severity Level=16

Error Type =461, Error Description TOP operator is not allowed in the recursive part of a recursive common table expression '<Common Table Expression Name>'.. Error Severity Level=16

Error Type =462, Error Description Outer join is not allowed in the recursive part of a recursive common table expression '<Common Table Expression Name>'.. Error Severity Level=16

Error Type =463, Error Description Functions with parameters are not allowed in the recursive part of a recursive common table expression '%.*ls'.. Error Severity Level=16

Error Type =464, Error Description Functions with side effects are not allowed in the recursive part of a recursive common table expression '%.*ls'.. Error Severity Level=16

Error Type =465, Error Description Recursive references are not allowed in subqueries.. Error Severity Level=16

Error Type =466, Error Description UNION operator is not allowed in the recursive part of a recursive common table expression '%.*ls'.. Error Severity Level=16

Error Type =467, Error Description GROUP BY, HAVING, or aggregate functions are not allowed in the recursive part of a recursive common table expression '<CTE Name>'.. Error Severity Level=16

Error Type =468, Error Description Cannot resolve the collation conflict between "%.*ls" and "%.*ls" in the %ls operation.. Error Severity Level=16

Error Type =469, Error Description An explicit column list must be specified for target table '%.*ls' when table hint KEEPIDENTITY is used and the table contains an identity column.. Error Severity Level=16

Error Type =470, Error Description The synonym "<Synonym Name>" referenced synonym "<Synonym Name>". Synonym chaining is not allowed.. Error Severity Level=16

Error Type =471, Error Description Only one of the three options, SINGLE_BLOB, SINGLE_CLOB or SINGLE_NCLOB, can be specified.. Error Severity Level=16

Error Type =472, Error Description Either a format file or one of the three options SINGLE_BLOB, SINGLE_CLOB, or SINGLE_NCLOB must be specified.. Error Severity Level=16

Error Type =473, Error Description The incorrect value "%.*ls" is supplied in the PIVOT operator.. Error Severity Level=16

Error Type =474, Error Description Unable to load the computed column definitions for table "%.*ls".. Error Severity Level=16

Error Type =475, Error Description Invalid SAMPLE clause. Only table names in the FROM clause of SELECT, UPDATE, and DELETE queries may be sampled.. Error Severity Level=16

Error Type =476, Error Description Invalid PERCENT tablesample size "<sample_number>" for table "<Table Name>". The PERCENT tablesample size must be between 0 and 100.. Error Severity Level=16

Error Type =477, Error Description Invalid ROWS value or REPEATABLE seed in the TABLESAMPLE clause for table "<Table Name>". The value or seed must be an integer.. Error Severity Level=16

Error Type =478, Error Description The TABLESAMPLE clause cannot be used in a view definition or inline table function definition.. Error Severity Level=16

Error Type =479, Error Description Invalid ROWS value or REPEATABLE seed "%I64d" in the TABLESAMPLE clause for table "%.*ls". The value or seed must be greater than 0.. Error Severity Level=16

Error Type =480, Error Description The TABLESAMPLE clause cannot be used with the table function "%.*ls".. Error Severity Level=16

Error Type =481, Error Description The TABLESAMPLE clause cannot be used with the linked server table "%.*ls".. Error Severity Level=16

Error Type =482, Error Description Non-constant or invalid expression is in the TABLESAMPLE or the REPEATABLE clause.. Error Severity Level=16

Error Type =483, Error Description The OUTPUT clause cannot be used in an INSERT...EXEC statement.. Error Severity Level=16

Error Type =484, Error Description Cannot declare more than %d local variables.. Error Severity Level=16

Error Type =485, Error Description Views and inline functions cannot return xml columns that are typed with a schema collection registered in a database other than current. Column "%.*ls" is typed with the schema collection "%.*ls", which is registered in database "%.*ls".. Error Severity Level=16

Error Type =486, Error Description %.*ls does not allow specifying a schema name as a prefix to the assembly name.. Error Severity Level=16

Error Type =487, Error Description An invalid option was specified for the statement "%.*ls".. Error Severity Level=16

Error Type =488, Error Description %s columns must be comparable. The type of column "%.*ls" is "%s", which is not comparable.. Error Severity Level=16

Error Type =489, Error Description The OUTPUT clause cannot be specified because the target view "%.*ls" is a partitioned view.. Error Severity Level=16

Error Type =490, Error Description The resync functionality is temporarily disabled.. Error Severity Level=16

Error Type =491, Error Description A correlation name must be specified for the bulk rowset in the from clause.. Error Severity Level=16

Error Type =492, Error Description Duplicate column names are not allowed in result sets obtained through OPENQUERY and OPENROWSET. The column name "%.*ls" is a duplicate.. Error Severity Level=16

Error Type =493, Error Description The column '%.*ls' that was returned from the nodes() method cannot be used directly. It can only be used with one of the four XML data type methods, exist(), nodes(), query(), and value(), or in IS NULL and IS NOT NULL checks.. Error Severity Level=16

Error Type =494, Error Description The TABLESAMPLE clause can only be used with local tables.. Error Severity Level=16

Error Type =495, Error Description The return table column "%.*ls" is not the same type as the type it was created with. Drop and recreate the module using a two-part name for the type, or use sp_refreshsqlmodule to refresh its parameters metadata.. Error Severity Level=16

Error Type =496, Error Description The parameter "%.*ls" is not the same type as the type it was created with. Drop and recreate the module using a two-part name for the type, or use sp_refreshsqlmodule to refresh its parameters metadata.. Error Severity Level=16

Error Type =497, Error Description Variables are not allowed in the TABLESAMPLE or REPEATABLE clauses.. Error Severity Level=16

Error Type =498, Error Description Invalid value in the TABLESAMPLE or the REPEATABLE clause.. Error Severity Level=16

Error Type =499, Error Description Invalid parameter for the getchecksum function.. Error Severity Level=16

Error Type =500, Error Description Trying to pass a table-valued parameter with %d column(s) where the corresponding user-defined table type requires %d column(s).. Error Severity Level=16

Sql Server DBA Interview Question more than 1000

Question 1. What Is The Difference Between Lock, Block And Deadlock?

Solution -

Lock: DB engine locks the rows / page / table to access 

the data which is worked upon according to the query.

Block: When one process blocks the resources of another

process then the situation occured is called blocking. Blocking can be identified by using the following query

SELECT * FROM sys.dm_exec_requests 

where blocked <> 0
SELECT * FROM master..sysprocesses 

where blocked <> 0

Deadlock: When something happens as follows:

 Error 1205 is reported by SQL Server for deadlock.

Question 2. what is the sequence of SQL statement are processed in SQL Server?

Solution - The clauses of the select are processed in 

the following sequence

1. FROM clause
2. WHERE clause
3. GROUP BY clause
4. HAVING clause
5. SELECT clause
6. ORDER BY clause
7. TOP clause

Question 3. on which TCP/IP port does SQL Server run?

Solution - By default SQL Server runs on port 1433. 

But according to requirement is can be changed such as we have more than one instance of SQL Server, 

Then  differenet port can be assigned to different Instances

Python pattern from from incresing and descresing sequnce of numbers

This post will explain the logic, code and Syntax for pattern program in Python Programming. In this post you will understand how to right the code of a pattern which have the sequence in  descreasing and incresinng sequence.

 Pattern Code-

def python_pattern(n):
    for i in range(0, n):
        if n/2 >= i:
            for j in range(1, i+1):
                print(j, end=" ")
            print("\r")
        else:
            for j in range(1, n - i + 1):
                print(j, end=" ")
            print("\r")
n=10python_pattern(n)

Output:

1

1 2

1 2 3

1 2 3 4

1 2 3 4 5

1 2 3 4

1 2 3

1 2

1

Youtube Video of Complete Program

See Also-Python patthern program of all types

Palindrome number program in Pythan

In this post i will explain the palindome number program in python and also to expalin the same i also created a youtube video so you can check also complete step by step and also output in IDE. 

Palindrome number program in Pythan

Palindrome No Program in Python-

num = int(input("enter a number: "))
temp = num
rev = 0while temp:
    rev = (rev * 10) + (temp % 10)
    temp = temp // 10if num == rev:
    print("No is palindrome")
else:
    print("No is not palindrome")

Output-

When entered Item is- 747

   No is Palindrome.

when entered Item is- 67

   No is notb Palindrome.

See Also-Pythan All type of program

SQL SERVER High Availability (HA)

High Availability (HA)  of the server of  Database is the solution( process, technology ) to make the application database available 24x7 under either planned or un - planned conditions.   

There are five type of options in MS SQL Server to achieve and configure a setup for high availability solution for the databases. 

Replication 
The source(Main) data will be copied to destination, through replication agents (jobs). Object level technology. 
Main terminology 

1.  Publisher is source server. 
2.  Distributor is optional and stores replicated data in a suitble environemt for the subscriber.  
3.  Subscriber is the destination server. 

Log Shipping 
The source data will be copied to destination through Transaction Log backup jobs. Various Database level technology. 
Main terminology 

1.  Primary server is source server. 
2.  Secondary server is destination server.
3.  Monitor server is optional and will be monitored by log   shipping status.  

Mirroring 
The primary data will be copied to a secondary through a network transaction basis with help of mirroring endpoint and port number. Database level technology. 
Main terminology 

1.  Principal server is source server always. 
2.  Mirror server is destination server always.
3.  Witness server is optional and can be used to make automatic  failover. 

Clustering 
The data will be stored in shared location which is used by both primary and secondary servers based on availability of the server. Instance level technology. Windows Clustering setup is required with shared storage 
Main terminology 

1.  Active node is where SQL Services are running.
2.  Passive node is where SQL Services are not running. 

AlwaysON Availability Groups 
 The primary data will be copied to secondary through network transaction basisand  Group of database level technology. Windows Clustering setup is required without shared storage for ALwaysON Availibilty Groups. 
Main terminology 

1.  Primary replica is source server.
2.  Secondary replica is destination server. 

Check Java Pattern Program

JAVA Triangle * Pattern Program Logic Sixth Programming Logic and Code with Syntax

JAVA Triangle * Pattern Program Logic Fifth with Code Programming Logic and Code with Syntax

JAVA Triangle * Pattern Program Logic Four Programming Logic and Code with Syntax

JAVA Triangle * Pattern Program Logic Three Programming Logic and Code with Syntax

https://www.dizsweb.com/2019/07/java-triangle-pattern-program-logic-two.html

JAVA Triangle * Pattern Program Logic one Programming Logic and Code with Syntax

JAVA Sqaure * Pattern Program Programming Logic and Code with Syntax

Sql Server error 276