Category: SQL Server
How do you check if an index exists in a table?
You can find out if the index exists for a table by querying the sys.indexes table as shown in this blog post’s code sample. How do you check if an index exists in a table? This will list out all the indexes of the table.
SQL Server Error Code – 686 the maximum level of the b-tree for rows
In this blog post, you’ll learn more about the SQL Server Error Code 686 and the error message description that is shown SQL Server Error Code 686 SQL Server Error Description for the Code :686 The maximum level of the B-Tree for rowset %I64d has been reached. SQL Server only supports upto 255 levels.
SQL Server Error Code – 40575 data type ‘%.*ls’ is not supported in a
In this blog post, you’ll learn more about the SQL Server Error Code 40575 and the error message description that is shown SQL Server Error Code 40575 SQL Server Error Description for the Code :40575 Data type ‘%.*ls’ is not supported in a federated database.
SQL Server Error Code – 7723 only a single filegroup can be specified
In this blog post, you’ll learn more about the SQL Server Error Code 7723 and the error message description that is shown SQL Server Error Code 7723 SQL Server Error Description for the Code :7723 Only a single filegroup can be specified while creating partition scheme using option ALL to specify all the filegroups.
SQL Server Error Code – 12016 creating a %s_msg index requires that th
In this blog post, you’ll learn more about the SQL Server Error Code 12016 and the error message description that is shown SQL Server Error Code 12016 SQL Server Error Description for the Code :12016 Creating a %S_MSG index requires that the primary key in the base table satisfy the following restrictions. The maximum number of primary-key columns is %d. The maximum combined per-row size…
SQL Server Error Code – 15433 supplied parameter sid is in use.
In this blog post, you’ll learn more about the SQL Server Error Code 15433 and the error message description that is shown SQL Server Error Code 15433 SQL Server Error Description for the Code :15433 Supplied parameter sid is in use.
SQL Server Error Code – 19481 failed to obtain the wsfc resource state
In this blog post, you’ll learn more about the SQL Server Error Code 19481 and the error message description that is shown SQL Server Error Code 19481 SQL Server Error Description for the Code :19481 Failed to obtain the WSFC resource state for cluster resource with name or ID ‘%.*ls’. The WSFC resource state API returned error code %d. The WSFC service may not be…
SQL Server Error Code – 26048 server local connection provider is read
In this blog post, you’ll learn more about the SQL Server Error Code 26048 and the error message description that is shown SQL Server Error Code 26048 SQL Server Error Description for the Code :26048 Server local connection provider is ready to accept connection on [ %s ].
SQL Server Error Code – 41834 alter table has failed for ‘%.*ls’ with
In this blog post, you’ll learn more about the SQL Server Error Code 41834 and the error message description that is shown SQL Server Error Code 41834 SQL Server Error Description for the Code :41834 ALTER TABLE has failed for ‘%.*ls’ with error code %d.
SQL Server Error Code – 46616 job_tracker_location
In this blog post, you’ll learn more about the SQL Server Error Code 46616 and the error message description that is shown SQL Server Error Code 46616 SQL Server Error Description for the Code :46616 JOB_TRACKER_LOCATION
SQL Server Error Code – 6582 assembly ‘%.*s’ is not visible for creat
In this blog post, you’ll learn more about the SQL Server Error Code 6582 and the error message description that is shown SQL Server Error Code 6582 SQL Server Error Description for the Code :6582 Assembly ‘%.*s’ is not visible for creating SQL objects. Use ALTER ASSEMBLY to change the assembly visibility.
SQL Server Error Code – 8947 table error: multiple iam pages for obje
In this blog post, you’ll learn more about the SQL Server Error Code 8947 and the error message description that is shown SQL Server Error Code 8947 SQL Server Error Description for the Code :8947 Table error: Multiple IAM pages for object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls) contain allocations for the same interval. IAM pages %S_PGID…