SQL Server Error Msg 20543 – @rowcount_only parameter must be the value 0,1, or 2. 0=7.0 compatible checksum. 1=only check rowcounts. 2=new checksum functionality introduced in version 8.0.

In this blog post, let’s learn about the error message “20543 – @rowcount_only parameter must be the value 0,1, or 2. 0=7.0 compatible checksum. 1=only check rowcounts. 2=new checksum functionality introduced in version 8.0.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

20543 – @rowcount_only parameter must be the value 0,1, or 2. 0=7.0 compatible checksum. 1=only check rowcounts. 2=new checksum functionality introduced in version 8.0.

Reason for the Error

To be update soon…

Solution

To be update soon…