Extracting Configuration/Initialization Statements
Go Up to Working with Configuration/initialization Parameters
You can extract the following statement types corresponding to the DBMS-specific methods for setting server configuration/initialization parameters.
SET... SET GLOBAL... | |
ALTER SYSTEM SET | |
RECONFIGURE/GO/EXEC sp_configure | |
EXEC sp_configure |
To extract configuration/initialization parameter statements
- Open the Datasource Explorer as configuration/parameter nodes are not visible in the Navigator. For more information, see Working with Bookmarks.
- Connect to the datasource for which you want to view the server configuration/initialization parameters or options. For details, see Connecting to Datasources.
- Display the configuration/initialization parameters or options for the server. For details, see Working with Configuration/initialization Parameters.
- The server configuration parameters are displayed in the right pane of the Explorer.
- In the right pane of the Explorer, right-click one or more selected parameters and select Extract. The DDL Editor opens. For more information, see Using the SQL Editor.
For related information, see Modifying Configuration/Initialization Parameters and Options.