Microsoft SQL Server database ranks third in the relational database, second only to Oracle and MySQL database. when using it, it is inevitable to encounter various problems and warnnings. You may be dba or a developer, I hope this content can help you solve SQL Server error number 12100.

Error number: 12100

Severity level: 16

Event logged: ALTER DATABASE failed because FILESTREAM filegroups cannot be added to a database that has either the READ_COMMITTED_SNAPSHOT or the ALLOW_SNAPSHOT_ISOLATION option set to ON. To add FILESTREAM filegroups, you must set READ_COMMITTED_SNAPSHOT and ALLOW_SNAPSHOT_ISOLATION to OFF.