Databases Reference
In-Depth Information
Second screen:
How to do it...
Follow the steps given here to perform this recipe:
1.
Execute the following query to show you some of the instance-level
configuration options:
sp_configure
GO
2. To see the full list of all configuration options available with the
SP_Configure
stored procedure, execute the following query:
sp_configure 'show advanced options', 1;
GO
RECONFIGURE WITH OVERRIDE;
GO
Search WWH ::
Custom Search