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.

What are the hotfixes and patches in sql server?

0 Answers  

---

Determine when an index is appropriate?

0 Answers  

---

How can sql injection be stopped? : sql server security

0 Answers  

---

Does a server store data?

0 Answers  

---

What is query and its types?

0 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

3 Answers  

---

Write an sql query to find first weekday of the month?

0 Answers  

---

What is statement level trigger?

0 Answers  

---

What are the differences between local and global temporary tables?

0 Answers  

---

difference between truncate, delete aur drop?

2 Answers  

---

Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,

---

How to execute the cursor queries with "open" statements?

0 Answers  

---