What is the sp_dboption stored procedure?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is the sp_dboption stored procedure?
Rating:
The sp_dboption stored procedure is used to display or change the options of a database. It can be used to modify the configurations and settings of a database. Modifications in the settings of master and tempdb databases are not recommended through this stored procedure. In order to display the information, users must be members of the public role, and to modify the information, users need to be members of the db_owner role.
Rating:
Was this information helpful?
Other articles
- What is the READ UNCOMMITTED isolation level?
- What is security log?
- What is page restore?
- What is a clustered index?
- What is Disk Cleanup?