How do I get configuration information from a SQL Server? (NETIQKB1578)

How do I get configuration information from a SQL Server?

Following are simple statements that can be used to gather important configuration information from a SQL Server. This information can be useful when trying to determine if the SQL server configuration is suitable for the AppManager Repository database. Open any SQL Query Tool and select the QDB database. Run the following commands to obtain specific information. To get the SQL Server's version, language configuration, catalog version, etc.:

sp_server_info

To get the SQL Server's memory and performance tuning information:

sp_configure

To get the current space used for a database:

sp_spaceused @updateusage = true

To get the default Sort Order and Character Set for the SQL Server:

sp_helpsort

To get details on a given database or device:

sp_helpdb
sp_helpdevice

To display information for a given login_id or all users and processes:

sp_who2

Formerly known as NETIQKB1578