Category: SQL Server
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’.