Home » SQL Server » Page 21

SQL Server

sql server DBA 999

SQL Server Error : 1996, Severity: 16. Could not create index enforcing primary

SQL Server Error : 1996 Details

SQL Server Error: 1996 Severity: 16 Event Logged or not: No Description: Could not create index enforcing primary key constraint ‘%.*ls’ using DROP_EXISTING option because table has an XML or spatial index. Drop the XML or spatial index, create the primary key contstraint, and recreate the XML or spatial 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 … Read the rest

sql server DBA 999

SQL Server Error : 1995, Severity: 16. Cannot rebuild hypothetical index ‘%.*ls

SQL Server Error : 1995 Details

SQL Server Error: 1995 Severity: 16 Event Logged or not: No Description: Cannot rebuild hypothetical index ‘%.*ls’ 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. Value of error log … Read the rest

sql server DBA 999

SQL Server Error : 1994, Severity: 16. Cannot create or update statistics on vi

SQL Server Error : 1994 Details

SQL Server Error: 1994 Severity: 16 Event Logged or not: No Description: Cannot create or update statistics on view “%.*ls” because both FULLSCAN and NORECOMPUTE options are required. 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

sql server DBA 999

SQL Server Error : 1993, Severity: 16. Cannot partition an index on a table var

SQL Server Error : 1993 Details

SQL Server Error: 1993 Severity: 16 Event Logged or not: No Description: Cannot partition an index on a table variable or return table definition in table valued function. 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

sql server DBA 999

SQL Server Error : 1991, Severity: 16. Cannot disable clustered index ‘%.*ls’ o

SQL Server Error : 1991 Details

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

sql server DBA 999

SQL Server Error : 1990, Severity: 16. Cannot define an index on a view with ig

SQL Server Error : 1990 Details

SQL Server Error: 1990 Severity: 16 Event Logged or not: No Description: Cannot define an index on a view with ignore_dup_key index option. Remove ignore_dup_key option and verify that view definition does not allow duplicates, or do not index view. 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
Read the rest

sql server DBA 999

SQL Server Error : 1989, Severity: 16. Cannot enable foreign key constraint ‘%.

SQL Server Error : 1989 Details

SQL Server Error: 1989 Severity: 16 Event Logged or not: No Description: Cannot enable foreign key constraint ‘%.*ls’ as index ‘%.*ls’ on referenced key is disabled. 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 … Read the rest

sql server DBA 999

SQL Server Error : 1988, Severity: 16. Cannot rebuild clustered index ‘%.*ls’ o

SQL Server Error : 1988 Details

SQL Server Error: 1988 Severity: 16 Event Logged or not: No Description: Cannot rebuild clustered index ‘%.*ls’ online because it is disabled. 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 DBA 999

SQL Server Error : 1987, Severity: 16. Cannot %S_MSG %S_MSG ‘%.*ls’ on %S_MSG ‘

SQL Server Error : 1987 Details

SQL Server Error: 1987 Severity: 16 Event Logged or not: No Description: Cannot %S_MSG %S_MSG ‘%.*ls’ on %S_MSG ‘%.*ls’ because its %S_MSG is disabled. 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 DBA 999

SQL Server Error : 1985, Severity: 16. Cannot create %S_MSG on view ‘%.*ls’. It

SQL Server Error : 1985 Details

SQL Server Error: 1985 Severity: 16 Event Logged or not: No Description: Cannot create %S_MSG on view ‘%.*ls’. It contains one or more XML data type methods. 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 … Read the rest