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.
Leave Your Comment