Please answer the following five-point questions:

  1. Where MS SQL system settings are stored (data from DatabaseSettingspageofSQLServerProperties )
  2. What algorithm is used for hashing MS SQL passwords
  3. Where are the backup settings (schedule and settings)
  4. How can you find out what rights are given to the user (system privileges, rights to tables, etc.)
  5. Where information is stored on the linked database (i.e. current connection status, connection parameters)

    1 answer 1

    1. In the master database. Watch sys views.
    2. Do not know. In principle, the options are not so much MD or SHASHA1
    3. In the msdb database. There are all the data of the agent and other services.
    4. Well, if it's not about stupidly looking in the manager, you can query sys-tables (or as recommended by MS - sys views), for example sysusers. As well as a series of security procedures
    5. sys.servers view