Q:- What are the Default Services in SQL
Server 2012 ?
If this questions is related for Interview then this can be
tricky because as per configuration manager the default services related to SQL
server are 4 (DB Engine, Full text, Browser and Agent Service).
To check run compmgmt.msc from CMD Prompt and select SQL
Server Configuration Property. Then List of Services will show like below
But when we check Control Panel or OS Internal will show
many more. When we install SQL Server 2012 there are some certain program which
will install and we can find out all these from control panel. Below is the
list of service names installed in SQL server web edition under windows 8
Desktop System.
We can also use PowerShell to get it
Start Power-shell form application list and run below Command.
PS: C:\User\Suman> Get-WmiObject Win32_Product | select name >>abc.txt
Now give next Command
PS: C:\User\Suman> Notepad abc.txt
Then List of Services related to SQL Server Display Look
like below:-
1.Microsoft SQL Server 2005 Compact Edition [ENU]
2.Microsoft SQL Server 2008 R2 Management Objects
3.Microsoft SQL Server 2008 Setup Support Files
4.Microsoft SQL Server 2012 Command Line Utilities
5.Microsoft SQL Server 2012 Data-Tier App Framework
6.Microsoft SQL Server 2012 Express LocalDB
7.Microsoft SQL Server 2012 Management Objects
8.Microsoft SQL Server 2012 Management Objects (x64)
9.Microsoft SQL Server 2012 Native Client
10.Microsoft SQL Server 2012 Policies
11.Microsoft SQL Server 2012 Setup (English)
12.Microsoft SQL Server 2012 Transact-SQL Compiler Service
13.Microsoft SQL Server 2012 Transact-SQL ScriptDom
14.Microsoft SQL Server 2012 T-SQL Language Service
15.Microsoft SQL Server Compact 4.0 SP1 x64 ENU
16.Microsoft SQL Server Data Tools – Database Projects – Web installer entry point
17.Microsoft SQL Server Data Tools - enu (11.1.20627.00)
18.Microsoft SQL Server Data Tools Build Utilities - enu (11.1.20627.00)
19.Microsoft SQL Server System CLR Types
20.Microsoft SQL Server System CLR Types (x64)
21.Microsoft System CLR Types for SQL Server 2012
22.SQL Server 2012 BI Development Studio
23.SQL Server 2012 Client Tools
24.SQL Server 2012 Common Files
25.SQL Server 2012 Data quality client
26.SQL Server 2012 Database Engine Services
27.SQL Server 2012 Database Engine Shared
28.SQL Server 2012 Distributed Replay
29.SQL Server 2012 Documentation Components
30.SQL Server 2012 Full text search
31.SQL Server 2012 Management Studio
32.SQL Server 2012 Reporting Services
33.SQL Server 2012 SQL Data Quality Common
34.SQL Server Browser for SQL Server 2012
35.SQL Server Customer Experience Improvement Program
|
Nice Work
ReplyDeleteFor more ORACLE Database Interview Questions and Answers visit:DBA interview questions
Thank you so much
Delete