Itqualityassurance
- How do I show advanced options?
- How to show advanced options on Sp_configure?
- What is the use of Sp_configure in SQL Server?
- How do I disable Ole automation procedures?
How do I show advanced options?
The Advanced Boot Options screen lets you start Windows in advanced troubleshooting modes. You can access the menu by turning on your computer and pressing the F8 key before Windows starts. Some options, such as safe mode, start Windows in a limited state, where only the bare essentials are started.
How to show advanced options on Sp_configure?
Use the show advanced options option to display the sp_configure system stored procedure advanced options. When you set show advanced options to 1, you can list the advanced options by using sp_configure. The default is 0. The setting takes effect immediately without a server restart.
What is the use of Sp_configure in SQL Server?
Use sp_configure to display or change server-level settings. To change database-level settings, use ALTER DATABASE . To change settings that affect only the current user session, use the SET statement.
How do I disable Ole automation procedures?
Since OLE Automation is a built-in feature, there is no actual way to prevent the activation of the feature. It is recommended to add monitoring for the events of re-enabling the configuration & recreating the extended procedures and granting execution on the procedures.
