Microsoft® SQL Server™ has several other startup features. You can use the default startup options provided by SQL Server Setup, or you can override these options temporarily. For example, if you experience problems with system databases that should be repaired, you can use the -m option, which starts SQL Server in single-user mode.
You can also run SQL Server on a network. Microsoft Windows NT® starts its built-in SQL Server Service automatically when Windows NT starts. However, if you want to connect to a stand-alone SQL Server from a local client such as osql, you can bypass the network and connect directly to SQL Server using a local pipe, or without a network.