Category: SQL Server
SQL Server Error Code – 41831 data migration on table id %d failed eit
In this blog post, you’ll learn more about the SQL Server Error Code 41831 and the error message description that is shown SQL Server Error Code 41831 SQL Server Error Description for the Code :41831 Data migration on table id %d failed either fully or partially. See errorlog for details.
How to return the SHA1 hash value of a string in SQL Server ?
SQL Server provides a function HashBytes function that returns the SHA1 , MD2 , MD4 and few other hash value of the specified input. How to return the SHA1 hash value of a string in SQL Server ? Just pass the ‘SHA1’ as the first parameter and the input as second parameter value to the HashBytes function to get the SHA1 hash value.
SQL Server Error Code – 22843 alter table switch statement failed beca
In this blog post, you’ll learn more about the SQL Server Error Code 22843 and the error message description that is shown SQL Server Error Code 22843 SQL Server Error Description for the Code :22843 ALTER TABLE SWITCH statement failed because the partitioned source table is enabled for Change Data Capture and does not have @allow_partition_switch set to 1.
SQL Server Error Code – 4836 warning: table “%.*s” is published for m
In this blog post, you’ll learn more about the SQL Server Error Code 4836 and the error message description that is shown SQL Server Error Code 4836 SQL Server Error Description for the Code :4836 Warning: Table “%.*s” is published for merge replication. Reinitialize affected subscribers or execute sp_addtabletocontents to ensure that data added is included in the next synchronization.
SQL Server Error Code – 14041 the ‘%s’ property can only be changed if
In this blog post, you’ll learn more about the SQL Server Error Code 14041 and the error message description that is shown SQL Server Error Code 14041 SQL Server Error Description for the Code :14041 The ‘%s’ property can only be changed if the publication is enabled for heterogeneous subscriptions. The publication is not enabled.
SQL Server Error Code – 21808 for a .net assembly business logic handl
In this blog post, you’ll learn more about the SQL Server Error Code 21808 and the error message description that is shown SQL Server Error Code 21808 SQL Server Error Description for the Code :21808 For a .NET Assembly Business Logic Handler, the @resolver_info must contain the class name in ‘%s’ that implements the Microsoft.SqlServer.Replication.BusinessLogicSupport.BusinessLogicModule interface.
SQL Server Error Code – 29243 configuration manager quiesce operation
In this blog post, you’ll learn more about the SQL Server Error Code 29243 and the error message description that is shown SQL Server Error Code 29243 SQL Server Error Description for the Code :29243 Configuration manager quiesce operation failed.
SQL Server Error Code – 472 either a format file or one of the three
In this blog post, you’ll learn more about the SQL Server Error Code 472 and the error message description that is shown SQL Server Error Code 472 SQL Server Error Description for the Code :472 Either a format file or one of the three options SINGLE_BLOB, SINGLE_CLOB, or SINGLE_NCLOB must be specified.
SQL Server Error Code – 6998 invalid type definition: type or content
In this blog post, you’ll learn more about the SQL Server Error Code 6998 and the error message description that is shown SQL Server Error Code 6998 SQL Server Error Description for the Code :6998 Invalid type definition: Type or content model ‘%s’ is too complicated. It may be necessary to reduce the number of enumerations or the size of the content model.
SQL Server Error Code – 14064 found generation stuck at genstatus 4.
In this blog post, you’ll learn more about the SQL Server Error Code 14064 and the error message description that is shown SQL Server Error Code 14064 SQL Server Error Description for the Code :14064 Found generation stuck at genstatus 4.
SQL Server Error Code – 4842 the required formatfile property is miss
In this blog post, you’ll learn more about the SQL Server Error Code 4842 and the error message description that is shown SQL Server Error Code 4842 SQL Server Error Description for the Code :4842 The required FormatFile property is missing from the provider string of the server.
SQL Server Error Code – 5302 mutator ‘%.*ls’ on ‘%.*ls’ cannot be cal
In this blog post, you’ll learn more about the SQL Server Error Code 5302 and the error message description that is shown SQL Server Error Code 5302 SQL Server Error Description for the Code :5302 Mutator ‘%.*ls’ on ‘%.*ls’ cannot be called on a null value.