When you first load SQL SERVER you will startup with what
all databases?
Answers were Sorted based on User's Feedback
Answer / mobin sathupally
When we install SQL SERVER totally we got six databases.
Among six four are system databases and remaining two are
user defined databases,
The system databases are 1.Master
2.Model
3.Msdb and
4.Tempdb.
The user defined databases are 1.Northwind and
2.Pubs.
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / rajesh s. chandan
It depends of Microsoft SQLm Server version.
When we install Microsoft SQL Server 2008 then SQL Server
installer will install following database.
System databases
1.master
2.model
3.msdb
4.tempdb
If we configure replication then it will create
distribution database.
When we install Reporting Services (SSRS) , then it will
install ReportServer and ReportServerTempDB. We could also
install sample databases like AdventureWorks and
AdventureWorksDW.
Whenever, we restart the SQL Server, it will freshly create
tempdb database. Hope this information will help you.
Is This Answer Correct ? | 0 Yes | 0 No |
What about UPDATESTATISTICS ?
What are the various editions of sql server 2017 that are available in the market?
How you can add messages to the nt event log from within a stored procedure?
what is bit data type? and what are the information that can be stored inside a bit column?
from the table display the 2nd highest salary? and also the least 2nd salay?
What is collation?
What is the difference between clustered and a non-clustered index?
What is db stored procedure?
What are commonly used odbc functions in php?
Do you know what are the reporting services components?
if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?
Mention the differences between substr and charindex in sql server.