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.

Answer / sonia

guess what you want to ask is that what are the databases
that come by default? 4 - Master, Model, msdb, tempdb.

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.

How get current date in SQL server 2000

4 Answers   Cap Gemini, Polaris,

---

What to check if a User database is locked?

0 Answers   TCS,

---

What is factless fact table? : sql server analysis services, ssas

0 Answers  

---

What are the new features in SQL Server 2005?

3 Answers   Emphasis,

---

Tell me what are cursors and when they are useful?

0 Answers  

---

How you would rewrite the sql query to return the customerid sorted numerically?

0 Answers  

---

What are the ways available in sql server to execute sql statements?

0 Answers  

---

Is port 1433 secure?

0 Answers  

---

How to rebuild all indexes on a single table?

0 Answers  

---

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

0 Answers  

---

Does a full backup include transaction log?

0 Answers  

---

Why Master database is required?

0 Answers   Abacus,

---