Category: SQL Server

SQL Server Error Code – 21779 cannot use the specified data type mappi

In this blog post, you’ll learn more about the SQL Server Error Code 21779 and the error message description that is shown SQL Server Error Code 21779 SQL Server Error Description for the Code :21779 Cannot use the specified data type mapping. The matching destination data type for source type %s cannot be found. Query the system table msdb.dbo.sysdatatypemappings for a list of supported mappings….

SQL Server Error Code – 10737 in an alter table rebuild or alter index

In this blog post, you’ll learn more about the SQL Server Error Code 10737 and the error message description that is shown SQL Server Error Code 10737 SQL Server Error Description for the Code :10737 In an ALTER TABLE REBUILD or ALTER INDEX REBUILD statement, when a partition is specified in a DATA_COMPRESSION clause, PARTITION=ALL must be specified. The PARTITION=ALL clause is used to reinforce…