SQL Server Error Code – 1731 cannot create the sparse column ?%.*ls?

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

SQL Server Error Code

1731

SQL Server Error Description for the Code :1731

Cannot create the sparse column ?%.*ls? in the table ?%.*ls? because an option or data type specified is not valid. A sparse column must be nullable and cannot have the ROWGUIDCOL, IDENTITY, or FILESTREAM properties. A sparse column cannot be of the following data types: text, ntext, image, geometry, geography, or user-defined type.