Category: SQL Server
SQL Server Error Code – 3996 snapshot isolation level is not supporte
In this blog post, you’ll learn more about the SQL Server Error Code 3996 and the error message description that is shown SQL Server Error Code 3996 SQL Server Error Description for the Code :3996 Snapshot isolation level is not supported for distributed transaction. Use another isolation level or do not use distributed transaction.
SQL Server Error Code – 6803 for xml explicit requires the first colu
In this blog post, you’ll learn more about the SQL Server Error Code 6803 and the error message description that is shown SQL Server Error Code 6803 SQL Server Error Description for the Code :6803 FOR XML EXPLICIT requires the first column to hold positive integers that represent XML tag IDs.
SQL Server Error Code – 14202 before or after @active_start_time
In this blog post, you’ll learn more about the SQL Server Error Code 14202 and the error message description that is shown SQL Server Error Code 14202 SQL Server Error Description for the Code :14202 before or after @active_start_time
SQL Server Error Code – 14502 the @target_name parameter must be suppl
In this blog post, you’ll learn more about the SQL Server Error Code 14502 and the error message description that is shown SQL Server Error Code 14502 SQL Server Error Description for the Code :14502 The @target_name parameter must be supplied when specifying an @enum_type of ‘TARGET’.
SQL Server Error Code – 872 buffer pool extension is already enabled
In this blog post, you’ll learn more about the SQL Server Error Code 872 and the error message description that is shown SQL Server Error Code 872 SQL Server Error Description for the Code :872 Buffer pool extension is already enabled. No action is necessary.
SQL Server Error Code – 7116 offset %d is not in the range of availab
In this blog post, you’ll learn more about the SQL Server Error Code 7116 and the error message description that is shown SQL Server Error Code 7116 SQL Server Error Description for the Code :7116 Offset %d is not in the range of available LOB data.
SQL Server Error Code – 20036 the distributor has not been installed c
In this blog post, you’ll learn more about the SQL Server Error Code 20036 and the error message description that is shown SQL Server Error Code 20036 SQL Server Error Description for the Code :20036 The Distributor has not been installed correctly.
SQL Server Error Code – 27041 no error tolerant index metadata provide
In this blog post, you’ll learn more about the SQL Server Error Code 27041 and the error message description that is shown SQL Server Error Code 27041 SQL Server Error Description for the Code :27041 No Error Tolerant Index metadata provided for serialization. The index is probably corrupt.
SQL Server 2014 Tutorial – Display System Databases in Object Explorer.
Problem Statement You need to view the System Databases in Object Explorer. Solution By default , there are few System databases that gets created when you install SQL Server. Some of these databases are master – This is the primary system database which is needed for the SQL Server to start and work fine. It contains the information about databases , logins , configurations etc….
SQL Server Error Code – 3926 the transaction active in this session h
In this blog post, you’ll learn more about the SQL Server Error Code 3926 and the error message description that is shown SQL Server Error Code 3926 SQL Server Error Description for the Code :3926 The transaction active in this session has been committed or aborted by another session.
SQL Server Error Code – 7921 repair statement not processed. database
In this blog post, you’ll learn more about the SQL Server Error Code 7921 and the error message description that is shown SQL Server Error Code 7921 SQL Server Error Description for the Code :7921 Repair statement not processed. Database cannot be a snapshot.
SQL Server Error Code – 11547 only one statement can be used as input
In this blog post, you’ll learn more about the SQL Server Error Code 11547 and the error message description that is shown SQL Server Error Code 11547 SQL Server Error Description for the Code :11547 Only one statement can be used as input parameter to sp_showmemo_xml. Modify the input parameter and re-run the stored procedure.
SQL Server Error Code – 13598 temporal system_time period cannot be de
In this blog post, you’ll learn more about the SQL Server Error Code 13598 and the error message description that is shown SQL Server Error Code 13598 SQL Server Error Description for the Code :13598 Temporal SYSTEM_TIME period cannot be defined on history table ‘%.*ls’.
SQL Server Error Code – 33002 access to %ls %ls is blocked because the
In this blog post, you’ll learn more about the SQL Server Error Code 33002 and the error message description that is shown SQL Server Error Code 33002 SQL Server Error Description for the Code :33002 Access to %ls %ls is blocked because the signature is not valid.
SQL Server Error Code – 40201 destination server name is too long.
In this blog post, you’ll learn more about the SQL Server Error Code 40201 and the error message description that is shown SQL Server Error Code 40201 SQL Server Error Description for the Code :40201 Destination server name is too long.
SQL Server Error Code – 41115 cannot create the availability group nam
In this blog post, you’ll learn more about the SQL Server Error Code 41115 and the error message description that is shown SQL Server Error Code 41115 SQL Server Error Description for the Code :41115 Cannot create the availability group named ‘%.*ls’ because its availability group ID (ID: ‘%.*ls’) already exists in a system table.
SQL Server Error Code – 21751 cannot publish view %s as a table becaus
In this blog post, you’ll learn more about the SQL Server Error Code 21751 and the error message description that is shown SQL Server Error Code 21751 SQL Server Error Description for the Code :21751 Cannot publish view %s as a table because it does not have a unique clustered index. Publish the view as a view, or add a unique clustered index.
SQL Server Error Code – 22920 the named capture instance %s does not e
In this blog post, you’ll learn more about the SQL Server Error Code 22920 and the error message description that is shown SQL Server Error Code 22920 SQL Server Error Description for the Code :22920 The named capture instance %s does not exist for database %s.
SQL Server Error Code – 22925 the number of columns captured by captur
In this blog post, you’ll learn more about the SQL Server Error Code 22925 and the error message description that is shown SQL Server Error Code 22925 SQL Server Error Description for the Code :22925 The number of columns captured by capture instance ‘%s’ exceeds the maximum allowed number: %d. Use the @captured_columns_list parameter to specify a subset of the columns less than or equal…
SQL Server Error Code – 35005 an invalid value null was passed in for
In this blog post, you’ll learn more about the SQL Server Error Code 35005 and the error message description that is shown SQL Server Error Code 35005 SQL Server Error Description for the Code :35005 An invalid value NULL was passed in for @server_group_id.