SQL Server Error Msg 35372 – You cannot create more than one clustered index on %S_MSG ‘%.*ls’. Consider creating a new clustered index using ‘with (drop_existing = on)’ option.

In this blog post, let’s learn about the error message “35372 – You cannot create more than one clustered index on %S_MSG ‘%.*ls’. Consider creating a new clustered index using ‘with (drop_existing = on)’ option.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.

SQL Server Error Message

35372 – You cannot create more than one clustered index on %S_MSG ‘%.*ls’. Consider creating a new clustered index using ‘with (drop_existing = on)’ option.

Reason for the Error

To be update soon…

Solution

To be update soon…