single: 'True' ensures only one user has access to the database at a time. Any subsequent users will be refused : Database Option « Database « SQL Server / T-SQL
single: 'True' ensures only one user has access to the database at a time. Any subsequent users will be refused
1> --single: 'True' ensures only one user has access to the database at a time. Any subsequent users will be refused.
2>
3> CREATE DATABASE myDatabase
4> EXEC sp_dboption 'myDatabase', 'single', 'False'
5> GO
1>
2> Drop database myDatabase
3> GO
1>