SQL Server

SQL Server Error : 1973 Details

SQL Server Error: 1973 Severity: 16 Event Logged or not: No Description: Cannot perform the specified operation on disabled index ‘%.*ls’ on %S_MSG ‘%.*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 file', NULL, NULL, N'asc'… Read the rest

SQL Server Error : 1972 Details

SQL Server Error: 1972 Severity: 16 Event Logged or not: No Description: Cannot disable clustered index ‘%.*ls’ on table ‘%.*ls’. Permission denied to alter the referencing view ‘%.*ls’ while disabling its clustered 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, … Read the rest

SQL Server Error : 1971 Details

SQL Server Error: 1971 Severity: 16 Event Logged or not: No Description: Cannot disable index ‘%.*ls’ on table ‘%.*ls’. Permission denied to disable foreign key ‘%.*ls’ on table ‘%.*ls’ that uses this 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 … Read the rest

SQL Server Error : 1969 Details

SQL Server Error: 1969 Severity: 16 Event Logged or not: No Description: Default FILESTREAM filegroup is not available in database ‘%.*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 file', NULL, NULL, N'asc'
Go

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

SQL Server Error : 1968 Details

SQL Server Error: 1968 Severity: 16 Event Logged or not: No Description: Cannot convert a nonclustered index to a clustered index online using DROP_EXISTING option. 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 … Read the rest

SQL Server Error : 1967 Details

SQL Server Error: 1967 Severity: 16 Event Logged or not: No Description: Cannot create a new clustered index on a view online. 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 : 1966 Details

SQL Server Error: 1966 Severity: 16 Event Logged or not: No Description: Cannot create %S_MSG on view ‘%.*ls’. The view contains an imprecise aggregate operator. 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 … Read the rest

SQL Server Error : 1965 Details

SQL Server Error: 1965 Severity: 16 Event Logged or not: No Description: Cannot create %S_MSG on view “%.*ls”. The view contains an imprecise arithmetic operator. 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 … Read the rest

SQL Server Error : 1964 Details

SQL Server Error: 1964 Severity: 16 Event Logged or not: No Description: Cannot create %S_MSG on view “%.*ls”. The view contains an imprecise constant. 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 : 1963 Details

SQL Server Error: 1963 Severity: 16 Event Logged or not: No Description: Cannot create %S_MSG on view “%.*ls”. The view contains a convert that is imprecise or non-deterministic. 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… Read the rest