ALTER DATABASE MODIFY FILEGROUP [filegroup] AUTOGROW_ALL_FILES Does anyone know of a way to accomplish setting a filegroup to AUTOGROW_ALL_FILES without setting the database to single user mode?  I frequently add new filegroups/files to a 24/7 production database where killing active sessions and rolling back transactions (via SET SINGLE_USER WITH ROLLBACK IMMEDIATE) is definitely not preferred.  IMO this operation should be able to be accomplished with other active sessions on the database.
It seems there is no way around it.  This is per an offline conversation with Paul Randal from SQL Skills.  So that would mean I would need to either have no other open sessions on the db, or set it to single user mode prior to running the set statement.  Thanks for the assistance Paul.