Category: SQL Server

SQL Server Error Code – 2110 cannot alter trigger ?%.*ls? on ?%.*ls?

In this blog post, you’ll learn more about the SQL Server Error Code 2110 and the error message description that is shown SQL Server Error Code 2110 SQL Server Error Description for the Code :2110 Cannot alter trigger ?%.*ls? on ?%.*ls? because this trigger does not belong to this object. Specify the correct trigger name or the correct target object name.

SQL Server Error Code – 4081 the parameter ‘%.*ls’ was deduced to be

In this blog post, you’ll learn more about the SQL Server Error Code 4081 and the error message description that is shown SQL Server Error Code 4081 SQL Server Error Description for the Code :4081 The parameter ‘%.*ls’ was deduced to be a table-valued parameter, which cannot be sent by client driver versions earlier than SQL Server 2008. Please resubmit the query using a more…

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 – 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.