SQL Server Error : 2020 Details

SQL Server Error: 2020 Severity: 16 Event Logged or not: No Description: The dependencies reported for entity “%.*ls” do not include references to columns. This is either because the entity references an object that does not exist or because of an error in one or more statements in the entity. Before rerunning the query, ensure that there are no errors in the entity and that all objects referenced by the entity exist. Severity 16 Description: Indicates general errors that can be corrected by the user.

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done … Read the rest

SQL Server Error : 2014 Details

SQL Server Error: 2014 Severity: 16 Event Logged or not: No Description: Remote access is not allowed from within a schema-bound object. Severity 16 Description: Indicates general errors that can be corrected by the user.

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL Server.

USE master
Go
xp_readerrorlog 0, 1, N'Logging SQL Server messages in file', NULL, NULL, N'asc'
Go

The parameters for XP_READERRRORLOG are:
1. … Read the rest

SQL Server Error : 2011 Details

SQL Server Error: 2011 Severity: 16 Event Logged or not: No Description: Index hints cannot be specified within a schema-bound object. Severity 16 Description: Indicates general errors that can be corrected by the user.

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL Server.

USE master
Go
xp_readerrorlog 0, 1, N'Logging SQL Server messages in file', NULL, NULL, N'asc'
Go

The parameters for XP_READERRRORLOG are:
1. Value … Read the rest

SQL Server Error : 2010 Details

SQL Server Error: 2010 Severity: 16 Event Logged or not: No Description: Cannot perform alter on ‘%.*ls’ because it is an incompatible object type. Severity 16 Description: Indicates general errors that can be corrected by the user.

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL Server.

USE master
Go
xp_readerrorlog 0, 1, N'Logging SQL Server messages in file', NULL, NULL, N'asc'
Go

The parameters for XP_READERRRORLOG … Read the rest

SQL Server Error : 2008 Details

SQL Server Error: 2008 Severity: 16 Event Logged or not: No Description: The object ‘%.*ls’ is not a procedure so you cannot create another procedure under that group name. Severity 16 Description: Indicates general errors that can be corrected by the user.

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL Server.

USE master
Go
xp_readerrorlog 0, 1, N'Logging SQL Server messages in file', NULL, NULL, N'asc'… Read the rest

SQL Server Error : 2004 Details

SQL Server Error: 2004 Severity: 16 Event Logged or not: No Description: Procedure ‘%.*ls’ has already been created with group number %d. Create procedure with an unused group number. Severity 16 Description: Indicates general errors that can be corrected by the user.

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL Server.

USE master
Go
xp_readerrorlog 0, 1, N'Logging SQL Server messages in file', NULL, NULL, N'asc'… Read the rest

SQL Server Error : 2003 Details

SQL Server Error: 2003 Severity: 16 Event Logged or not: No Description: Procedures with a group number cannot have parameters of XML or CLR types. Parameter ‘%.*ls’ of procedure ‘%.*ls’ has type ‘%ls’. Severity 16 Description: Indicates general errors that can be corrected by the user.

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL Server.

USE master
Go
xp_readerrorlog 0, 1, N'Logging SQL Server messages in … Read the rest

SQL Server Error : 2002 Details

SQL Server Error: 2002 Severity: 16 Event Logged or not: No Description: Cannot create a procedure for replication with group number greater than one. Severity 16 Description: Indicates general errors that can be corrected by the user.

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL Server.

USE master
Go
xp_readerrorlog 0, 1, N'Logging SQL Server messages in file', NULL, NULL, N'asc'
Go

The parameters for XP_READERRRORLOG … Read the rest

SQL Server Error : 1999 Details

SQL Server Error: 1999 Severity: 16 Event Logged or not: No Description: Column ‘%.*ls’ in table ‘%.*ls’ is of a type that is invalid for use as included column in an index. Severity 16 Description: Indicates general errors that can be corrected by the user.

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL Server.

USE master
Go
xp_readerrorlog 0, 1, N'Logging SQL Server messages in file', … Read the rest

SQL Server Error : 1997 Details

SQL Server Error: 1997 Severity: 16 Event Logged or not: No Description: Could not convert the XML or spatial index ‘%.*ls’ to a relational index by using the DROP_EXISTING option. Drop the XML or spatial index and create a relational index with the same name. Severity 16 Description: Indicates general errors that can be corrected by the user.

Reading sql server error log location from SQL Query

Identifying SQL Server Error Log File used by SQL Server Database Engine can be done by reading SQL Server Error Logs. DBA can execute the XP_READERRORLOG extended stored procedure to read the SQL Server Error Log and search for its location used by the instance of SQL … Read the rest