SQL Server Properties (General Tab)
Use this tab to view or specify the following options.
Options
Name
View the name of the instance of Microsoft® SQL Server™.
Product
View the product name.
Operating system
View the operating system on which the server is running.
Product version
View the version of the instance of SQL Server.
Language
View the default language for the product.
Platform
View the platform on which the product runs.
OS memory
View the available operating system memory.
Processors
View the number of processors.
Root directory
View the root directory.
Server collation
View the type of collation that the instance of SQL Server is using.
Autostart SQL Server
Automatically start the instance of SQL Server when Microsoft Windows NT® 4.0 or Windows® 2000 starts.
Autostart SQL Server Agent
Automatically start SQL Server Agent when Windows NT 4.0 or Windows 2000 starts.
Autostart MSDTC
Automatically start Microsoft Distributed Transaction Coordinator (MS DTC) when Windows NT 4.0 or Windows 2000 starts.
Startup parameters
Display the Server Parameters dialog box.
Network Configuration
Start the SQL Server Network Utility.