What is SQL Server service?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is SQL Server service?
Rating:
SQL Server 2005 runs as SQL Server service on Windows Server 2000 or Windows Server 2003. The SQL Server service starts as soon as an instance of SQL Server database engine is started. Users can make new connections only after the SQL Server service is started. In a default instance the service is referred to as MSSQL SERVER, whereas in case of a named instance it is referred to as MSSQLS <instance name>. The SQL Server service can be started and stopped locally as well as remotely.
Rating:
Was this information helpful?
Other articles
- What is Replication Monitor?
- What is GROUP BY clause?
- What is a unique index?
- What is the Distribution agent?
- What is a nonclustered index?