Category: SQL Server
SQL Server Error Code – 8939 table error: object id %d, index id %d,
In this blog post, you’ll learn more about the SQL Server Error Code 8939 and the error message description that is shown SQL Server Error Code 8939 SQL Server Error Description for the Code :8939 Table error: Object ID %d, index ID %d, partition ID %I64d, alloc unit ID %I64d (type %.*ls), page %S_PGID. Test (%.*ls) failed. Values are %ld and %ld.
SQL Server Error Code – 41014 failed to enumerate the windows server f
In this blog post, you’ll learn more about the SQL Server Error Code 41014 and the error message description that is shown SQL Server Error Code 41014 SQL Server Error Description for the Code :41014 Failed to enumerate the Windows Server Failover Clustering (WSFC) resources (Error code %d). If this is a WSFC availability group, the WSFC service may not be running or may not…
SQL Server 2014 Tutorial – Open SQL Server Instance Port in Windows Firewall
Problem Statement You need open the SQL Server Instance port number in Windows Firewall so that you can connect to SQL Server from another machine. Solution When you try to connect to the SQL Server instance from another machine , you might receive the connection timeout error . To allow the users of other machine to connect to your SQL Server instance , you need…
SQL Server Error Code – 9325 %scomputed processing instruction constr
In this blog post, you’ll learn more about the SQL Server Error Code 9325 and the error message description that is shown SQL Server Error Code 9325 SQL Server Error Description for the Code :9325 %sComputed processing instruction constructors are not supported.
SQL Server Error Code – 11427 the online alter column operation cannot
In this blog post, you’ll learn more about the SQL Server Error Code 11427 and the error message description that is shown SQL Server Error Code 11427 SQL Server Error Description for the Code :11427 The online ALTER COLUMN operation cannot be performed for table ‘%.*ls’ because column ‘%.*ls’ currently has or is getting altered into an unsupported datatype: text, ntext, image, CLR type or…
SQL Server Error Code – 14869 must be db owner to use the remota_data_
In this blog post, you’ll learn more about the SQL Server Error Code 14869 and the error message description that is shown SQL Server Error Code 14869 SQL Server Error Description for the Code :14869 Must be DB OWNER to use the REMOTA_DATA_ARCHIVE_OVERRIDE hint.
Getting all the Foreign Key constraints list of a table in SQL Server
You might need to write a T-SQL Query to retrieve all the foreign key constraints of a given table in SQL Server. For these cases , you can use the sp_fkeys stored procedure. How to get all the Foreign Key constraints list of a table in SQL Server ?
SQL Server Error Code – 254 prefixed columns are not allowed in the
In this blog post, you’ll learn more about the SQL Server Error Code 254 and the error message description that is shown SQL Server Error Code 254 SQL Server Error Description for the Code :254 Prefixed columns are not allowed in the column list of a PIVOT operator.
SQL Server Error Code – 469 an explicit column list must be specifie
In this blog post, you’ll learn more about the SQL Server Error Code 469 and the error message description that is shown SQL Server Error Code 469 SQL Server Error Description for the Code :469 An explicit column list must be specified for target table ?%.*ls? when table hint KEEPIDENTITY is used and the table contains an identity column.
SQL Server Error Code – 13159 countersignature
In this blog post, you’ll learn more about the SQL Server Error Code 13159 and the error message description that is shown SQL Server Error Code 13159 SQL Server Error Description for the Code :13159 countersignature
SQL Server Error Code – 15622 no permission to access database ‘%s’.
In this blog post, you’ll learn more about the SQL Server Error Code 15622 and the error message description that is shown SQL Server Error Code 15622 SQL Server Error Description for the Code :15622 No permission to access database ‘%s’.
SQL Server Error Code – 41607 operation timed out while waiting for %l
In this blog post, you’ll learn more about the SQL Server Error Code 41607 and the error message description that is shown SQL Server Error Code 41607 SQL Server Error Description for the Code :41607 Operation timed out while waiting for %ls access to the cached information in the replica controller (Windows Fabric replica ID 0x%08X, partition ID %ls). If this condition persists, contact the…
SQL Server Error Code – 12327 comparison, sorting, and manipulation of
In this blog post, you’ll learn more about the SQL Server Error Code 12327 and the error message description that is shown SQL Server Error Code 12327 SQL Server Error Description for the Code :12327 Comparison, sorting, and manipulation of character strings that do not use a *_BIN2 collation is not supported with %S_MSG.
SQL Server Error Code – 25703 the event session option, “%.*ls”, has a
In this blog post, you’ll learn more about the SQL Server Error Code 25703 and the error message description that is shown SQL Server Error Code 25703 SQL Server Error Description for the Code :25703 The event session option, “%.*ls”, has an invalid value. Correct the value and re-issue the statement.
SQL Server Error Code – 41308 the database id %d already exists.
In this blog post, you’ll learn more about the SQL Server Error Code 41308 and the error message description that is shown SQL Server Error Code 41308 SQL Server Error Description for the Code :41308 The database ID %d already exists.
SQL Server Error Code – 4038 cannot find file id %d on device ‘%ls’.
In this blog post, you’ll learn more about the SQL Server Error Code 4038 and the error message description that is shown SQL Server Error Code 4038 SQL Server Error Description for the Code :4038 Cannot find file ID %d on device ‘%ls’.
SQL Server Error Code – 11501 the batch could not be analyzed because
In this blog post, you’ll learn more about the SQL Server Error Code 11501 and the error message description that is shown SQL Server Error Code 11501 SQL Server Error Description for the Code :11501 The batch could not be analyzed because of compile errors.
SQL Server Error Code – 19104 all protocols are disabled.
In this blog post, you’ll learn more about the SQL Server Error Code 19104 and the error message description that is shown SQL Server Error Code 19104 SQL Server Error Description for the Code :19104 All protocols are disabled.
SQL Server Error Code – 1798 federated tables cannot be created in a
In this blog post, you’ll learn more about the SQL Server Error Code 1798 and the error message description that is shown SQL Server Error Code 1798 SQL Server Error Description for the Code :1798 Federated tables cannot be created in a non-federated database.
SQL Server Error Code – 3753 cannot %s_msg the federation member ?%.*
In this blog post, you’ll learn more about the SQL Server Error Code 3753 and the error message description that is shown SQL Server Error Code 3753 SQL Server Error Description for the Code :3753 Cannot %S_MSG the federation member ?%.*ls?, because the federation root does not exist.