SQL Server Error Code – 4984 alter table switch statement failed. tar

AbundantCode 2 weeks ago in SQL Server 0

In this blog post, you’ll learn more about the SQL Server Error Code 4984 and the error message description that is shown

SQL Server Error Code

4984

SQL Server Error Description for the Code :4984

ALTER TABLE SWITCH statement failed. Target table ‘%.*ls’ and source table ‘%.*ls’ have different vardecimal storage format values. Use stored procedure sp_tableoption to alter the ‘vardecimal storage format’ option for the tables to make sure that the values are the same.

Tags :

Leave Your Comment