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 are the disadvantages of cursors? : Sql server database administration
Difference between Cluster and Non-cluster index?
32 Answers Accenture, Agility e-Services, eClinicalWorks, HCL, Infosys, Oracle, Satyam, Yardi,
What is mean by "fill factor" ? and what is mean by "Index "in sql?
What is the purpose of UPDATE STATISTICS?
State a few properties of relational databases?
How do you rebuild an identity column?
How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????
What is the maximum length of an alert name?
How to create a view with data from multiple tables?
Find columns used in stored procedure?
What is msdb database? : SQL Server Architecture
What is normalization? Explain its different types?