operations cannot be performed on the master database:

Published on by LakshmiSaahul,Dhana Royal

  • Adding files or filegroups.

  • Changing collation. The default collation is the server collation.

  • Changing the database owner. master is owned by sa.

  • Creating a full-text catalog or full-text index.

  • Creating triggers on system tables in the database.

  • Dropping the database.

  • Dropping the guest user from the database.

  • Enabling change data capture.

  • Participating in database mirroring.

  • Removing the primary filegroup, primary data file, or log file.

  • Renaming the database or primary filegroup.

  • Setting the database to OFFLINE.

  • Setting the database or primary filegroup to READ_ONLY.

Advertising
To be informed of the latest articles, subscribe:
Comment on this post